Ankit Dhurbey

Experience

• 

  Tata Consultancy Services

  Mar 2021 - Dec 2024

  System Engineer
• 

  TCS

  May 2021 - Feb 2023

  • Performed data migration from HDFS to GCP cloud storage.• Used Hive to process the data.• As per workflow, performed joins and aggregation to create a new table.• Performed unit testing using automation tools.• After the code creation, have used Airflow as an orchestration tools. • Convert the COBOL or JCL code to equivalent SQL code i.e., BQ compatible.• Worked with Mainframe team for data analysis.• Performed unit testing for developed SQL output with mainframe output.• Had the responsibility of whole functional area Big Ticket.• Weekly call with customer for SQL review and their approval.

  • W-IM GCP Migration

    Sept 2022 - Feb 2023

  • EZT migration

    May 2021 - Aug 2022
• 

  TCS

  Apr 2023 - Dec 2024

  ERPMart Data Modernization

  • Migration of Data Mart from oracle to GCP environment.• Designed, Developed, and Deployed the data pipelines using Airflow DAGs to automate Data ingestion, transformation and loading into BQ tables for analysis.• Created Airflow DAG for migrating data from Oracle to GCS bucket, and then from GCS bucket to BQ tables.• Reduced the manual effort by creating the DAG for creation of views and procedure.• Conversion of procedure from Oracle to BQ compatible.• Creation of views and end to end unit testing.• Creation of procedures and end to end unit testing.• Optimization of code for better performance in BQ. Show less

• 

  Tech Mahindra

  Dec 2024 - now

  Senior Software Engineer