MANDRIKA, AZURE DATA ENGINEER | Bench Resource on Contract

MANDRIKA (RID : pp3lnq46o9s)

AZURE DATA ENGINEER

Location : NOIDA, India

Experience : 11 Year

Rate: $20 / Hourly

Availability : Immediate

Work From : Offsite

Category : Information Technology & Services

Shortlisted : 0

Total Views : 60

Key Skills

AZURE DEVOPS CI/CD AZURE DATA LAKE ETL SQL DATA ANALYSIS POWER BI QUERY QUERY

Discription

Mandrika

Sr. Software Developer

SUMMARY_______________________________________________________________________________

Over 11.3 Years of experience in Business Intelligence lifecycle projects from requirement gathering, documentation, data analysis, modeling, development, production, deployment, and support.
Experience in Power BI lifecycle projects from requirement gathering, documentation, data analysis, modeling, development, production, deployment, and support.
Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI.
Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.

Used Git and Azure DevOps to perform version control, peer review, and enhance collaboration and implementing CICD pipelines.
Designed Pipelines in ADF using Linked Services, Datasets, Pipelines to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, FTP/SFTP, S3.
Built Azure Data Factory ETL and ELT pipelines to ingest raw data from several data sources and store it in Azure Data Lake Storage for downstream processing.
Created dynamic pipeline with stored procedures or data flow in Azure Data Factory to update different dimensional tables for reducing the number of activities and easier maintenance.
Participated in the design and development of data solutions that use Azure Data Factory and Azure Synapse Analytics to support the Business Intelligence team to deliver actionable insights.
Used Azure Databricksto exact raw data and transform it into bronze by adding metadata, then cleansed, validated, and enriched bronze data to silver and gold tables and persisted them in ADLSbased Delta Lake.
Conducted daily batch incremental load by Azure Data Factory to update the data for customer use.
Implemented Slowly Changing Dimension Type 2 in Delta Lake as the update strategy to keep the full historical player and team profiles.
Involved in creating the Python Databricks Scripts for Spark data frames to read the data from Data Lake and use Spark SQL context for transformation.
Built new Data factory Pipelines for data ingestion from On Prem FTP servers to Azure data lake store using Azure Data Factory.
Involved in creating the Python scripts in notebooks for transforming data from raw to stage and then to curated zones using Azure data bricks.
Utilized Microsoft Power BI, Power BI Pro, Power Query, Power Pivot, Power BI Service, and Microsoft Excel Pivot Table to deliver Data Analytics reports
Modeled data using DAX, Power Query according to business requirements. Management of access and troubleshooting of reports for resolution of issues.
Troubleshoot and created complex calculations using DAX. Developed Proof of Concepts (POC) for various projects using Power BI.
Developed business logic using DAX to provide custom functionality in Power BI Applications.
Scheduled refreshes through the Power BI gateway to refresh Dashboard at regular intervals and appropriate dependencies.
Designed various Power BI graphical and visualization solutions based on business requirement documents and plans for creating interactive dashboards. Utilized Power Query and M Language in Power BI Desktop to Pivot and Un-pivot data models for data cleansing and data massaging.

TECHNICAL SKILLS______________________________________________________________________

Operating Systems: Windows
Programming/Scripting Languages: SQL
Data Analysis Tools: Power BI, Advanced Excel, SSAS, Azure analysis services.
ETL Tool: SSIS & Azure data factory
Databases and Web Servers: SQL server, Azure SQL Server, Azure Storage.
Project Management and Quality Tools: Azure devops, GitHub

PROFESSIONAL EXPERIENCE___________________________________________________________

Confidential _ from July 2021 – Present

Role: Sr. Software Developer

Client: T-Mobile

Responsibilities:

Extensive experience on Azure Data Lake Analytics, Azure Data Lake Storage, AZURE Data Factory, Azure SQL databases and Azure SQL Data Warehouse for providing analytics and reports for improving marketing strategies.
Data extraction from vario