Informatica PowerCenter Developer with expertise in IICS, IDMC

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 clear 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 monitoring tools.
• Knowledge of containerization and orchestration technologies such as Docker and Kubernetes.
• Understanding of DevOps practices related to CI/CD pipelines for data projects.
• Certifications in Snowflake, Databricks, Informatica IICS, or Python programming.
• Experience with DevOps tools like Jenkins, GitLab CI/CD, or Azure DevOps.

Knowledge of additional data tools/technologies such as Apache Spark and Kafka.