Associate Data Engineer-ETL - Data Entrega India Pvt Ltd
Hands-on experience in Snowflake, Data Vault 2.0, ETL/ELT development, Coalesce, and Wherescape for enterprise data warehousing and data integration solutions
- Integrated Snowflake data models with Power BI/Tableau dashboards for reporting
- Collaborated with cross-functional teams, business analysts, and stakeholders to gather requirements and deliver data engineering solutions
- Designed and implemented a Data Vault 2.0 model on Snowflake with Hubs (Customer, Order, Product), Satellites for attribute historization, and Link tables (Link_Cust_Order, Link_Prod_Order) to track many-to-many relationships
- Utilized Snowflake Streams, Tasks, Time Travel, and Zero-Copy Cloning for automated data processing, recovery, and environment management
- Optimized Snowflake workloads through clustering strategies, query profiling, warehouse sizing, and data partitioning techniques
- Exposure to Apache Spark for large-scale data processing and transformation
- Exposure to Hadoop ecosystem including HDFS and Hive for large-scale data storage and processing, and used Sqoop for bulk data ingestion between relational databases and Hadoop environments
- Developed and scheduled ETL workflows using orchestration tools for automated data pipeline execution and monitoring
- Knowledge of Dimensional Modelling techniques like Star Schema, Type2 slowly changing dimensions and various types of fact tables
- Hands on Experience in shell scripts for handling script-based ELT pipelines using wherescape red
- Experience in data warehousing concepts like Star schema, snowflake schema and data vault, data mart, and data warehousing concept
- Hands-on experience in designing and implementing ETL/ELT pipelines for enterprise data integration projects
- Experience in developing batch and streaming data pipelines for processing large-scale structured and semi-structured datasets
Associate Consultant - Nice Software Solutions Pvt Ltd
- Strong background in Big Data and Data Analytics with exposure to distributed processing frameworks
- Strong Expertise in SQL and hands on experience with Cloud Data Warehouse (Snowflake)
- Experience managing backend deployment workflows, Git repository configuration, and CI/CD support for ETL environments
- Ability to work on Database Recovery and Data Modelling, Data Warehouse, Data Vault 2.0, ETL Tools
- Expertise in Data modelling, ELT, Implementing stored procedures and standard Datawarehouse Concepts
- Main responsibilities were to end to end ETL development tasks such as extracting data from multiple sources, data cleaning/data transformation and loading the data directly into the data warehouse
- Skilled in advanced SQL development, performance tuning, ETL/ELT pipeline creation, data modeling, and cloud-based data platforms
- Designed and maintained Snowflake database objects including tables, views, stored procedures, streams, and tasks
Software Engineer - Clover Infotech Pvt Ltd
- Experience collaborating with development and operations teams for cloud deployment, build automation, and release management activities
- Configured and managed GitHub repositories for ETL project version control, branching, code reviews, and deployment management
- Created and maintained Git branching strategies including feature, release, and hotfix branches to support Agile ETL development lifecycle
- Practical exposure to CI/CD tools and deployment automation using Git, Jenkins, GitHub Actions, and cloud-native DevOps workflows
- Strong backend expertise in designing, developing, and maintaining scalable ETL pipelines and data processing systems using SQL, Snowflake, DBT, Coalesce
Datawarehouse Consultant - Data Entrega India Pvt Ltd
- Developed shell and Python scripts for ETL automation, data validation, and deployment support activities
- Developed and scheduled ETL workflows using orchestration tools
- Worked on data modeling, ETL pipelines, debugging Development issues, and collaborating with business stakeholders to implement scalable data engineering solutions
- Integrated GitHub with ETL tools such as Wherescape Red, Wherescape 3D, Coalesce, Snowflake
- Automated ETL deployment processes using GitHub repositories and CI/CD integration for database objects, stored procedures, and transformation scripts
- Maintained version history for ETL mappings, workflows, Snowflake and data warehouse objects using GitHub
- Collaborated with development and data engineering teams using GitHub issue tracking, code reviews, and repository management
- Closely worked with ETL teams to work on business requirement, data flow, trackbacking the whole process
