Role Descriptions:
Key Responsibilities –
1. Design| develop| and maintain data integration pipelines using Informatica IICS (CDI mandatory).
2. Analyze existing workflows and mappings to optimize performance| data quality| and reliability.
3. Troubleshoot integration issues| perform root cause analysis| and deliver permanent fixes.
4. Work closely with business analysts| data architects| and project stakeholders to gather and understand requirements.
5. Conduct performance tuning on mappings| transformations| and database queries.
6. Provide production support for IICS jobs| including incident resolution and post-deployment enhancements.
7. Create documentation for all integration processes| workflows| and data flows.
8. Develop and debug SQL queries and stored procedures to support integration logic.
9. Ensure best practices around coding standards| security| and performance.
10. Participate in testing cycles including sanity testing| regression testing| and validation of data loads.
Essential Skills: Informatica IICS Developer –
1. Strong hands-on experience with Informatica IICS| specifically Cloud Data Integration (CDI required CAI good to have).
2. Excellent understanding of ETLELT concepts| data integration methodologies| and enterprise data engineering practices.
3. Ability to analyze source-to-target mappings and optimize data workflows for performance and scalability.
4. Strong SQL skills with experience creating and debugging stored procedures.
5. Experience in handling production issues| performing RCA| and applying effective fixes.
6. Solid understanding of data quality| data validation| and error-handling frameworks.
7. Familiarity with cloud platforms (AWSAzureGCP) is a plus.
8. Good communication and documentation skills.
9. Ability to work independently and collaboratively with cross-functional teams.
10. Experience supporting development| testing| deployment| and post-production activities.
