Job Description :
Job Title: Azure Data Warehouse Engineer [BizID#6270]
Job Location: Seattle, WA
No of Positions: 12
Skills:
Delivery of Azure solution as per the finalized architecture. Understanding of downstream systems to define future road maps
Must have 1-2 yrs of experience in Microsoft Azure Fundamentals
Participate in Framework design & building solution
Resolve all the technical impediments like requirement dependency, data dependency, environments down, etc.
Data Extraction from Source systems using ingestion techniques Azure data factory
Review Data Architecture/ETL design documents and develop ADF pipelines/Databricks notebooks as per the requirement
Experience developing Business Intelligence solutions using Microsoft BI Stack is a plus - SQL Server, SSAS, SSRS, and SSIS.
Experience designing and developing SQL Server Databases for data warehouse, data mart or decision support systems.
Key Skills:
Azure, Devops, SSIS, ETL
Required Experience and Qualifications:
Good to have - knowledge on Unix shell commands and basic knowledge on scripting (shell and perl)
Update the Devops Sprint boards at the PBI level every day and drive it to completion
Must have experience in Application Monitoring and Feedback Loops and working in DevOps and DevOps tools.
Must have experience in Automating Azure Workloads and Azure Security and Compliance and development using ADF/ SSIS in Azure
Must have worked in Continuous Integration and Deployment environment
Good data profiling and data analysis skills.
Should have good knowledge on ETL performance tuning
Design the incremental and historical load strategy
Perform Code Reviews, Unit test cases review and testing
Should have basic knowledge on reporting and OLAP.
QA and PRD support
Support production issue and provide timely resolution
Support production deployment and post-production support
Monitor and report application and data load performance
Track and report SLA
Telecom experience a plus