The defined scope of work (SOW) includes Data Warehousing ETL (Extract, Transform and Load) and Report Development. Responsibilities and deliverables include:
- Develop and maintains the interfaces and data extracts from business source systems into the enterprise reporting systems using Informatica tool.
- Design and write programs and scripts required to extract, transform, clean and move data from the business systems into the PDMI data warehouse/data mart.
- Participate in requirement meetings with Business Analysts to understand analytical content needs. Assist in documenting these requirements, resolving ambiguities and conflicts, and ensuring requirements are complete.
- Work with end-users to help identify issues and to refine requirements.
- Develop detailed ETL specifications based on business requirements.
- Analyze functional specifications and assist in designing effective technical solutions.
- Identify data sources and works with source system developers, SMEs, and business owners to define data extraction methodologies.
- Work with Data / Data Warehouse Architect on logical and physical model designs.
- Work with Data Modeler to develop data warehouse models, design specifications, metadata process and documentation
- Utilize the Informatica ETL application and analyze data necessary to resolve issues uncovered and related to source data.
- Define, develop, document and maintain Informatica ETL mappings and scripts.
- Define, develop, document and maintain procedural and SQL programs.
- Develop ETL test plans and tests the ETL code following ETL standards and architecture.
- Assist in the development, execution and documentation of system and integration test plans.
- Perform ETL / Informatica tuning as well as SQL tuning.
- Optimize Informatica code performance and processing methods.
- Perform design validation, reconciliation and error handling in the load process (initial, incremental).
- Update and maintains ETL Metadata.
- Provide input into standards and best practices for code development.
- Write technical specifications and updates release documentation to reflect technical modifications.
- Perform impact analysis for systems/database modifications.
- Assist with and promotes continuous quality improvement throughout the lifecycle.
- Demonstrate success working in a team-based environment.