About Me
Senior ETL Developer with 6+ years of experience in ETL development, application integration, and production support across Banking and Utility domains. Expertise in Informatica PowerCenter, Informatica Intelligent Cloud…
Senior ETL Developer with 6+ years of experience in ETL development, application integration, and production support across Banking and Utility domains. Expertise in Informatica PowerCenter, Informatica Intelligent Cloud Services (IICS), SQL, and Teradata with strong focus on ETL optimization, workflow performance, production stability, incident management, and root cause analysis. Proven experience in handling high-volume transactional data pipelines, ensuring SLA compliance, and delivering reliable enterprise batch processing systems.
Experience
Senior Associate Consultant
<ul><li>Developed and maintained ETL workflows using Informatica PowerCenter.</li><li>Designed and implemented data integration solutions using SQL, Oracle and Teradata.</li><li>Developed complex SQL queries, transformations and data mappings.</li><li>Worked on data warehouse development, data modelling and data validation.</li><li>Optimized ETL workflows and SQL queries for better performance.</li><li>Managed workflow scheduling using Control-M and Unix scripting.</li><li>Collaborated with cross-functional teams to deliver data integration solutions.</li></ul>
Technology Analyst / ETL Developer
<p>Designed and developed 40+ Informatica PowerCenter mappings and workflows for enterprise utility data integration systems.</p><p> Worked on Informatica Intelligent Cloud Services (IICS) for cloud-based integration and support activities.</p><p> Built and optimized high-volume ETL pipelines processing multi-source transactional and operational data.</p><p> Improved ETL batch performance by 20–30% through SQL optimization and workflow tuning.</p><p> Supported application integration and production support activities including incident management, batch monitoring, issue resolution, and deployment validation.</p><p> Led end-to-end ETL lifecycle: extraction, transformation, loading, testing, deployment across DEV/QA/PROD.</p><p> Implemented data validation and reconciliation frameworks ensuring high data accuracy.</p><p> Conducted RCA and impact analysis for critical production issues and implemented permanent fixes.</p><p> Coordinated with cross-functional teams for resolving ETL and application integration issues within SLA timelines.</p><p> Managed production deployments, workflow migrations, and release validations ensuring zero downtime.</p><p> Scheduled and monitored batch jobs using Control-M and ESP Scheduler.</p><p> Performed Unix/Linux troubleshooting for job failures and log analysis.</p>
Systems Engineer
<p>Developed and maintained Informatica PowerCenter workflows for banking data warehouse systems.</p><p> Supported high-volume financial data pipelines ensuring accuracy and reliability.</p><p> Performed SQL-based data analysis, reconciliation, and validation for banking datasets.</p><p> Optimized ETL workflows improving performance and reducing batch failures.</p><p> Worked on production support activities including incident resolution, batch monitoring, defect tracking, and RCA for around 1 year as part of project support activities.</p><p> Participated in deployment validation, job monitoring, and SLA-based issue resolution.</p><p> Participated in Agile sprint cycles involving development, testing, deployment, and support.</p><p> Managed batch scheduling using Control-M ensuring timely job execution.</p><p> Ensured continuous data quality checks across source and target systems.</p>
PROJECTS
ING bank
<p>Worked on ING Bank's Financial & Accounting domain, focusing on enterprise data integration and data warehouse solutions. The project involves processing financial and accounting data, implementing ETL workflows, data transformation, data validation and maintaining data quality to support banking operations and reporting requirements.</p>
Pacific Gas and Electric
<p>Worked on PG&E's Customer Data Warehouse (CDW) project, developing and maintaining ETL workflows using Informatica PowerCenter. Responsible for extracting, transforming and loading customer data from multiple source systems into the data warehouse. Worked on complex SQL queries, Oracle and Teradata databases, data mapping, data validation, performance tuning, Unix scripting and workflow scheduling using Control-M to support enterprise data integration and reporting requirements.</p>
Westpac Banking Coorporation
<p>Worked on Westpac Banking Group's enterprise data warehouse, developing and maintaining ETL workflows using Informatica PowerCenter. Responsible for extracting, transforming and loading data from multiple source systems into target data warehouses using SQL, Oracle and Teradata. Worked on data mapping, transformations, data validation, performance optimization, Unix scripting and workflow scheduling using Control-M to support banking data integration requirements.</p>