Job #: 2106-66
Title: SQL Server/SSIS ETL Developer – Whitehouse Station
Job Type: Contract to Hire
Region: Central New Jersey
Salary Range: $100,000 to $125,000
Contract Pay Rate: 60-75/hr
Function: Data Warehousing
Specialty: SQL Server
Degree: Bachelors
Job Details:
· Communicate and collaborate with internal and external customers
· Analyze/create source to target mapping and technical specifications for incorporation into development work
· Design and develop SSIS ETL packages to load Data Marts in Microsoft Azure environment
· Monitor/support production ETL process
· Coordinate ETL development activities of consultants
· Additional duties assigned as needed
· Bachelor’s degree (or equivalent) in CS, IT or related field
· 5-8 years of SSIS development experience
· Expertise with Microsoft SQL Server current and past versions to 2008
· Expertise in developing complex SQL queries, stored procedures and functions
· Expertise with SQL, query tuning and optimization
· Current experience working with Microsoft on-premise, IaaS, PaaS, SaaS and Hybrid environment projects
· Experience with Tableau and MS BI reporting stack
· Strong knowledge of data warehousing concepts and dimensional data modeling
· Ability to work in an agile environment
· Excellent written and oral communication skills, ability to articulate and document processes and workflows
· Coordinate ETL development activities of junior developers/consultants
· Ability to work independently as well as collaboratively