ETL/Informatica Analyst Developer

Overview In this contract role you will serve as an ETL subject-matter expert, designing and delivering Informatica-based solutions for client projects. You will translate business needs into analytical applications and support BI initiatives, including data warehouse modeling and automated data loading. You’ll establish ETL environments, enable smooth migration across stages, and collaborate with cross-functional teams to handle large data volumes. You’ll play a key part in optimizing performance and ensuring timely delivery in a dynamic IT services context. ResponsibilitiesDiscuss and clarify ETL requirements with Data AnalystsDevelop Informatica mappings and workflows; script production jobs under supervisionCoordinate with Operations to implement jobs and support warrantyUnit test, UAT, and SIT data; document tests and resultsDesign, develop, and test ETL solutions; model metadata and automate loadingSet up ETL environments per project needsDesign and implement efficient ETL migration from development to test/productionUnderstand database design, programming concepts, data modeling, and framework management Key requirements5+ years of Informatica PowerCenter experienceInformatica PowerCenter v9+Familiarity with DB2 and SQL Server databasesKnowledge of Big Data is a plusBA/BS in Computer Science or equivalent training3–5 years in Data Warehousing3–5 years in ETL3–5 years in Oracle/SQLCollaborates with cross-functional teamsCommunicates requirements clearly with Data AnalystsDocumentation and testing disciplineInformatica PowerCenterDB2SQL Server