ETL Developer (Informatica)

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.