I have strong knowledge of data modeling (Data Vault, Inmon, Kimball) and data warehouse concepts, including normalization techniques and data mesh principles. I apply these disciplines to design scalable data architectures that support analytics and reporting across departments. I have led and participated in migration projects—from Oracle to Snowflake and from Teradata, Informatica to Snowflake, to Databricks—leveraging Snowflake features such as resource monitors, RBAC, virtual warehouses, and query performance tuning to ensure security and efficiency. I utilize Zero-Copy cloning, Data Sharing, Dynamic Tables, Time Travel, Snowpipes, Streams, Tasks, and Clustering for robust ingestion, processing, and optimization, while building data models and transformations with DBT and Python-based ETL/ELT pipelines. I also work with Azure Data Factory, Airflow, and Power BI to deliver end-to-end data solutions.

Amarjot Singh

I have strong knowledge of data modeling (Data Vault, Inmon, Kimball) and data warehouse concepts, including normalization techniques and data mesh principles. I apply these disciplines to design scalable data architectures that support analytics and reporting across departments. I have led and participated in migration projects—from Oracle to Snowflake and from Teradata, Informatica to Snowflake, to Databricks—leveraging Snowflake features such as resource monitors, RBAC, virtual warehouses, and query performance tuning to ensure security and efficiency. I utilize Zero-Copy cloning, Data Sharing, Dynamic Tables, Time Travel, Snowpipes, Streams, Tasks, and Clustering for robust ingestion, processing, and optimization, while building data models and transformations with DBT and Python-based ETL/ELT pipelines. I also work with Azure Data Factory, Airflow, and Power BI to deliver end-to-end data solutions.

Available to hire

I have strong knowledge of data modeling (Data Vault, Inmon, Kimball) and data warehouse concepts, including normalization techniques and data mesh principles. I apply these disciplines to design scalable data architectures that support analytics and reporting across departments.

I have led and participated in migration projects—from Oracle to Snowflake and from Teradata, Informatica to Snowflake, to Databricks—leveraging Snowflake features such as resource monitors, RBAC, virtual warehouses, and query performance tuning to ensure security and efficiency. I utilize Zero-Copy cloning, Data Sharing, Dynamic Tables, Time Travel, Snowpipes, Streams, Tasks, and Clustering for robust ingestion, processing, and optimization, while building data models and transformations with DBT and Python-based ETL/ELT pipelines. I also work with Azure Data Factory, Airflow, and Power BI to deliver end-to-end data solutions.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
See more

Language

English
Fluent

Work Experience

Data Engineer at Softest Consulting Services Ltd
February 1, 2025 - Present
Built ingestion pipelines using Snowpipes and Streams & Tasks for near real-time analytics; designed RBAC-based security models with Dynamic Data Masking and Row Access Policies; created data lakes on ADLS Gen2 with optimized partitioning; developed Python-based ETL/ELT pipelines to ingest, transform, and integrate data from APIs into Snowflake; optimized queries with dynamic tables, result caching, and multi-cluster warehouses; built and automated scalable pipelines using Python, ADF, DBT, and Airflow; configured resource monitors and warehouse auto-scaling to control compute costs and ensure high availability.
Data Engineer at Upwork
June 1, 2022 - November 1, 2022
Worked with stakeholders to design, develop, and deploy robust data pipelines utilizing Hadoop, Airflow, and Snowflake to orchestrate and automate data movement and transformation processes. Implemented Snowpipes, Snow Procedures, Dynamic Tables, Tasks, Streams to read data files, perform data cleansing and validation, and transform data per business requirements. Migrated on-prem Oracle PL/SQL to Snowflake, developed ETL pipelines to ingest data into S3, documented ETL/TRANSFORMATION techniques, and trained junior engineers. Created a scalable data analytics platform on Snowflake and mapped applications following Medallion Architecture. Built reusable assets to accelerate migration, optimized SQL queries, and explored Neo4j for POC.
Senior Data Engineer at IHS Markit Ltd
May 1, 2015 - February 1, 2022
Maintained the Data Pipeline and collaborated with Business Analysts to enrich and transform data using Databricks. Created POCs for end-to-end automation in Snowflake, orchestrated PySpark jobs via Airflow, and optimized Snowflake procedures. Led the development of the 'GIGS' web scraping project using Flask and PostgreSQL, and migrated a legacy Oracle Forms/Reports stack to a modern web application architecture. Implemented performance optimizations on Oracle procedures, mentored team members, and provided technical leadership in data warehousing best practices.
Software Engineer at Fidelity
December 1, 2012 - May 1, 2014
Collaborated with cross-functional teams to analyze potential system solutions and mentored junior developers in Oracle SQL/PL-SQL and data integration. Migrated legacy Sybase systems to Oracle, implemented Oracle procedure optimizations, developed data mappings in Informatica, and built AutoSys jobs for orchestration. Contributed to high-availability solutions for mission-critical applications and supported performance enhancements across multiple Oracle environments.
Developer at Sopra Group
April 1, 2010 - November 1, 2011
Participated in a significant database migration project, transitioning data and applications from Sybase to Oracle. Contributed to feature development, debugging, and production releases; developed and documented unit tests; created shell scripts to automate data loading into Oracle; provided production support for critical issues; designed and implemented reconciliation processes between legacy and target systems; received an award for resolving critical production issues.

Education

MTech. In Software Systems at BITS PILANI (WILP)
August 1, 2020 - July 1, 2022
Bachelor’s in Information Technology at Kurukshetra University
January 11, 2030 - January 25, 2026

Qualifications

Certified Associate Developer for Apache Spark 3.0
January 11, 2030 - January 25, 2026

Industry Experience

Software & Internet, Financial Services, Professional Services