Informatica Developer
Vincent VinodRemoteMIDPosted 3h ago
Informatica PowerCenterETLData IntegrationData TransformationData WarehousingSQLStored ProceduresOracleSQL ServerDB2TeradataUnix/LinuxInformatica IDQInformatica IICS
About the Role
We are looking for an Informatica Developer to join our team. This role focuses on developing, implementing, and supporting ETL solutions using Informatica PowerCenter.
Key Responsibilities
• Design, develop, and maintain ETL mappings and workflows using Informatica PowerCenter
• Work with various transformations, sessions, workflows, and mappings
• Develop data extraction, transformation, and loading processes
• Write and optimize SQL queries and stored procedures
• Perform data validation, data quality checks, and reconciliation
• Troubleshoot ETL failures and optimize workflow performance
• Support production deployments, monitoring, and maintenance
Requirements
• 3–6 years of experience in Informatica ETL development
• Strong hands-on experience with Informatica PowerCenter
• Knowledge of mappings, sessions, workflows, and transformations
• Experience with Source Qualifier, Lookup, Joiner, Aggregator, Router, Filter, and Expression transformations
• Strong SQL and database knowledge
• Experience with Oracle, SQL Server, DB2, or Teradata
• Understanding of ETL concepts and data warehousing
• Basic Unix/Linux shell scripting
• Knowledge of workflow monitoring, debugging, and performance tuning
Preferred Skills
• Exposure to Informatica IDQ or IICS
• Knowledge of data migration and data integration projects