I am a results-driven IT professional with 9 years of experience in designing and developing software applications and business intelligence solutions, with a strong focus on ETL and data integration using Informatica PowerCenter. I have delivered production and enhancement projects, implemented data pipelines, and ensured data quality across diverse data sources and environments. I have hands-on expertise with Informatica PowerCenter (versions 8.x through 10.x) and modern cloud and data warehouse technologies such as Snowflake and Salesforce. I excel at building scalable ETL mappings, creating workflows, performance tuning, and delivering insightful dashboards with Power BI. I enjoy collaborating across teams to solve complex data challenges and drive business value.

Subbaramaiah

I am a results-driven IT professional with 9 years of experience in designing and developing software applications and business intelligence solutions, with a strong focus on ETL and data integration using Informatica PowerCenter. I have delivered production and enhancement projects, implemented data pipelines, and ensured data quality across diverse data sources and environments. I have hands-on expertise with Informatica PowerCenter (versions 8.x through 10.x) and modern cloud and data warehouse technologies such as Snowflake and Salesforce. I excel at building scalable ETL mappings, creating workflows, performance tuning, and delivering insightful dashboards with Power BI. I enjoy collaborating across teams to solve complex data challenges and drive business value.

Available to hire

I am a results-driven IT professional with 9 years of experience in designing and developing software applications and business intelligence solutions, with a strong focus on ETL and data integration using Informatica PowerCenter. I have delivered production and enhancement projects, implemented data pipelines, and ensured data quality across diverse data sources and environments.

I have hands-on expertise with Informatica PowerCenter (versions 8.x through 10.x) and modern cloud and data warehouse technologies such as Snowflake and Salesforce. I excel at building scalable ETL mappings, creating workflows, performance tuning, and delivering insightful dashboards with Power BI. I enjoy collaborating across teams to solve complex data challenges and drive business value.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate

Work Experience

ETL Informatica Developer at Hong Leong Bank (Encora Technology Private Limited)
December 1, 2022 - Present
Replaced Teradata with GaussDB to expand and optimize the EDW solution and integrated data from multiple sources. Analyzed and migrated Teradata scripts to GaussDB. Designed Informatica workflows to insert, update, and delete Salesforce records; developed mappings (Source Qualifier, Lookup, Upsert, Update Strategy) to support data ingestion. Implemented data migration activities, prepared test data, performed UAT analysis, and provided root-cause analyses to reduce failures. Created and scheduled workflows using Workflow Manager; monitored daily/weekly loads; supported client meetings and produced status reports.
Software Developer at AMDOCS Development Centre India Private Limited
April 1, 2022 - September 1, 2022
Migrated T-Mobile data landscape; developed ETL mappings using Informatica PowerCenter; extracted data from Oracle, XML, and flat files; built and scheduled workflows; performed unit testing and status reporting; collaborated with onsite managers.
Software Developer at Cognizant Technology Solutions India Pvt Ltd
September 1, 2021 - March 1, 2022
AXA Finance ETL project; extracted data from Oracle and flat files; designed Mappings, Sessions, and Workflows; tuned mappings for performance; performed daily monitoring and client reporting; supported data migration tasks.
Software Developer at Indian Oil Corporation Pvt Ltd
November 1, 2018 - August 1, 2020
Informatica ETL development for subsidiary payments; captured customer details; loaded into staging and NPCI; implemented SCD Type 1/2, mapping, parameter files; ETL mapping migration; created mapplets and reusable transformations; performance tuning and data validation.
Software Developer at I Base Software Solutions (India) Pvt. Ltd., Hyderabad
January 1, 2018 - November 1, 2018
Involved in ETL development across multiple projects using Informatica; created mappings, Mapplets, and reusable transformations; implemented SCDs and target load order; migrated mappings/workflows; performance tuning and data validation.
Associate Consultant at Virtusa Polaris, Pune
December 1, 2016 - July 1, 2017
Worked on Sales Data Mart/Data Warehouse projects; designed and developed ETL processes; built mappings using Source Qualifier, Expression, Router, Lookup, Update Strategy; implemented SCD Type 2; created mapplets and reusable transformations; performed unit testing and monitoring of job executions.
Associate Engineer at BMC Software Pvt Ltd, Pune
August 1, 2013 - December 1, 2016
Crown Bank data warehouse project focusing on LOANS; design and development of ETL processes; loading data from Landing to Staging and Staging to Target; implemented various transformations including Source Qualifier, Filter, Joiner, Expression, Aggregator, Lookup, Update Strategy and Router; utilized utilities such as Fast Load, Multiload, Tpump, Bteq; migration of mappings/workflows; created and executed sessions and workflows.

Education

M.C.A at Osmania University of Hyderabad
January 11, 2030 - January 9, 2026

Qualifications

Add your qualifications or awards here.

Industry Experience

Software & Internet, Financial Services, Telecommunications, Energy & Utilities