DEEP KUMAR PATEL
Bangalore
Summary
Assistant Manager at KPMG with over 11 years of experience in Informatica PowerCenter, Amazon Redshift, and SQL. Proven track record in optimizing ETL processes and mentoring junior staff. Expertise in aligning technical solutions with business goals while maintaining high standards of quality assurance and project management.
Overview
13
13
years of professional experience
1
1
Certification
Work History
Assistant Manager
KPMG Assurance and Consulting Services
Pune/Bangalore
06.2023 - Current
- Developed and supported complex mappings using Informatica PowerCenter for data integration.
- Executed Slowly Changing Dimensions and Incremental Load mappings to enhance data processes.
- Applied transformations such as Source Qualifier, Filter, Joiner, and Lookup to fulfill business requirements.
- Conducted unit testing to ensure mapping accuracy throughout development phases.
- Wrote SQL overrides in Source Qualifier and Lookups to meet project specifications.
- Organized training sessions for new hires on workplace procedures and systems.
- Provided guidance to junior staff on daily tasks and project objectives.
- Collaborated with management to formulate strategic plans for achieving business goals.
Assistant Consultant
Tata Consultancy Services
Pune/Noida
11.2021 - 06.2023
- Developed and supported complex mappings using Informatica Cloud and PowerCenter for U.S. Pharma project reporting.
- Analyzed User Requirements Specifications to identify ambiguities, ensuring technical feasibility of requirements.
- Utilized SQL procedures, functions, stored procedures, and packages within ETL mappings.
- Optimized Informatica mappings and sessions to enhance performance efficiency.
- Collaborated with ETL developers to resolve complex scenarios and monitor daily ETL progress with source system owners.
- Managed incidents and problems, performing L1, L2, and L3 issue analysis and resolution.
- Facilitated business communication through user interactions, L1 training, and SOP preparation.
- Executed data extraction from Oracle and flat files into data warehouse, applying transformations as per business needs.
Associate
Cognizant Technology Solutions
Chennai/Kolkata/Bangalore/Pune
03.2014 - 11.2021
- Developed and provided production support for complex mappings using Informatica PowerCenter for U.S. bank and Pharma projects.
- Designed mappings for loading transactional data into Data Warehouse.
- Created data marts with intricate logic, supporting BI team in generating client reports.
- Executed SQL queries to validate data integrity post-Informatica mappings.
- Analyzed HLD and BRD to align development with business requirements.
- Utilized DB2 and PostgreSQL through Toad and Aginity Workbench for database management.
- Processed unstructured flat files from sources like Mainframe, text files, and SQL Server tables.
- Managed SDLC phases from requirement analysis to production implementation.
Technical Support Engineer
Tata Business Support Services Limited
Noida, Delhi NCR
06.2012 - 03.2014
- Conducted network monitoring activities for client network architecture and provided technical support.
- Resolved queries for enterprise customers regarding DLC, NPLC, MPLS, ILL, PRI, and ISDN PRI.
- Coordinated with carrier customers such as Verizon and AT&T to address last-mile issues.
- Monitored link utilization online using MRTG Tool specifically for ILL customers.
- Troubleshot and achieved first-level resolution of customer issues via remote access.
Education
B.Tech - Electronics And Communications Engineering
Punjab Technical University
Punjab04-2012
Intemediate -
JDVM Inter College
Unnao01.2007
Skills
- Informatica PowerCenter
- Informatica Intelligent Cloud Services (IICS)
- SQL
- Amazon Redshift
- UNIX
- DB2
- S3
- PostgreSQL
- Production support
- Project management
- Quality assurance
- Performance optimization
- Data integration
- ETL processes
- Data analysis
Personal Information
- Date of Birth: 11/25/90
- Gender: Male
- Marital Status: Married
Accomplishments
- Received Kudos Star Award for the year 2025.
- Received Bright Star Award - for the year 2016.
- Received The Wizard Award for the 1st Quarter of 2017.
- Rewarded three times for best Quality in Tata Business Support Service.
Trainings Attended
- ANSI SQL (COGNIZANT Internal Certification)
- ADVANCED INFORMATICA (COGNIZANT Internal Certification)
- UNIX BEGINNER (COGNIZANT Internal Certification)
Certification
- Informatica Data Management Cloud Foundation
Timeline
Assistant Manager
KPMG Assurance and Consulting Services
06.2023 - Current
Assistant Consultant
Tata Consultancy Services
11.2021 - 06.2023
Associate
Cognizant Technology Solutions
03.2014 - 11.2021
Technical Support Engineer
Tata Business Support Services Limited
06.2012 - 03.2014
B.Tech - Electronics And Communications Engineering
Punjab Technical University
Intemediate -
JDVM Inter College
Similar Profiles
Shabri MayekarShabri Mayekar
Assistant Manager- Financial Risk Management at KPMG Assurance and Consulting ServicesAssistant Manager- Financial Risk Management at KPMG Assurance and Consulting Services
Ashish AgnihotriAshish Agnihotri
Manager at KPMG Assurance and Consulting Services LLPManager at KPMG Assurance and Consulting Services LLP
Simarjeet KaurSimarjeet Kaur
Executive Assistant at KPMG Assurance and Consulting Services LLPExecutive Assistant at KPMG Assurance and Consulting Services LLP
Palash SharmaPalash Sharma
Associate Director • Industry - AID at KPMG Assurance and Consulting Services LLPAssociate Director • Industry - AID at KPMG Assurance and Consulting Services LLP
SUMANTH MSUMANTH M
Senior Test Engineer at Siemens Technologies and ServicesSenior Test Engineer at Siemens Technologies and Services