Dedicated and results-oriented Cloud Data Engineer with over 5.5 years of experience in ETL, Database and application development, coupled with 2.5+ years of Relevant experience as an Azure Data Engineer.
Proficient in Azure Data Factory, Azure Databricks,AzureSynapse Analytics.
Good Experience in architecture and components of Spark, and efficient in working with Spark Core, Data Frames/Data Sets/RDD/Spark SQL, and expertise in building PySpark applications for interactive analysis and batch processing.
Good experience in Databricks Delta Table, Lakehouse architecture with a focus on Delta Lake technology.
Knowledge in Data Warehouse Concepts in OLTP/OLAP System Analysis.
Proficient in working with a variety of file formats, including CSV, PARQUET and JSON.
Good experience in the Digital Marketing, Trade Exhibition domain, showcasing a deep understanding of Revenue, P&L, Orders, Sales, and collateral data.
Involved development of Azure CI/CD pipelines to facilitate seamless deployment of Azure components.
Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using SQL Server and SSIS Packages.
Proficient in SQL Server Development/T-SQL which includes Stored Procedures, CTE, Indexes, Joins, Subqueries, Views, Analytical Function and Windows Function etc.
Overview
6
6
years of professional experience
6
6
years of post-secondary education
3
3
Languages
Work History
Azure Data Engineer
Brillio Technologies
02.2020 - Current
Worked closely with Business Analysts and End Users for gathering requirements and providing technical solutions during design phase.
Created Pipelines in Azure Data Factory using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Azure Synapse Data Warehouse.
Created transformations using Dataflow activity using various transformations like JOIN, FILTER, ALTER ROW etc. to extract and transform and load the data to targets like Azure SQL DB, ADLS Gen2 and Azure Synapse Data Warehouse.
Created Clusters and Notebooks in Azure Databricks using PySpark for data extraction, transformation, and aggregation from multiple file formats for analyzing and transforming the data to uncover insights into the customer usage.
Created external tables in azure synapse Serverless SQL Pool and created SQL queries to query the insights of the data through external tables from Data Lake.
Created tables in Synapse Dedicated SQL pool using hash distribution and round robin distribution for facts and dimensions tables.
Ingested data from a variety of file formats, including CSV, PARQUET, JSON and loaded into Delta Lake table.
Crated release pipeline to deploy the code into various environments like INT, UAT using Azure DevOps release pipeline through ARM template.
Successfully collaborated with cross-functional teams to develop and implement data-driven strategies, resulting in improved efficiency and data accuracy.
MSBI Developer
Theorem India Pvt Ltd.
12.2018 - 02.2020
Extensively working in Data Extraction, Transformation and Loading from source to target system using SQL Server Integration Services.
Creation of workflows with Data Flow Task, Script Task, Execute SQL Task and Containers.
Used Transformations like Derived Column, Conditional Split, Aggregate, Multicast, Merge Join, Data Conversions and Union all.
Optimizing SSIS package performance.
Optimizing ETL process.
Handling error and debugging of packages and fixing package failures during runtime
Creating Package Configurations, Loggings and deployed SSIS packages into PROD server
Involved in Design, Development, Testing, and Implementation of Database Design.
Hands on Debugging, Error Handling SQL scripts
Associate Software Engineer
Shakti IT Services Pvt Ltd.
10.2018 - 12.2018
Worked here to support the existing process in SQL Server and SSIS Packages.
Have implemented new business requirements in an existing pipeline as per the business need.
Education
Master of Computer Applications - Computational Science
Kalinga University
Naya Raipur, India
07.2015 - 06.2017
Bachelor of Computer Applications - Computational Science
Utkal University
Bhubaneswar
05.2011 - 06.2015
Skills
Azure Databricks
undefined
Interests
Playing Cricket
Watching Web Series
Timeline
Azure Data Engineer
Brillio Technologies
02.2020 - Current
MSBI Developer
Theorem India Pvt Ltd.
12.2018 - 02.2020
Associate Software Engineer
Shakti IT Services Pvt Ltd.
10.2018 - 12.2018
Master of Computer Applications - Computational Science
Kalinga University
07.2015 - 06.2017
Bachelor of Computer Applications - Computational Science