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

Maganti IT Resources LLC

Apply to this job
Westwood, MA, us on site Until 8/23/2026 H-1B sponsor history First posted March 27, 2025 Last posted March 27, 2025
Job 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.

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.

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 

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.

About this role

Summary

Develop and maintain data warehouse ETL packages using Microsoft stack, collaborate with teams, optimize queries.

Job title

Data warehouse Lead ETL developer (Microsoft SSIS)

Experience level

3-7 years

Industry

software

Location requirements

Westwood, MA; remote interviews allowed

Salary

Not specified

Visa sponsorship

H-1B sponsor history

Management role

No

Skills & keywords

Required skills

ETLSSISMS SQL ServerT-SQLdata warehousing

Preferred skills

BIxPressMicroStrategyC#JavascriptPowerShellAPI integration

Specializations

ETLSSISMS SQL Serverdata warehousingprogramming
Locations

Structured locations inferred from the posting.

Westwood, MA 02090, USA

On-site City

Westwood, MA 02090, USA

Remote City