Role: Microsoft SSIS and .NET/C# lead developer
Location: Westwood, MA
Microsoft SSIS and .NET/C# lead developer
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... .NET, 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.
3-5 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 years of .NET programming experience using C# and Visual Studio (.NET 4.0+, VS2010 preferred).
Solid understanding and experience with Microsoft Sql Server including designing databases and associated objects, developing stored procedures using T-SQL, and performing, debugging, and optimizing complex queries.
Familiarity with 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.
Experience as a technical lead... position may require leading other off-shore ETL devs over time.
Experience programming .NET WCF services, XML web services, interfacing with HTTP interfaces, and service-oriented-architecture (SOA).
Experience with Pragmatic Works BIxPress
Experience with MicroStrategy and integration via the MicroStrategy SDK and/or TaskAdmin http interface.
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
Experience developing dashboards and reports for a financial services business and executive-level reporting.
Experience with Hadoop, MongoDB (or other NoSql databases), and big data concepts.
CSI - 16 months ago