Required Skills

ETL Python

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 :- 14th Mar 2024

JOB DETAIL

Local Richmond, VA candidates only please

*Candidate may be required to attend a second, onsite interview. Please ONLY submit candidates who are able to attend the onsite interview.

*Candidate must also be able to work onsite 2-3 day/week

**Contractor will be responsible for purchasing parking through VDOT’s Parking Management Office or procuring their own parking

**Contract to be extended beyond 6/30/24, likely by 6-12+ months

 

Job I’d: VA-730968

Client: VDOT

 

Skills:

Experience in designing, building, and deploying scalable Azure cloud-based data solutions. Required 10 Years

Hands-on experience with Azure services such as Azure Data Factory, Azure Databricks, Azure Data Lake Storage, Azure SQL, Azure Synapse Required 5 Years

Hands-on experience in SQL Server (SSIS, SSRS, SSAS), ORACLE, T-SQL Required 10 Years

Hands-on experience in Azure SQL Database, Azure SQL Datawarehouse Required 7 Years

Hands-on experience in deploying and maintaining large-scale data processing pipelines. Required 10 Years

Hands-on scripting experience with Windows and/or Python, Linux Shell scripting. Required 10 Years

Experience in Azure DevOps, or Continuous Integration/Delivery Highly desired 7 Years

Knowledge of C# and .Net Nice to have 3 Years

 

Description:

VDOT is looking for a Senior Azure ETL developer to ingest/transform and load Data Assets and implementation of a cloud-based data management platform that will support the agency.

 

This role is expected to take a Sr Developer role within the team, to extract business data and load it into a data warehousing environment. Design and test the performance of the system. Consult with various teams to understand the company’s data storage needs and develop data warehousing options. Well-versed in warehousing architecture techniques such as MOLAP, ROLAP, ODS, DM, and EDW.

 

Qualifications-

Experience in designing, building, and deploying scalable Azure cloud-based data solutions.

Hands-on experience with Azure services such as Azure Data Factory, Azure Databricks, Azure Data Lake Storage, Azure SQL, Azure Synapse, and other data sources.

Hands-on experience in SQL Server (SSIS, SSRS, SSAS), ORACLE, T-SQL, Azure SQL Database, Azure SQL Datawarehouse

Hands-on experience in deploying and maintaining large-scale data processing pipelines.

Hands-on scripting experience with Windows and/or Python, Linux Shell scripting.

Experience in data analysis and provide cloud based technical solutions.

Experience working on both on-prem and cloud-based data solutions.

Experience in querying and analyzing small and large data sets to discover patterns and deliver meaningful insights.

Work with data architects, data engineers, business analysts, and business teams to provide Azure data driven solutions.

Experience in Azure DevOps, or Continuous Integration/Delivery

Well-versed with Agile practices.

Familiarity with C# and .Net is a huge plus.

Company Information