Jafar Shaik

Data Engineer

Greater Toronto Area, Canada4 yrs 1 mo experience
Highly Stable

Key Highlights

  • Expert in Azure Data Engineering and ETL processes.
  • Proven track record in optimizing data storage solutions.
  • Skilled in real-time data processing and analytics.
Stackforce AI infers this person is a Data Engineer specializing in Azure solutions for SaaS applications.

Contact

Skills

Core Skills

Data EngineeringData Warehousing

Other Skills

Azure Data FactoryETLAzure Blob StorageAzure Data LakeAzure FunctionsAzure DatabricksPySparkAzure Event HubsAzure Stream AnalyticsAzure Synapse AnalyticsSnowflakeAzure Key VaultAzure SQL DatabasePie chartsDecision-Making

About

• With over 3+ years of hands-on experience in Data Engineering, Analysis, and Modeling, I have developed a robust skill set in designing and optimizing data pipelines, extracting meaningful insights from complex datasets, and building efficient data models to drive business intelligence and decision-making. • Skilled in sourcing, validating, and transforming data from multiple systems into Azure Data Lake and Azure SQL Database using Python and SQL. • Hands-on experience designing and deploying scalable Azure Data Pipelines and utilizing Synapse for solving complex business problems related to large-scale data warehousing, analytics, and reporting. • Proficient in Python, T-SQL, Azure Data Factory, Exploratory Data Analysis (EDA), and creating insightful visualizations with Power BI. • Experienced in automating pipeline workflows, setting up triggers, and mapping data flows in Azure Data Factory (V2), while securely managing credentials with Azure Key Vault • Proficient in using Terraform for deploying, updating, and deleting multiple resources in Azure and migrating on-premises resources to the cloud • Worked in Agile development teams, demonstrating excellent communication skills, understanding of project timelines, and the ability to manage dependencies. Highly collaborative, self-motivated, and dedicated to ensuring successful project delivery. • Proficient in creating notebooks in Databricks utilizing PySpark and SQL for data extraction, transformation, and aggregation from multiple file formats. This process enabled deeper insights into client usage patterns by analyzing and transforming the data. • Developed automated ETL pipelines to streamline data ingestion, cleansing, transformation, and mapping processes, ensuring efficient and timely delivery of data to clients • Led the design and implementation of data engineering solutions, including data architecture, modeling, ETL development, automation, and migration for structured and semi-structured data, aimed at supporting data analytics products • Partnered with stakeholders to ensure adherence to best practices in data engineering, focusing on performance, reusability, and compliance with enterprise-wide data governance policies • Led the migration of data and databases from on-premises infrastructure to the Azure Data Lake and this involved transferring raw data to Azure Storage, processing it through Azure Functions and Azure Databricks, using HDInsight, and storing the results in Azure SQL Database and Azure Synapse

Experience

4 yrs 1 mo
Total Experience
4 yrs 1 mo
Average Tenure
4 yrs 1 mo
Current Experience

Datastaq solutions

Azure Data Engineer

Apr 2022Present · 4 yrs 1 mo · Canada

  • Developed and managed robust ETL pipelines using Azure Data Factory, enabling efficient data extraction, transformation, and loading from multiple sources to Azure SQL Database and Snowflake, ensuring data integrity and accessibility
  • Architected and optimized scalable data storage solutions with Azure Blob Storage and Azure Data Lake, providing high availability, scalability, and cost-effective data management for large-scale analytics projects
  • Automated complex data workflows using Azure Functions, significantly reducing manual intervention and improving the efficiency and reliability of data pipeline operations
  • Utilized Azure Databricks and PySpark to build and manage advanced data processing jobs, supporting machine learning models and facilitating predictive analytics initiatives
  • Implemented real-time data ingestion and processing solutions with Azure Event Hubs and Azure Stream Analytics, delivering low-latency insights crucial for business operations and decision-making
  • Integrated and optimized data warehousing solutions using Azure Synapse Analytics, enabling comprehensive analytics and real-time reporting capabilities across the organization
  • Monitored and troubleshooted ETL processes to identify and resolve issues promptly, ensuring minimal downtime and maintaining data pipeline reliability
  • Enhanced data processing and analytics capabilities with Snowflake, ensuring seamless integration with Azure services and optimizing storage and query performance for large datasets
  • Designed and maintained secure data environments leveraging Azure Key Vault, implementing industry best practices for managing secrets and safeguarding sensitive information
  • Performed root cause analysis for data discrepancies and implemented corrective actions, enhancing the overall data quality and integrity within the data warehouse
Azure Data FactoryETLAzure Blob StorageAzure Data LakeAzure FunctionsAzure Databricks+8

Education

Conestoga College

Project Management — Business

Sep 2021Apr 2022

Certification in Agile Scrum Essentials

Sep 2024Sep 2024

SRKR Engineering College

Bachelor of Engineering - BE — Civil Engineering

Jul 2013Apr 2017

Stackforce found 100+ more professionals with Data Engineering & Data Warehousing

Explore similar profiles based on matching skills and experience