Headline

Informatica PowerCenter & IDMC/IICS Developer | PowerCenter-to-Cloud Migration | GCP · Python · BigQuery | ETL · SQL · L2/L3 Support

About

I'm an ETL and data integration engineer with 5+ years at Capgemini, working across Informatica PowerCenter, IICS/IDMC and, more recently, Python and GCP. I started in L2/L3 production support, monitoring 100+ ETL workflows across 3 enterprise-critical applications at 99.9% uptime, working high-priority ServiceNow incidents, and cutting recurring job failures by 30% through workflow enhancements, better error handling and proactive monitoring. I then moved into development: building PowerCenter and IDMC mappings and workflows, automating SFTP/FTP transfers with Unix shell scripts, taking part in multi-ERP cloud migrations, and executing PowerCenter-to-IDMC migrations. Right now I'm on an Informatica-to-GCP/Python migration project. I built a metadata-driven utility that parses Informatica XML into a standard metadata repository and generates PySpark and Python code from it, with pipelines orchestrated on Cloud Composer (Airflow) and BigQuery. Together with AI-assisted (Claude) code generation, this reduced migration timelines and manual development effort by 40%. What I bring: • Informatica PowerCenter, IICS and IDMC development and migration • Oracle, SQL and PL/SQL, with SQL, mapping and session tuning • Unix/Linux shell scripting and Appworx scheduling • Python, PySpark, Airflow and BigQuery for pipeline modernization • Root cause analysis, SLA-driven support and clear technical documentation I'm open to Informatica PowerCenter, IICS/IDMC, ETL/data integration and PowerCenter-to-cloud migration roles in India.

Location

Bengaluru

AI stack

claude

gemini

Work experience

Cloud Data Engineer at Capgemini, Jul 2026 - Present · 5 mos, Bengaluru, Karnataka, India, • Built a metadata-driven automation utility to migrate legacy Informatica PowerCenter pipelines to Python and GCP architectures. • Developed a Python parsing engine that extracts source, target and transformation logic from Informatica XML into a standardized metadata repository. • Created a Python-based generator that reads the metadata and produces PySpark and Python code, removing manual mapping translation and preserving 1:1 functional parity. • Orchestrated the modernized workflows on GCP using Cloud Composer (Airflow) and BigQuery, replacing GUI-based transformations with code-centric pipelines. • Reduced end-to-end migration timelines and manual development effort by 40% through automation and AI-assisted (Claude) code generation. Skills: Python · PySpark · GCP · BigQuery · Cloud Composer · Apache Airflow · Informatica PowerCenter · Data Migration

Informatica PowerCenter Developer & IDMC Developer at Capgemini, Jul 2024 - Jul 2026 · 2 yrs 1 mo, Bengaluru, Karnataka, India, • Developed ETL mappings and workflows in Informatica PowerCenter and IDMC using filter, expression, sequence generator, rank, update strategy, joiner, lookup, router, aggregator and union transformations. • Executed end-to-end migrations from legacy PowerCenter to IDMC. • Took part in migrating multiple ERPs to the cloud and supported teams during system upgrades and enhancements to minimize disruption. • Wrote Unix shell scripts to automate SFTP/FTP transfers between servers and Informatica servers. • Coordinated with testing teams on data quality and reliability, and aligned technical solutions with client and business stakeholders. • Produced and maintained technical documentation for ETL processes and procedures. Skills: Informatica PowerCenter · IDMC · IICS · Unix Shell Scripting · ETL Development · Data Integration

Informatica PowerCenter Support Engineer at Capgemini, Apr 2021 - Jul 2024 · 3 yrs 4 mos, Bengaluru, Karnataka, India, • Monitored and supported 100+ ETL workflows across 3 enterprise-critical applications, sustaining 99.9% uptime. • Delivered L2/L3 production support: resolved high-priority ServiceNow incidents, performed RCA and met SLA targets. • Reduced recurring ETL job failures by 30% through workflow enhancements, improved error handling and proactive monitoring. • Improved data load performance by 5% by optimizing SQL queries, tuning mappings and sessions, and using partitioning. • Designed reusable ETL components that cut new development effort by 20%. • Automated repetitive manual tasks with Appworx scheduling and Unix shell scripts, reducing operational effort and human error. • Created ETL design specifications, mapping documents and support guides; partnered with business analysts and data teams to validate requirements. Skills: Informatica PowerCenter · L2/L3 Production Support · RCA · ServiceNow · Appworx · Oracle · SQL · Performance Tuning

Intern at KaaShiv InfoTech, May 2019 - Jun 2019 · 2 mos, Tamil Nadu, India, Created Webpages using C# .Net as a frontend in Microsoft Visual Studios platform and connecting database to it using SQL server 2008 and uploading the data we entered into AWS Cloud to access the information remotely

Education

Bachelor of Technology, Computer Engineering, GITAM Deemed University

Intermediate, MPC, Sri Chaitanya College of Education