Siddhesh Naik
Mumbai
Summary
Accomplished Specialist Data Engineer with a proven track record at LTIMindtree, specializing in GCP and Snowflake. Experienced in BigQuery, workflow automation, and data pipeline optimization, ensuring enhanced efficiency and scalability. Adept at transitioning enterprise data solutions to cloud platforms, leading teams, and driving automation initiatives. Skilled in database querying, DataFrame processing, and technical communication, ensuring project success, data integrity, and seamless stakeholder collaboration.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Specialist Data Engineer
Ltimindtree
Mumbai
04.2021 - Current
- Designed, developed, and optimized Snowflake procedures, views, and table functions, utilizing Tasks for automated scheduling and execution.
- Led the migration of Informatica mappings to BigQuery within the GCP environment, ensuring seamless data transition and improved performance.
- Engineered efficient ETL pipelines using BigQuery, Apache Beam, and GCP Data Fusion, enhancing data processing and transformation.
- Developed and scheduled Composer workflows with Directed Acyclic Graphs (DAGs) to automate data processing and workflow orchestration.
- Implemented data ingestion pipelines, efficiently loading semi-structured and unstructured data into BigQuery using Google Cloud Functions.
- Led a team of 10 engineers in BigQuery development, overseeing code reviews, unit testing, and best practice implementation to ensure high-quality deliverables.
Associate Data Engineer
Teradata
Mumbai
02.2016 - 04.2021
- Migrated scripts and DataStage jobs from Teradata to Snowflake, ensuring seamless data transition and optimized performance.
- Engaged in ETL development, designing and implementing efficient data pipelines to enhance processing capabilities.
- Performed BTEQ-to-Snowflake script conversion, optimizing SQL queries for improved execution and maintainability.
- Developed a Code Checklist, ensuring adherence to best practices, coding standards, and performance guidelines.
- Designed effective indexing strategies, improving storage efficiency and query performance within Snowflake.
- Executed comprehensive testing protocols, validating models and data transformations before deployment.
- Developed and implemented unit test scenarios, ensuring code quality, accuracy, and reliability.
- Maintained high standards by ensuring timely task completion and delivering high-quality solutions.
Education
P.G - Cloud Computing
Great Learning
10-2024
Bachelors of Engineering - Information Technology
Atharva College Of Engineering
Mumbai06-2015
Skills
- Database Querying
- PL-SQL
- Pandas Data Analysis
- Data Storage Optimization
- Data Migration Strategy
- Data Cleansing Techniques
- Large-Scale Data Management
- Workflow automation
- Quality assurance
- Technical communication
Certification
- Azure Fundamental, 09/01/20
- Teradata Vantage Developer, 06/01/20
- Teradata SQL, 06/01/17
- Teradata Basics, 09/01/16
Accomplishments
- Received award for key team player.
- Received spot award.
Personal Information
Title: Specialist Data Engineer
Timeline
Specialist Data Engineer
Ltimindtree
04.2021 - Current
Associate Data Engineer
Teradata
02.2016 - 04.2021
P.G - Cloud Computing
Great Learning
Bachelors of Engineering - Information Technology
Atharva College Of Engineering