BayInfotech
ETL Developer (Informatica)
BayInfotech, Foster City, California, United States, 94420
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.
• 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.