Job Description
5–9 years of overall experience in data integration / ETL development 3+ years of hands-on experience with Informatica IICS Strong knowledge of: Informatica Cloud Data Integration Mapping Designer, Taskflows, and Schedulers Experience with cloud platforms (AWS, Azure, or GCP) Strong SQL skills and experience with relational databases Understanding of data warehousing concepts and data modeling Experience working with structured and semi-structured data (CSV, JSON, XML) Familiarity with REST/SOAP APIs and cloud connectors Experience with troubleshooting, performance tuning, and error handling Good communication and problem-solving skills
Design, develop, and maintain data integration solutions using Informatica Intelligent Cloud Services (IICS) Build and optimize ETL/ELT pipelines for batch and near real-time data processing Develop mappings, tasks, workflows, and parameterized solutions in IICS Integrate data from multiple sources including databases, cloud applications, files, and APIs Implement data transformation, validation, and cleansing logic Monitor, troubleshoot, and optimize IICS jobs for performance and reliability Ensure data accuracy, consistency, and adherence to governance standards Collaborate with business analysts, architects, and downstream analytics teams Participate in deployment, migration, and upgrade activities Follow best practices for documentation, version control, and CI/CD processes
Experience with Informatica PowerCenter migration to IICS Knowledge of CDI-PC, Secure Agents, and Informatica application integration Exposure to Snowflake, Azure Synapse, Databricks, or other cloud data platforms Informatica certification(s) Experience working in Agile/Scrum environments
