Vipin Singh
Harrisburg,USA
Summary
Accomplished Development Technical Lead with expertise in data engineering and cloud integration at Deloitte Consulting LLP. Proven track record in delivering optimized ETL solutions and ensuring data quality governance. Skilled in Informatica and advanced SQL, complemented by strong cross-functional leadership abilities. Successfully implemented scalable data architectures across multiple high-profile projects.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Development Technical Lead
Deloitte Consulting LLP
Charlotte, NC
11.2023 - Current
- Company Overview: Company Overview: State of Washington
- Designed and implemented data integrations for Workday ERP using Informatica IICS and APIs.
- Developed API-based and file-based inbound/outbound interfaces across agencies.
- Delivered optimized, scalable solutions with robust logging and exception handling.
- Managed full-cycle deployment and UAT support, ensuring smooth production rollout.
- Company Overview: State of Washington
Development Technical Lead
Deloitte Consulting LLP
Charlotte, NC
02.2022 - 10.2023
- Company Overview: Company Overview: State of New York
- Led architecture and implementation of a centralized data quality and management framework.
- Developed Informatica mappings, workflows, PL/SQL procedures, and data profiling processes.
- Ensured compliance with usage rights, governance policies, and cross-agency data exchange standards.
- Company Overview: State of New York
Development Technical Lead
Capgemini
Winston-Salem, NC
04.2020 - 01.2022
- Company Overview: Company Overview: MUFG Union Bank
- Spearheaded data modeling, ETL design, and optimization strategies for a multi-layered warehouse architecture.
- Delivered end-to-end solutions for slowly changing dimensions, batch performance, and metadata tracking.
- Company Overview: MUFG Union Bank
Senior ETL Developer
Randstad Technologies
Winston-Salem, NC
06.2018 - 04.2020
- Company Overview: Company Overview: Wells Fargo Bank
- Developed data pipelines to support auto lending, consumer credit, and risk analysis systems.
- Partnered with business users to define KPIs and developed subject-area marts (loan origination, repayment, credit score).
- Leveraged Informatica, Autosys, Oracle, and Unix to ensure SLA-bound data delivery.
- Company Overview: Wells Fargo Bank
Senior ETL Developer
Tata Consultancy Services (TCS)
Monterey Park, CA
08.2014 - 06.2018
- Company Overview: Company Overview: MUFG Union Bank
- Migrated legacy DWH solutions (Ab Initio, DB2) to Informatica/Teradata with minimal disruption.
- Delivered reusable ETL frameworks for finance and regulatory reporting.
- Implemented Type 1 & Type 2 logic for dimensions and facts across subject areas.
- Company Overview: MUFG Union Bank
ETL Developer
Tata Consultancy Services (TCS)
Bangalore, India
07.2013 - 07.2014
- Company Overview: Company Overview: PNC Bank
- Designed and developed subject-specific data warehouses and marts to support business reporting needs.
- Translated business requirements into detailed functional and technical documentation.
- Implemented SCD Type 1 & 2 changes, and optimized ETL performance in Informatica.
- Developed and deployed ETL components using Informatica, Oracle, UNIX, and Autosys.
- Led code deployments across QA, UAT, and PROD environments.
- Managed offshore transition, production support, and E2E testing.
- Company Overview: PNC Bank
- Environment: Informatica PowerCenter 9.5, Oracle
Senior ETL Developer
Tata Consultancy Services (TCS)
Hyderabad, India
05.2012 - 06.2013
- Company Overview: Company Overview: JP Morgan Chase Bank
- Migrated enterprise DWH from Ab Initio/DB2 to Informatica/Teradata.
- Designed ETL processes for data marts with improved analytical depth.
- Engaged in agile ceremonies and delivered migration estimates and designs.
- Oversaw full code migration lifecycle and participated in design reviews.
- Company Overview: JP Morgan Chase Bank
- Environment: Informatica PowerCenter 9.5, Teradata, Unix
ETL Developer and Analyst
Tata Consultancy Services (TCS)
Toronto, Canada
08.2009 - 04.2012
- Company Overview: Company Overview: Rogers Communications Canada - Toronto, Canada
- Developed ETL pipelines to transform log files (SSP/IVR) into structured reporting databases.
- Participated in requirements gathering and staging database modeling.
- Created mappings using Informatica transformations including SP, Lookup, Router, etc.
- Tuned performance of ETL workflows and supported transition to production.
- Company Overview: Rogers Communications Canada - Toronto, Canada
- Environment: Informatica PowerCenter 7.x, Oracle, Unix
ETL Developer
Tata Consultancy Services (TCS)
08.2008 - 07.2009
- Company Overview: Company Overview: Parkway Group Hospitals Singapore
- Designed and maintained billing and estimation procedures for multi-hospital operations.
- Developed batch processing SPs and integrated ETL outputs into .NET Crystal Reports.
- Participated in regression testing and client-facing solution demos.
- Company Overview: Parkway Group Hospitals Singapore
- Environment: Oracle, Unix
Education
Master of Computer Applications (MCA) -
Rajiv Gandhi Technical University
Bhopal, IndiaSkills
- Data engineering and cloud integration
- Informatica tools and platforms
- Advanced SQL and PL/SQL
- Python programming and automation
- Data warehousing and BI architecture
- Dimensional modeling and SCDs
- End-to-end ETL pipeline development
- Agile, Scrum, and Waterfall methodologies
- Data quality and governance
- Metadata management and cross-functional leadership
- ETL tools and cloud platforms
- Unix shell scripting and shell scripts
- Star schema and Snowflake schema modeling
Certification
- Teradata Certified Associate
- Oracle Certified Associate (PL/SQL Programmer)
- Informatica Cloud (IICS) – Internal Training
- Snowflake – Internal Enablement Program
References
Available upon request
Professional Highlights
- 15+ years of experience delivering data engineering solutions for top financial institutions.
- Deep understanding of data ecosystems within auto lending, including CTV, Display, and Dealer platforms.
- Led production support and maintenance for 20+ mission-critical modules with 99.99% uptime.
- Built high-performance ETL systems processing multi-billion-row datasets across hybrid cloud environments.
Websites
Timeline
Development Technical Lead
Deloitte Consulting LLP
11.2023 - Current
Development Technical Lead
Deloitte Consulting LLP
02.2022 - 10.2023
Development Technical Lead
Capgemini
04.2020 - 01.2022
Senior ETL Developer
Randstad Technologies
06.2018 - 04.2020
Senior ETL Developer
Tata Consultancy Services (TCS)
08.2014 - 06.2018
ETL Developer
Tata Consultancy Services (TCS)
07.2013 - 07.2014
Senior ETL Developer
Tata Consultancy Services (TCS)
05.2012 - 06.2013
ETL Developer and Analyst
Tata Consultancy Services (TCS)
08.2009 - 04.2012
ETL Developer
Tata Consultancy Services (TCS)
08.2008 - 07.2009
Master of Computer Applications (MCA) -
Rajiv Gandhi Technical University
Similar Profiles
DAMANJIT SINGHDAMANJIT SINGH
DIGITAL TRANSFORMATION/DELIVERY LEADER at DELOITTE CONSULTING LLPDIGITAL TRANSFORMATION/DELIVERY LEADER at DELOITTE CONSULTING LLP
Nikolaus GeiheNikolaus Geihe
Manager, Human Capital at Deloitte Consulting, LLPManager, Human Capital at Deloitte Consulting, LLP
Mahima ThakurMahima Thakur
Senior Consultant at Deloitte Consulting LLPSenior Consultant at Deloitte Consulting LLP
Kulwinder KaurKulwinder Kaur
Consulting Manager at Deloitte Consulting LLPConsulting Manager at Deloitte Consulting LLP
Tala BrownTala Brown
Phlebotomist at Hershey Medical CenterPhlebotomist at Hershey Medical Center