Sumit Mohite

Experience

• 

  Datametica

  Sept 2021 - Aug 2023

  Responsibilities:i. Designed and developed Airflow DAGs to automate data migration from Teradata to BigQuery, converting ETL processes into BigQuery SQL and integrating seamlessly with Google Cloud Storage (GCS).ii. Converted PySpark scripts into BigQuery SQL and utilized BQ command-line tools to efficiently load data from CSV and text files in GCS buckets into BigQuery tables.iii. Extracted data from Teradata using BigQuery Data Transfer Service (BQDTS), managed code deployments, and ensured the smooth execution of data pipelines while resolving production issues proactively. Show less

  • Associate Engineer II

    Sept 2022 - Aug 2023

  • Intern

    Sept 2021 - Aug 2022
• 

  Smartavya Analytica Private Limited

  Sept 2023 - Dec 2024

  A Sister Company of DatameticaResponsibilities:i. Led the optimization of the Greenplum-to-CDP migration process, achieving a 70% reduction in processing time using Hive shell scripting, file-to-table ingestion, and merge statements.ii. Designed and implemented a query converter to transition PostgreSQL SQL scripts into Hive-compatible formats and External to Managed table transitions, ensuring seamless integration with CDP.iii. Developed and managed Informatica ETL jobs, ensuring compatibility with Hive and enabling efficient data workflows for enterprise-level projects. Show less

  • Engineer I

    Apr 2024 - Dec 2024

  • Associate Data Engineer II

    Sept 2023 - Mar 2024
• 

  IBM

  Jan 2025 - now

  GCP Data Engineer