Posted 3 months ago
Data warehouse Lead ETL developer (Microsoft SSIS) - Westwood, MA - 6 Months+ # B250660
AI Summary
Lead ETL developer responsible for designing, building, maintaining, and documenting data integration solutions using Microsoft SSIS and SQL Server to connect various systems with a data warehouse.
About this role
Data warehouse Lead ETL developer (Microsoft SSIS) - Westwood, MA - 6 Months+ # B250660
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.
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 mvkramarao@mitresource.com or Ph # 203-567-0129 for further information.
Skills
Explore related jobs
More jobs at Maganti IT Resources LLC
- SAS Programmer with Programming Languages and Hadoop ExpAlbany, NY
- MQ Message Broker Admin - Albany, NY - 24 Months - # 17251/130645Albany, NY
- Adobe LifeCycle Specialist - Albany, NY - 6 Months - # 17281/110645Albany, NY
- Oracle ETL Developer - Rensselaer, NY - 24 Months - # 17231/110645Rensselaer, NY
- Net WCF PL SQL Developer - Rensselaer, NY - 24 Months - # 17321/110640Rensselaer, NY
- VB Net Oracle Developers - Rensselaer, NY - 24 Months - # 17471/170640Rensselaer, NY
Similar Agile Software Development jobs
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.