Data warehouse Lead ETL developer (Microsoft SSIS) - Westwood, MA - 6 Months+ # B250660

  • Contract

Company Description

Candidate willing to work on our W2 payroll will be considered most.

Candidates eligible to work at USA with valid visa should apply.

Third Party Vendors Please do not submit your candidates.

Job Description

Title: Data warehouse Lead ETL developer (Microsoft SSIS) - Westwood, MA - 6 Months+ # B250660

Location: Westwood, MA

Duration: 6 Months+ 

 

This data warehouse developer will create, maintain, and document programs that help us integrate various systems with the data warehouse. The ideal candidate will:


-Have data-centric development experience primarily with the Microsoft stack... SSIS, MS Sql Server
-Have good analytical skills such as is required for researching end-to-end data lineage issues regardless of technologies used
-Have the skills needed to integrate data feeds with the data warehouse whether traditional ETL or programming interfaces with external systems.

Qualifications

Candidates should have at least 84 months experience, and the following should apply:

  

 

Required:
-3-7 years of experience developing ETL (Extract, Transform, and Load) packages with SSIS and MS Sql Server as well as package configuration, deployment, and scheduling.
-3-7 years of experience developing with MS SQL Server, developing stored procedures (T-SQL), and debugging/optimizing complex queries.
-Solid understanding of data warehousing concepts including the common schema architectures, dimensions, facts, aggregate facts, and data marts.
-Experience with traditional as well as agile software development processes and methodologies.
-Work well independently as well as with a diverse group of business users and technical experts to gather and clarify requirements as needed.
-Excellent written and verbal communication skills.

Desired/Plus:
-Experience as a technical lead and working with off-shore resources
-Experience with Pragmatic Works BIxPress
-Experience with MicroStrategy or other BI/enterprise reporting tools
-Experience as a developer using Visual Studio 2008/2010, .NET, C#, Javascript, JQuery
-Programming experience with file-based databases and data formats like Access, FoxPro, Excel, SDF files, XML files, etc...
-Experience with Windows PowerShell and advanced scripting scenarios.
-Experience integrating with 3rd party API's 

Additional Information

Please respond with updated resume and covering letter with few sentences how you meet each Requested Qualification referring your earlier projects

3 references are must with the resume.

Please note that our client does allow Skype/remote interviews.  However they reserve the right to require an in-person interview.

Contact [email protected] or Ph # 203-567-0129 for further information.