Gaurav Jadhav

About Gaurav Jadhav

As a Bachelor of Engineering graduate in Information Science from New Horizon College of Engineering, my journey at EXL has been marked by a deep dive into data integration. At EXL, my core competencies include developing Data pipelines and optimizing queries across diverse platforms such as AWS, ADF,SAP, Snaplogic,Oracle and Snowflake.With the team at EXL, we\'ve translated complex business requirements into efficient data solutions, ensuring robust data flow between systems. My certification as a Snaplogic Certified Enterprise Automation Professional and skills in Pyspark, Data bricks, ETL, Snowflale, teradata,SSMS,Oracle SQL, AWS,ADF.

Experience

1. Data Engineer Business Analyst

   EXL

   Nov 2023 — Present · Bengaluru, IN

   Experienced Data Engineer with expertise in building and optimizing end-to-end data pipelines, cloud integrations, and analytical solutions for international clients across multiple domains. At Caterpillar (Heavy Machinery & Equipment), worked on migrating and modernizing ETL workflows from IBM DataStage to SnapLogic and PySpark, ensuring seamless integration with platforms like SAP, Snowflake, and Salesforce. At Unum Project: End-to-End Data Pipeline Development (Banking Domain)Worked on building and maintaining a scalable data pipeline for processing high-volume banking data from multiple enterprise applications.Project OverviewThe project focused on ingesting, processing, and transforming large datasets generated from various banking platforms such as core banking systems, trading platforms, and internet banking applications. The objective was to convert raw data into structured datasets that could be used for analytics and business reporting.Key Responsibilities• Developed and implemented data transformation logic using PySpark and Python to process large datasets efficiently.• Applied multiple transformations such as filtering, joins, aggregations, and business logic to convert raw data into meaningful business datasets.• Monitored and managed data pipeline workflows using Apache Airflow, ensuring scheduled jobs ran successfully and resolving failures by analyzing logs and rerunning DAGs when required.• Managed manual data ingestion processes where required by uploading CSV or Excel files and integrating them into the data pipeline.• Deployed and tested code in the development environment, validated outputs, and promoted stable pipelines to the production cluster.• Stored processed and transformed datasets in Amazon S3, enabling downstream teams to access reliable and structured data.• Analyzed and validated data through Tableau dashboards to ensure incoming processed data was correctly reflected in reporting layers.

Education

• Maharashtra Public School

  10

• New Horizon College of Engineering

  Bachelor of Engineering - BE, Information science