Informatica Developer

Role- Informatica developer

Year of experience- 6 to 8 years

Location- Chennai / Bangalore / Hyderabad / Mumbai / Ahmedabad / Indore

Required skill set-

1. Informatica Powercenter
2. SQL & RDBMS (Oracle / SQL Server)
3. Data Warehousing Concepts (Fact/Dim, SCD)
4. ETL Design & Transformations
5. Performance Tuning (ETL & SQL)
6. Unix Shell Scripting

Job Requirements*

• Strong handson experience in Informatica PowerCenter and/or Informatica IICS (CDI) with endtoend ETL development
• Proficient in SQL and working with Oracle / SQL Server databases, including query optimization
• Solid understanding of data warehousing concepts such as Fact & Dimension tables and SCD Type1 / Type2
• Experience in building complex mappings using Aggregator, Joiner, Lookup, Router, Expression, Update Strategy transformations
• Exposure to performance tuning of Informatica mappings, sessions, and SQL queries
• Experience in production support, job monitoring, and coordination with business and downstream teams

Key Responsibilities*

• Design, develop, and maintain ETL mappings, workflows, and sessions using Informatica PowerCenter (9.x / 10.x) and/or Informatica IICS (CDI)
• Develop complex mappings using Expression, Aggregator, Joiner, Lookup (Connected/Unconnected), Router, Filter, Update Strategy, Sequence Generator
• Implement Slowly Changing Dimensions (SCD Type1 and Type2) for enterprise data models
• Perform endtoend ETL development including sourcetotarget mapping, unit testing, and deployment
• Conduct performance tuning of Informatica mappings, sessions, and SQL queries
• Handle production support, root cause analysis, and defect fixes
• Collaborate with Business Analysts, Data Engineers, and QA teams
• Prepare and maintain technical documentation (STTM, mapping specs, design notes)