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.
- Strong 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.
- Good 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