Design, develop, and maintain ETL/ELT pipelines using Informatica Cloud (IICS) Develop and manage data integration workflows, mappings, and taskflows Integrate data from multiple sources including databases, cloud platforms, APIs, and flat files Perform data transformation, cleansing, and validation using IICS components Work with Cloud Data Integration (CDI) and Application Integration (CAI) services Design reusable mappings and parameterized workflows Optimize workflows for performance, scalability, and efficiency Troubleshoot and resolve data integration issues Ensure data quality, governance, and security standards Collaborate with business stakeholders, data architects, and analysts Support migration from on-prem Informatica (PowerCenter) to IICS (if applicable)
Additional Responsibilities:
Experience with Application Integration (CAI) in IICS Exposure to REST/SOAP APIs and web services integration Knowledge of Informatica PowerCenter (for migration projects) Familiarity with CI/CD pipelines and version control (Git) Experience with data quality and data governance solutions Exposure to big data or cloud data warehouses (Snowflake, BigQuery, Redshift) Scripting knowledge in Python or Shell is an advantage Bachelor's degree in Computer Science, IT, or related field Informatica certifications (IICS / Cloud Data Integration) are a plus
Technical and Professional Requirements:
Strong hands-on experience with Informatica Intelligent Cloud Services (IICS) Expertise in Cloud Data Integration (CDI) Strong knowledge of ETL concepts and data integration techniques Proficiency in SQL and relational databases (Oracle, SQL Server, etc.) Experience with data transformation, mappings, and taskflows Knowledge of parameterization, reusable components, and workflows Familiarity with cloud platforms (AWS / Azure / GCP is a plus) Understanding of data warehousing concepts (star/snowflake schema) Experience with error handling, logging, and monitoring
