Bhaskar, Data Engineer | Bench Resource on Contract

Data Engineer

Location : Jaipur

Experience : 6 Year

Rate: $27 / Hourly

Availability : Immediate

Work From : Offsite

Category : Information Technology & Services

Shortlisted : 1

Total Views : 179

Key Skills

Azure Data Factory Power BI SQL Server Integration Services SQL Server Analaysis Services Azure Data Warehouse Python Azure SQL

Discription

Professional Experience
01/2021 – present
Hyderabad, India

Designed of Data warehouse for stable implementation.
Designed and developed Azure Data factory pipelines for Data migration.
Integrated Azure Data Factory for scheduling Jobs and Triggering other related Job.
Created Logic Apps to trigger the mail notification from ADF Pipelines.
Implemented Stored Procedures business logic in Azure SQL Data warehouse.
Created CI/CD pipelines for ADF deployment in ADO
Validated the data at overall and every dimension level.
Written test cases to validate data in ADO

09/2018 – 12/2020
Hyderabad, India
MAQ Software (Project: Successful Engagement BI)
Senior Software Engineer

Designed of Data warehouse for stable implementation.
Designed and developed Azure Data factory pipelines for Data migration.
Integrated Azure Data Factory for scheduling Jobs and Triggering other related Job.
Created Logic Apps to pull the data from SharePoint excels to ADLS.
Implemented Azure Databricks notebooks business logic at Data warehouse level.
Created a mount point in Python to access the files reside in ADLS.
Created user defined functions using Python.
Created data frames, views and tables using Python in Azure Databricks.
Used Python loops and aggregation techniques to process data in Azure Databricks.
Published the Fact and Dimension tables from ADB to Azure SQL Data warehouse and ADLS using Python.
Created validation framework using Python in Azure Databricks.
Created Tabular model on Fact and Dimension views which are in Azure SQL Data warehouse.
Updated Tabular level measures and dimensions, wrote DAX queries for calculated measures.
Validated the data at overall and every dimension level in Tabular, checked on data is slicing at every dimension level
Written test cases to validate data in at Tabular in ADO
Developed reports using Power BI.
Analyst with 6 years of experience in designing architecture and developing high quality Business Intelligence
Advaita Services

Senior Azure Consultant
Bhaskar
07/2017 – 08/2018
Hyderabad, India
MAQ Software (Project: One Commercial Partner)
Software Engineer 2

Designed and developed relational databases.
Guiding team members.
Developed SSIS packages to load the data from different sources to SQL and create a Data warehouse.
Implemented Stored Procedures to process business logic at Data warehouse level.
Created Tabular model on top of Data warehouse
Implemented main business logic for financial metrics in Tabular using DAX queries
Validated the data at overall and every dimension level in Tabular, checked on data is
slicing at every dimension level
Developed reports using Power BI.
Wrote automated BVT SPs to check values at each level on refresh of data developed script files on big Data platform to make the heavy data to be processed.

04/2016 – 06/2017
Hyderabad, India
MAQ Software (Project: Marketing Insights)
Software Engineer 1

Designed of Datawarehouse for stable implementation.
Created SQL code in multiple SPs to implement business logic.
Modified SSIS packages to load Assessment data to data warehouse.
Designed Power BI reports and Dashboards.
Implemented Row Level security in Power BI.
Wrote automated BVT SPs to check values at each level on refresh of data developed script files on big Data platform to make the heavy data to be processed.