nformatica BDM / PowerExchange Developer

VMC Soft Technologies, Inc; Bengaluru South; On-site; INR 2,500,000 - 3,500,000; Full time

Job summary

VMC Soft Technologies, Inc. is seeking an experienced Informatica BDM/PowerExchange Developer to design, develop, and optimize large-scale data integration pipelines for enterprise data platforms.

The role requires hands-on experience with batch and real-time data ingestion, big data ecosystems, and relational databases. The position involves building ETL/ELT mappings and real-time data integration using Informatica DEI/BDM and PowerExchange, with Apache Spark for processing.

Qualifications

• Hands-on experience with batch and real-time data ingestion.
• Experience with big data ecosystems and relational databases.
• Design and optimize large-scale data integration pipelines.

Responsibilities

• Design and develop ETL/ELT pipelines using Informatica DEI/BDM.
• Implement scalable data ingestion frameworks for structured and semi-structured data.
• Develop mappings, workflows, and reusable components for data processing.
• Configure and implement PowerExchange for CDC and real-time ingestion.
• Execute pipelines with Apache Spark and optimize transformations.
• Deploy Informatica services in non-production environments.
• Provide L2/L3 support for production systems.

Skills

Informatica BDM/DEI

Informatica PowerExchange

Oracle

Apache Spark

Tools

Kafka

Hadoop

Cloudera

Job description

Role Title :Informatica BDM / PowerExchange Developer

Location : Bangalore, Chennai, Hyderabad or PAN India

Experience Required : 6+ Years (Mid-Senior Level)

Primary Skills

• Informatica Data Engineering Integration (DEI / BDM)
• Informatica PowerExchange (CDC / Real-Time Integration)
• Oracle (Metadata & Source Systems)
• Apache Spark (Execution Engine)

________________________________________

Job Summary

We are seeking an experienced Informatica BDM & PowerExchange Developer to design, develop, and optimize large-scale data integration pipelines for enterprise data platforms. The ideal candidate should have hands-on experience in batch and real-time data ingestion, working with big data ecosystems and relational databases, and delivering high-performance data pipelines.

________________________________________

Key Responsibilities

Data Integration & Development

• Design and develop ETL/ELT pipelines using Informatica Data Engineering Integration (BDM/DEI)
• Implement scalable data ingestion frameworks for structured and semi-structured data
• Develop mappings, workflows, and reusable components for data processing

________________________________________

Real-Time Data Integration

Configure And Implement Informatica PowerExchange For

• Change Data Capture (CDC)
• Real-time data ingestion

Integrate streaming data into target data platforms

________________________________________

Big Data Processing

Execute data pipelines leveraging Apache Spark execution engine

Optimize transformations for performance and scalability

Work with distributed data processing frameworks

________________________________________

Platform & Deployment

Deploy and manage Informatica services in Non Production Environment

Support runtime environments and troubleshoot performance issues

Work closely with infrastructure teams for environment setup

________________________________________

Performance Optimization

Optimize ETL Jobs Using

• Pushdown optimization
• Partitioning
• Parallel processing

Ensure high throughput and low latency in data pipelines

________________________________________

Monitoring & Support

Provide L2/L3 support for production systems

________________________________________

Required Skills

Technical Skills

Strong experience in Informatica BDM / DEI

Hands-on experience with Informatica Power Exchange (CDC)

Strong SQL Skills (Oracle Preferred)

Experience in Apache Spark

Knowledge of ETL/ELT design patterns

Familiarity with Linux/Unix environments

________________________________________

Good to Have

Experience with Kafka / Streaming pipelines

Exposure to Cloudera / Hadoop ecosystem

Knowledge of data lake architecture

________________________________________