Job ID :
23512
Company :
Internal Postings
Location :
Houston, TX
Type :
Contract
Duration :
6 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
24 Jul 2019
Job Seekers, Please send resumes to resumes@hireitpeople.com

Detailed Job Description:

  • Good knowledge of different Azure services related to Data Engineering
  • Hands on experience in designing & development of ETLs using Azure data factory 
  • Should know how to establish connections to different data sources such as Data Lake, web portals, database, Hadoop etc.
  • Should be familiar with all the transformations available in ADF such as copy, web, look ups, decision controls, iteration loops, data flow task etc. in order to perform ETL
  • Should have experience in scheduling and automating ADF pipelines
  • Should have good experience in data modelling & data warehousing in Azure
  • Good experience in SQL Server database system and No-SQL databases: knowledge of SQL query is a must
  • Should be able to design and develop stored procedures for Azure SQL DWH
  • Hand-on experience on Polybase or any other external table concepts
  • Good Hands on Experience on Power BI, and Should be familiar with end to end setup for an on premise and cloud deployment of Power BI
  •  Understanding of the infrastructure requirements of setting up Power BI from scratch
  • Must have worked with connectors to various data sources such SQL Server, Oracle, SAP HANA etc
  • Hands-on dashboard design on Power BI desktop, must have done report creation using virtualization on Power BI.
  • Data modelling, Calculations, Conversions, Scheduling Data refreshes in Power BI Desktop
  • Should be able to create gateways and app work spaces 
  • Should be able to import data from multiple data sources

Minimum years of experience*: 5

Interview Process (Is face to face required?) No