Required Skills

Data Engineer

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 10th May 2023

JOB DETAIL

·         Azure Solutioning

·         Azure DB Operations (DBA)

·         Azure SQL coding

·         Azure BLOB/Container management

·         Azure integrations - moving data - Data Factory

·         Azure Security

·         Azure Active Directory management

·         Azure Virtual Machines

·         Azure API Connections

·         Azure App Plans

·         Azure Application Insights

 

Requirements List

·         Build Secure access control process for data

·         Build a data intake process with error management, mapping and standardization

·         Build data file intake and processing automation

·         Build an automated job to download .txt/.mms files from WinSCP to Azure storage containers

·         Build a data repository to store the following in Azure Storage Containers

·         Claims data in multiple tables with multiple file layouts

·         Eligibility data in multiple tables with multiple file layouts

·         Refence data

·         Monthly reporting results

·         Call List results

·         Data used to create RFP analysis

·         OTI Results

·         Build a pipeline from Azure storage container to each claim table 

·         Build multiple pipelines using Azure storage container data to automate generation of Call Lists

·         Create customizable T-SQL scripts to select from each from 

Configuration to embed credentials into Tableau Server with OAuth method to auto-refresh extracts, or alternate solution if OAuth is not feasible

Company Information