Position: Azure Data engineer
Location: Washington DC. ***Day 1 Onsite***
Duration: 1 Years
JD:
- In-dept knowledge and hands-on experience in Microsoft Azure data stack i.e. Azure Data Factory Azure Synapse Azure SQL Database etc.
- Experience of big data approach architectural concepts data sourcing/ ingestion/ curation and storage mechanisms.
- Experience with real-time / near-real-time data warehousing concepts and design approaches.
- Good understanding of OLTP and OLAP concepts and Strong knowledge on design concepts of Database and Data ware housing systems.
- Must have strong development & design skills in SQL and PL/SQL areas in RDBMS environments e.g. MS SQL Server and Oracle 11g/18c/19c.
- In-depth knowledge of NoSQL database usage within enterprise context and design/ modeling approach
- Building and migrating the complex ETL pipelines from on premise system to cloud database such as Azure SQL Data warehouse Spark to make the system grow elastically
- Provide a high level of ETL technical services and support; is considered an expert in multiple ETL technologies; maps data source to destination
- Building and migrating the complex ETL pipelines from on premise system to cloud database such as Azure SQL Data warehouse Spark
- Provide a high level of ETL technical services and support; is considered an expert in multiple ETL technologies; maps data source to destination
- Experience building Azure data lake ETL pipelines component such as Azure Data lake Analytics Azure SQL database and SQL Datawarehouse.
- Expertise with data modeling on Azure SQL database and SQL Datawarehouse
- Expertise with building Azure data catalogue
- Data Integration : Building Pipeline and workflows (ETL) with Azure data factor