Summary
Overview
Work History
Education
Skills
Certifications
Timeline
Hi, I’m

Nikhil Saxena

Senior Data Engineer
Jaipur
Nikhil Saxena

Summary

Manager with over a decade of experience in Data and Analytics at PwC Consulting in Gurgaon, India, specializing in the complete lifecycle of Data Warehousing and Data Integration solutions. Expertise includes hands-on experience with Informatica PowerCenter (versions 10.1 & 10.5) and designing Enterprise Data Warehouses and Data Marts that integrate data from diverse sources using AWS services such as EMR, Step Functions, Amazon S3, and Amazon Redshift. Proven track record as an ETL Developer, delivering high-quality data warehouse solutions, conducting team training sessions, and managing system maintenance and support for clients in the Banking, Insurance, Inventory, and Procurement industries. Recognized for strategic leadership in leveraging cloud technologies to optimize data processes and drive business insights.

Overview

10
years of professional experience
2
Languages

Work History

Life Insurance Company

Manager
08.2025 - Current

Job overview

  • Managed and motivated employees to be productive and engaged in work.
  • Accomplished multiple tasks within established timeframes.
  • Maximized performance by monitoring daily activities and mentoring team members.
  • Enhanced customer satisfaction by resolving disputes promptly, maintaining open lines of communication, and ensuring high-quality service delivery.
  • Controlled costs to keep business operating within budget and increase profits.
  • Engineered project architecture that ingested data from Ingenium, CRM, and PostgreSQL into GCP BigQuery through stored procedures and Python scripts executed in DataProc. Orchestrated scheduling of various DAGs by source system within Cloud Composer. Established a range of dimensions, facts, and marts for detailed data insights. Configured multiple views to support dashboard development in Power BI addressing business reporting requirements.

PwC

Senior Associate
01.2023 - 06.2025

Job overview

  • Established Enterprise Data Warehouse framework for Banking Client through integration of data from diverse source systems.
  • Managed daily incremental and full load data loading processes into EDW staging tables. Utilized AWS Redshift to build stored procedures for client-specific dimension, fact, and mart tables. Designed PySpark scripts for seamless integration of new data sources into existing systems. Automated various manual tasks by scheduling data processing jobs with AWS EventBridge and Lambda. Implemented SCD Type 1 and Type 2 strategies for developing multiple dimensions.
  • Collaborated with cross-functional teams to drive successful completion of complex projects within deadlines.
  • Trained and supported new team members, maintaining culture of collaboration.

Deloitte Consulting

Consultant
06.2021 - 01.2023

Job overview

  • Constructed a data pipeline for reporting, parsing Kafka JSON messages in the Streamsets tool. Utilized Informatica PowerCenter to transform landing zone data per client needs. Facilitated the loading of processed data into Teradata's reporting layer. Produced numerous reports for downstream applications, leveraging Teradata to Greenplum DB transfers.
  • Cultivated client relationships through consistent check-ins and updates on project progress, utilizing Jira.
  • Awarded the spot award two times within the project.

Cognizant Technology Solutions, Gurgaon

ETL Informatica Developer
06.2015 - 06.2021

Job overview

  • Created a central data repository for a U.S. insurance client, where data and files from multiple source systems are transferred to the INFA server for processing and transformations through Informatica mappings, and Informatica-generated files are transformed to downstream systems via FTP.
  • Worked on Informatica PowerCenter, B2B DX, Unix shell scripting, SQL, and Maestro scheduler to schedule Informatica jobs.
  • Developed shell scripts to automate multiple manual processes within the project.
  • Performance tuning of stored procedures for code enhancements.
  • Employed a debugger to identify bugs in existing mappings through data flow analysis and transformation evaluation.
  • Reviewed and analyzed functional requirements, mapping documents, problem-solving, and troubleshooting.
  • Executed unit testing across multiple ETL levels to ensure data integrity. Diagnosed issues in production data, and developed jobs for effective correction.

Education

The Amity School of Engineering And Technology (ASET)

B.Tech/B.E.
05-2014

Kendriya Vidhalaya
Jaipur, India

XIIth from English
03-2010

Kendriya Vidhyalaya
Jaipur, India

Xth from English
03-2008

Skills

SQL , Pyspark,

Certifications

·AWS Data Engineer Associate (DEA-C01). 2025 -2028

·DP 203 – Azure Data Engineer Associate Certification. 2023

Timeline

Manager

Life Insurance Company
08.2025 - Current

Senior Associate

PwC
01.2023 - 06.2025

Consultant

Deloitte Consulting
06.2021 - 01.2023

ETL Informatica Developer

Cognizant Technology Solutions, Gurgaon
06.2015 - 06.2021

The Amity School of Engineering And Technology (ASET)

B.Tech/B.E.

Kendriya Vidhalaya

XIIth from English

Kendriya Vidhyalaya

Xth from English

Similar Profiles

CREATE PROFILE
Nikhil SaxenaSenior Data Engineer