Role & responsibilities

Years of Experience: Candidates with 5+ years of hands-on experience.

Position Requirements:

Must Have:
5+ years of hands-on experience in ETL/ELT development and data integration.
Strong hands-on experience with Informatica IICS/IDMC, including Cloud Application Integration (CAI) and Cloud Data Integration (CDI), and Informatica PowerCenter.
Experience supporting migration of ETL workloads from PowerCenter to IICS/IDMC cloud-native platforms.
Robust hands-on experience with Cloud Data Warehouse like Snowflake /Databricks, including data modeling, optimization, and query tuning.
Working knowledge of Databricks and Apache Spark for data processing and transformation.
Experience with API integration and middleware solutions using Informatica CAI.
Proficient in Python programming to support automation, data processing, and advanced data transformations.
Experience building and maintaining ETL/ELT pipelines integrating Snowflake with diverse sources via IICS.
Design, develop, and unit test complex mappings, workflows, and tasks using IICS,



IDMC, and PowerCenter.
Collaborate with data architects and business analysts to translate business requirements into technical specifications and design.
Knowledge and hands on , Snowflake data objects including tables, views, stages, streams, and tasks with focus on performance and cost optimization.
Should be aware of Snowflake features such as data sharing, events, and lake-house patterns.
Should have experience with data security and data access controls.
Positive to have AWS, Azure, or GCP data storage and management technologies such as S3, Blob/ADLS, and Google Cloud Storage.
Should have a explicit understanding of the DW lifecycle and contribute to technical design documents and test plans.
Effective communication skills to work within Agile teams, with good analytical and problem-solving skills.

Desired Knowledge / Skills:
Familiarity with data quality management and mon

📌 Informatica Powercenter Developer With Expertise In Iics, Idmc Bengaluru
🏢 PwC
📍 Bengaluru