Epicareer Might not Working Properly
Learn More
A

C2C Job Remote 100% - Data Warehouse Developer With 6 Years T-SQL Development Expeirnce(Passport Number Must)

Salary undisclosed

Apply on


Original
Simplified

Please share the updated resume at -

Job Role - Data Warehouse Developer With 6 Years T-SQL Development Experience (Passport Number Must)

Location - Remote 100%

Mandatory Skills - 6+ years of T-SQL development, 4+ SSIS working experience, Strong database and data warehouse modelling experience, Microsoft database projects (dacpac), DevOps

Contract C2C/Corp To Corp Job

Job Description

We are looking for a Data Warehouse Developer. This position will be remote contract opportunity. This project involves conversion of legacy data warehouse to a new architecture which includes Data Vault 2.0 and traditional Data Mart.

What You ll Do

  • Connect to new data sources
  • Explore data, model in the data vault and data mart
  • Configure and/or code data vault and data mart structures
  • Code complex stored procedures which implement business rules and load Fact tables
  • Convert complex existing report stored procedures from the legacy warehouse to the new one
  • Validate results using T-SQL; document all the differences
  • Troubleshoot code at all levels
  • Work with the report developers as they adapt to using the new warehouse
  • Individual will be on a very small team (2-3 people) and needs to be a self-starter who can quickly get up to speed

What You'll Need

Required:

  • 6+ years of T-SQL development. Very strong T-SQL skills needed
  • 4+ years SSIS experience required
  • Strong database and data warehouse modeling experience
  • Experience with Microsoft database projects (dacpac)
  • Experience with DevOps
  • Experience with Microsoft Access as a front end for SQL Server

Preferred

  • Experience with advanced T-SQL such as dynamic code generation, recursion, Gaps & Islands desirable
  • SSAS experience desired
  • Exposure to Data Vault
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
Report this job