We are looking for an ETL Informatica Developer to design, develop, and maintain data integration solutions using Informatica PowerCenter/IICS. The ideal candidate will build robust ETL pipelines to support data warehousing, reporting, and analytics needs.

Design, develop, and maintain ETL mappings, sessions, and workflows using Informatica PowerCenter/IICS Extract data from multiple source systems (databases, flat files, APIs) and load into target data warehouses/data marts Apply data transformation, cleansing, and business rules using Informatica transformations (Lookup, Joiner, Aggregator, Expression, Router, etc.) Write and optimize complex SQL queries, stored procedures, and PL/SQL scripts Monitor and troubleshoot ETL job failures, performance issues, and data discrepancies Perform data validation, reconciliation, and quality checks to ensure accuracy Optimize Informatica mappings and workflows for performance and scalability Schedule and monitor batch jobs using Informatica Scheduler or enterprise schedulers (Control-M, Autosys) Collaborate with data architects, BI developers, and business analysts to gather requirements

2–6 years of experience in ETL development using Informatica PowerCenter/IICS (adjust per seniority) Strong hands-on experience with Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor) Exposure to Informatica Intelligent Cloud Services (IICS) is a plus Strong SQL skills — complex queries, joins, stored procedures, performance tuning Experience with relational databases (Oracle, SQL Server, PostgreSQL) Solid understanding of data warehousing concepts — star schema, snowflake schema, SCD (Slowly Changing Dimensions), facts/dimensions Experience with source-to-target mapping documentation Familiarity with Unix/Linux shell scripting for automation Knowledge of job scheduling tools (Control-M, Autosys, or similar)