Data Integration Engineer

Data Integration Engineer

Hexaware
4-7 years
Not Specified

Job Description


Job Description
Job Description
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.
Must Have Skills*
SQL Server 2016, SSIS 2016, SSRS 2016
Nice To Have Skills*
Agile, SSAS
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 esting 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
.6-8 years of experience with relational databases (Strong in SQL Server 2016).
.6-8 years of experience with SSIS 2016 and SSRS 2016.
.Strong communication skills.

About Hexaware

Job Source : careers.hexaware.com

Similar Jobs

People Also Considered

Career Advice to Find Better

Simple body text this will replace with orginal content