H1B Work Permit
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 29th Jul 2022
*If the consultant is coming from another time zone, he or she will need to work in EST time zone until at least June when they are established with the team.
We are seeking an experienced in ETL (Azure ADF), Data Modelling and DBA using Azure Synapse and MSSQL source data for a remote contract assignment .
This role will be responsible for building data extraction and transfer ETL code using SSIS. The data will be extracted from the Alpha system (typically raw VSAM files) to a SQL Server database. Designing the landing tables and data integration analysis will be part of the responsibility.
This resource will need to have:
- 2-3 years’ experience with building SSIS scripts (ETL tool)
- strong SQL skills (including experience with incremental data loading and star schema table design)
- strong SQL and data analysis skills - validate relationships to support joins and analyze integration issues – key matches, null values, etc)
- strong SQL Server database design skills (define and create new tables for new source data)
- ETL (Azure ADF), Data Modelling and DBA using Azure Synapse and MSSQL source data is a plus