Job ID :
33387
Company :
Internal Postings
Location :
Seattle, WA
Type :
Contract
Duration :
6 Months
Salary :
DOE
Status :
Active
Openings :
1
Posted :
09 Sep 2021
Job Seekers, Please send resumes to resumes@hireitpeople.com

Must Have Skills:

  • Microsoft Azure, Spark, Python, ADB ,ADF

Detailed Job Description:

  • Requirement analysis, analyze and understand data structure of source systems (data available thru OData)
  • Evaluated considering functional and non-functional requirements, technical feasibility and efficiency
  • Lead technical discussions with customer architects to articulate solution, design, performance engineering results
  • Propose to-be solution architecture and framework to meet business needs of data ingestion by implementing services (SSIS jobs) to ingest from RESTful APIs (OData)
  • Identify data security risk from technology perspective to support access controls to downstream system for data consumption
  • Develop services to ingest, validate and load data to data storage
  • Increase automated enrichment of source data as much as possible to reduce any calculations required in visualization and improve data quality
  • Implement RDBMS concepts & principles in database management systems, database physical & logical design and table normalization to store source data in data storage.
  • Create/update data model for data storage in Microsoft SQL Server
  • Propose roadmap for visualization of data in terms of analytics, user experience and implementation by creating visualization wireframes
  • Identify performance optimization in data ingestion, data store & visualization and suggest steps to resolve performance issues