The ETL developer/application engineer will work as part of the project team. Will be primarily responsible for implementing ETL processes using SSIS, to populate variety of source data into the Marketing database(s).The candidate will have a deep understanding of both OLTP and star schemas, with all associated ETL constructs to effectively manage facts and dimensions. The resulting ETL processes should be scalable, efficient, audited and as re-usable as possible. This role should also be able to assess data quality and auditability of the overall flow.

Primary Responsibilities

Develop, design, tune and maintain SSIS packages to perform the ETL process.

Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.

Write scripts for automated testing of data in the target facts and dimensions.

Capture audit information during all phases of the ETL process.

Write and maintain documentation of the ETL processes via process flow diagrams.

Collaborate with business users, support team members, and other developers throughout the organization to help everyone understand issues that affect the data warehouse.

Secondary Responsibilities

Design, build and deploy reports in SQL Server Reporting Services (SSRS).

Deploy reports in Native as well as share-point mode

Skills and Experience

5-6 years of experience with relational databases (Strong in SQL Server 2016).

5-6 years of experience with SSIS 2016 and SSRS 2016.

Strong communication skills.