Senior Azure SSIS Data Integration Developer
  • Richmond, Virginia, US
  • +914043515100
132 Days ago
Job Description
VDOT Senior Azure SSIS Data Integration Developer

*Local candidates only
*ALL candidates MUST be able to attend a Web Cam interview or in-person interview


VDOT is looking for a Sr Level Azure SSIS Data Integration Developer.
 
Responsibilities include:

Implement end-to-end data solutions in Azure.
Design, build and deploy effective SSIS packages, Azure Data Factory.
Implement ETL and data movement solutions using Azure Data Factory and SSIS.
Help business users analyze data as well as providing data insight to upper management.
Collaborate with business stakeholders and understand reporting needs and develop/modify a data model in Azure SQL.
Troubleshoot and resolve technical issues with data migration and transformation within the Microsoft Azure environment such as DataBricks, Data Factory, and other applications in the Development, UAT and Production environments.
Perform production deployments.
Experience working with transactional/relational data and SQL.

They will work with the Teams which are working on Agile Development, DevOps and TFS. We will consider, if the candidate have any working knowledge/experience in those areas.
 
Required/Desired Skills
 
Skill
Required /Desired
Amount
of Experience
SQL Server 2014 Development Skills
Required
5
Years
Azure Datalakes and Data Analysis
Required
3
Years
Azure SQL Databases, Azure SQL Tunings
Required
3
Years
Datalake tools, Databricks and Devops
Required
3
Years
SQL Server Integration Service (SSIS)
Required
3
Years
SSRS and SSAS
Required
3
Years
Source code and Team Management Software (TFS Preferred)
Desired
2
Years
Software Development Life cycle - Development and implementation Practices
Required
3
Years
Bachelor’s Degree in Computer Science or Information Systems
Nice to have
0
 
Importing and exporting large datasets from and to various sources.
Required
3
Years
Strong analytical skills to solve and model complex business requirements.
Required
3
Years
Experience in an Agile Scrum environment
Required
3
Years
Powershell Scripting
Highly desired
3
Years
Knowledge in Linux OS and Job Scheduling
Desired
2
Years
 
Questions
 
No.
Question
Question1
Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement?
Question2
Please list candidate's email address that will be used when submitting E-RTR.
Question3
In what city/state does candidate reside?
Question4
Is candidate willing and able to work onsite NA% at VDOT in Richmond, VA once the quarantine is lifted? At that time, there will be no more remote work, NO exception
Question5
Does your candidate's experience match or exceed the skills listed above and the number of years of experience with each sklll?
Question6
Does your candidate have three plus years of Azure Datalakes experience? This is REQUIRED.
Question7
How soon after an offer can your candidate start?
Industry
  • NA

Required Skills
  • SQL,Azure,Agile,TFS,SSIS,SSRS,Databricks,SSAS

Experience
  • NA

Salary
  • NA

Working Hours / Week
    NA