Senior Informatica / ETL / Data Integration Developer
Bengaluru
Summary
10+ years of experience in Data Integration, ETL Development, and Enterprise Data Warehousing.
Strong Expertise in Informatica ecosystem including Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC).
Experience with IDMC services such as Cloud Data Integration (CDI), Cloud Data Integration for PowerCenter (CDI-PC), Cloud Mass Ingestion, Data Quality, and Metadata Management.
Strong SQL Expertise including DDL, DML, query optimization, and performance tuning.
Experienced in ETL pipeline design, data mapping, transformation development, workflow orchestration, and job scheduling.
Skilled in gathering business requirements, preparing functional/technical specifications, and managing IT change control processes.
Strong Collaboration with business teams to deliver enterprise data integration solutions supporting finance, operations, and analytics platforms.
Overview
2
2
Certifications
12
12
years of professional experience
Work History
ETL / BI Developer
TCS
Bangalore
04.2022 - Current
Develop ETL workflows using Informatica PowerCenter and Informatica IDMC for enterprise data integration.
Develop SQL scripts and database objects, including tables, views, indexes, and stored procedures.
Translate business requirements into technical solutions through close collaboration with business users.
Participate in change management by analyzing requirements, maintaining documentation, and supporting releases.
Optimize SQL queries and data transformations to improve performance and scalability.
Apply workflow orchestration, job scheduling, and production support practices to keep integrations running smoothly.
Developed and optimized ETL processes using SQL Server Integration Services (SSIS).
BI Developer
Accenture
Chennai
04.2019 - 03.2022
Delivered ETL workflows for healthcare analytics reporting.
Designed ETL workflows for healthcare analytics systems using Informatica PowerCenter and Informatica IDMC.
Developed Tableau dashboards and visualizations integrated with data warehouse solutions.