Job Description :

- Hands-on experience with Informatica ETL (BDM / IICS / CDI)

- Ability to build basic mappings and workflows

- Understanding of ETL pipeline (source - transform - target)

- Basic exposure to BDM (Hadoop / Spark processing concepts)

- Hands-on experience with IDMC (CDI mappings, tasks, connections)

- Strong SQL skills (joins, filters, aggregations, validation)

- Knowledge of data ingestion, transformation, and validation

- Ability to handle file-based and database-based data loads

- Basic understanding of data quality concepts (null checks, validation rules)

- Ability to debug job failures and data mismatches

- Exposure to Hadoop / Spark (practical or academic)

- Understanding of real-time vs batch processing

- Basic knowledge of cloud platforms (AWS / Azure / GCP)

- Familiarity with PowerCenter (legacy ETL)

- Basic understanding of APIs (REST, JSON)

- Exposure to data quality tools/frameworks

- Knowledge of partitioning / parallel processing concepts

- Informatica entry-level certifications

Role & Responsibilities :

Integration & Data Engineering :

BDM/IDMC :

- Strong hands-on experience in Informatica BDM mappings and workflows

- Experience building complex ETL pipelines (ingestion - transformation - load)

- Hands-on experience with Hadoop/Spark-based processing in BDM

- Strong experience in Informatica IDMC / CDI (IICS)

- Ability to design and implement reusable ETL components

- Strong SQL skills (joins, aggregations, performance tuning basics)

- Experience working with large data volumes (big data processing)

- Understanding of batch and real-time data integration patterns

- Ability to implement data transformation, validation, and enrichment logic

- Experience in performance tuning (partitioning, parallel processing)

- Ability to debug and troubleshoot data, pipeline, and performance issues

- Experience integrating multiple sources:

i. Databases

ii. Flat files

iii. APIs

- Experience with cloud platforms (AWS / Azure / GCP)

- Understanding of data lake and modern data architectures

- Exposure to API-based integrations (REST, JSON)

- Familiarity with PowerCenter (legacy ETL)

- Exposure to data quality tools/frameworks

- Experience with real-time streaming/event-based pipelines

- Basic knowledge of DevOps / CI-CD for ETL pipelines

- Informatica certifications (BDM / IDMC)

- Scripting knowledge (Python / Shell)

Architecture & Design :

- Strong experience designing end-to-end data integration architecture using BDM + IDMC

- Ability to define scalable big data pipelines (batch + real-time)

- Expertise in data ingestion, transformation, enrichment, and distribution patterns

- Experience designing data lake / modern data platforms

BDM / Big Data Expertise :

- Deep hands-on experience with BDM mappings, workflows, and Spark execution

- Expertise in Hadoop / Spark ecosystem (execution, optimization)

- Strong experience handling high-volume, distributed data processing

- Ability to design optimized Spark-based pipelines

IDMC / Cloud Integration :

- Strong experience with IDMC (CDI/IICS) pipeline design and orchestration

- Expertise in building reusable, scalable, parameterized ETL frameworks

- Experience in API-based, event-driven integrations

- Understanding of hybrid architectures (on-prem + cloud integration)

Performance & Optimization :

- Deep expertise in performance tuning :

a. Partitioning strategies

b. Pushdown optimization

c. Parallel processing

- Ability to identify and resolve bottlenecks in large-scale pipelines

Data Engineering & Integration :

- Experience integrating multi-source data ecosystems

- Strong knowledge of :

a. Batch processing

b. Real-time pipelines

c. Streaming concepts (at least conceptual)

- Strong SQL and data modeling capability

Delivery & Leadership :

- Ability to lead modules / tracks independently

- Experience managing end-to-end delivery (design - build - deploy)

- Mentoring and guiding junior and mid-level developers

- Experience in client interactions, technical design discussions