About
Highly accomplished Senior Data Engineer with 3 years of expertise in designing, deploying, and optimizing scalable data pipelines within Azure ecosystems. Proficient in Informatica IICS, PySpark, and Databricks, Mohit has a proven track record of delivering robust ETL and integration solutions that enhance business performance, scalability, and data security. Recognized for driving significant improvements in pipeline efficiency and data accuracy, he is passionate about leveraging automation and advanced data engineering techniques to deliver actionable insights.
Work
Noida, Uttar Pradesh, India
→
Summary
As a Senior Analyst/Data Engineer at Capgemini, Mohit led critical ETL migration projects and developed robust data pipelines, significantly enhancing scalability and data processing efficiency for enterprise clients like Volvo Group.
Highlights
Led the IPC to IICS migration project, achieving a 40% improvement in ETL pipeline scalability and optimizing data flow for critical enterprise applications.
Designed and implemented over 500 IICS data integration mappings, significantly enhancing pipeline reusability and reducing development efforts.
Optimized data processing by implementing performance tuning techniques that reduced data load time by 20% across source and target systems.
Ensured 100% data validation accuracy through rigorous internal audit and reconciliation tools, maintaining high data integrity for critical business intelligence.
Developed robust end-to-end ETL pipelines using SQL Server, Oracle, and Netezza, integrating high-volume structured and semi-structured data into Azure Synapse and Data Lake.
Awards
Shining Star
Awarded By
Capgemini Technology Services India Ltd
Honored for consistently high performance and valuable contributions throughout Q3 2024.
Rising Star
Awarded By
Capgemini Technology Services India Ltd
Awarded for exceptional potential and significant impact demonstrated in Q4 2023.
Millennial of the Quarter
Awarded By
Capgemini Technology Services India Ltd
Recognized for outstanding performance and contributions during the first quarter of 2023.
Certificates
Skills
ETL Tools
Informatica IICS (Cloud), Informatica PowerCenter (IPC).
Programming
SQL (Advanced), Python (Intermediate), C++.
Cloud & DevOps
Microsoft Azure, Azure Synapse Analytics, Azure DevOps, Azure Data Factory.
Data Platforms
Azure Databricks, Azure Data Lake, Delta Lake, Snowflake, Oracle, Netezza, Microsoft SQL Server.
Data Engineering
Data Modeling, Data Ingestion, Data Validation, Pipeline Orchestration.
Scripting
UNIX Shell Scripting, Crontab Automation.
Other
Performance Tuning, Data Quality Checks, Business Intelligence.