Informatica Developer
Core
Design, develop, and maintain ETL workflows and data integration solutions using Informatica PowerCenter and IDMC for data warehouses and target applications.
Role type
Senior Informatica Developer (ETL)
Builds
ETL workflows, mappings, sessions, and reusable components for data warehousing
Domain
Data Engineering / ETL / Data Warehousing
Required skills
Informatica PowerCenter, ETL design, Data Warehousing concepts, SQL, Oracle, SQL Server, Teradata, DB2, Data Modeling (Star/Snowflake schemas), ETL optimization, Troubleshooting
Preferred skills
Informatica Intelligent Cloud Services (IICS/IDMC), Cloud platforms (AWS, Azure, GCP), Data governance tools, Banking/Financial services domain experience, Scheduling tools (Control-M, Autosys)
Technologies
Informatica, PowerCenter, IDMC, SQL, Oracle, SQL Server, Teradata, DB2, AWS, Azure, GCP, Control-M, Autosys
Responsibilities
Design and develop ETL workflows and mappings; Create and maintain reusable ETL components; Develop complex SQL queries and stored procedures; Troubleshoot ETL failures and resolve data quality issues; Optimize ETL jobs for performance and scalability; Collaborate with business analysts and data architects to gather requirements; Support production deployments and provide post-production assistance.
Seniority
Senior, hands-on IC