Asdsadd
MOHAMMAD AFZAL
Fsdfaf
Noida
Summary
Senior Data Engineer with 8+ years building data warehousing and ETL solutions in Snowflake, Oracle, Teradata, SQL Server. Designed and maintained end-to-end ETL pipelines supporting key revenue impacting analytics for clients. Optimized SQL/ETL jobs to cut load time by 30% and reduce compute cost in Snowflake by 21%. Strong experience with Airflow, data modelling, databases and data quality and reconciliation frameworks.
Overview
9
9
years of professional experience
1
1
Certification
Work History
Senior Associate Engineer
Cognizant
06.2024 - Current
- Delivered technical solutions across multiple jira stories per sprint and support team objectives.
- Debugged and optimized stored procedures in Snowflake to ensure data accuracy and system performance.
- Resolved Power BI dashboard issues and maintained synchronization with backend data sources.
- Developed and tuned SSIS/SSMS ETL jobs to handle 560 GB of monthly data within a 9-hour SLA.
- Implemented data reconciliation and validation checks (rowcount, checksum, business rules) that cut data quality incidents by 40%.
- Fixed critical bugs across Development, UAT, and Production environments while data loads through Matillion ETL tool.
- Mentored 6 junior engineers, reviewed code, and drove best practices for version control and deployment.
- Client: Cummins
Senior Associate Engineer
Cognizant
10.2023 - 06.2024
- Delivered end-to-end Oracle to Snowflake migration for regulatory and analytics workloads, improving query performance.
- Integrated AWS S3 with Snowflake using SQS for automated, event-driven data ingestion.
- Developed SQL scripts and managed code repositories in GitLab for Snowflake operations and deployments.
- Built stored procedures for historical full loads and incremental delta processing in Snowflake.
- Designed batch configuration framework to control ETL workflows and job orchestration.
- Client: Flagstar Bank
Senior Associate Engineer
Wipro
10.2021 - 10.2023
- Converted Teradata stored procedures to Python-based Snowflake procedures, enabling cloud-native data processing.
- Built job scheduling framework using JSON configuration files and cron expressions for automated Snowflake task execution.
- Created GitHub-based JSON configurations and integrated Keystone authentication with data pipelines for secure Snowflake data loads.
- Monitored ETL workflows through Apache Airflow DAGs, tracking job status and analyzing execution logs.
- Optimized Snowflake procedure performance through query tuning, warehouse sizing, and best practice implementations.
- Client: Apple
Associate Engineer
ADP
03.2017 - 09.2021
- Performed data mapping, transformation, and query development to generate client-specific data deliverables.
- Extracted data from diverse sources (Oracle, SQL Server, flat files) and integrated into target systems.
- Created BTEQ scripts for data validation, integrity checks, and automated reporting in Teradata environments.
- Executed high-volume data loads from legacy systems to Teradata using MultiLoad and FastLoad utilities.
- Configured Teradata loader connections, developed utility scripts, and analyzed loader logs for performance optimization.
- Client: Amazon
Education
Dfwfwg - Dfssdgsd
Adaff
Adfdsf02.2017
Skills
Extensive experience with Snowflake, including Snowpipe, Tasks, and Streams for real-time data ingestion and processing
Software
Certification
SnowPro Core Certification (Certificate ID – S0024008)
LEARNING IN PROGRESS
DBT - familiar with models, source, test, Incremental materialisation (self study)
Timeline
Senior Associate Engineer
Cognizant
06.2024 - Current
Senior Associate Engineer
Cognizant
10.2023 - 06.2024
Senior Associate Engineer
Wipro
10.2021 - 10.2023
Associate Engineer
ADP
03.2017 - 09.2021
Dfwfwg - Dfssdgsd
Adaff