Azure Data FactoryAzure SQL Data WarehouseAzure Data Lake/Blob Storage
Work Authorization
Us Citizen
Green Card
EAD (OPT/CPT/GC/H4)
Preferred Employment
Corp-Corp
Employment Type
Consulting/Contract
education qualification
UG :- - Not Required
PG :- - Not Required
Other Information
No of position :- ( 1 )
Post :- 11th Mar 2021
JOB DETAIL
Job Description
Implement data warehouse solutions using Azure DW stack and Power BI
Drive Azure cloud data platform architectural decisions and development standards.
Develop and deliver large-scale Azure cloud application development and transformation engagements, helping the enterprise understand cloud considerations, develop cloud application strategies and helping refactor existing applications for Azure, as well as develop new Azure-based cloud-native applications on Azure PaaS
Work with Product Owner/Business Analysts to understand functional requirements and interact with other cross-functional teams to architect, design, develop, test, and release features.
Develop and maintain documentation of schemas, data flows and processes related to Azure DW
Design and construct Data Lake ingestion and staging of corporate data sources for Analytics purposes using Azure Data Factory.
Design and implement Data Lake lifecycle processes that support effective data provisioning capabilities to feed analytical requirements, ingest various data sources and support Machine Learning requirements.
Design and implement ETL routines using Azure Data Factory to load transformed data into the Data Warehouse.
Design Azure Analysis services data models with a focus on standardized data sets, calculations, and definitions to support Power BI report development by Analytics end users.
Work closely with Power BI report creators empowering them to map reports to standardized data models that are under pinned by the Data Warehouse solution.
Develop Proof-of-Concept projects to validate new architectures and solutions.
Skills:
5-10 years of experience with:
Strong hands-on experience in Azure data platform including Azure SQL, Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake/Blob Storage. Knowledge in Azure Databricks/Spark and Cosmos DB is a plus but not essential.
Develop robust ETL processes specifically in the Azure DW using Azure data factory pipelines, Azure functions, SQL, APIs, and industry best practices.
Mastery of SQL, specifically MS SQL Server
Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
Experience configuring Data Lake on Azure Databricks/Spark.
Experience in designing data solutions in Azure including data distributions and partitions, scalability, disaster recovery and high availability
Experience with data migration to cloud-based environment
Experience implementing predictive analytic models with proven business impacts.
You have a solid understanding of cost and performance considerations and tradeoffs of different data products within Azure
Hands on experience in developing visual reports, dashboards and KPI scorecards using Power BI is a plus but not essential.
Sound knowledge in security standards. Able to implement row level security on data and understand application security layer models in Power BI.
Python experience is a plus.
Experience implementing Azure Stream Analytics for IOT is a plus.