Data Integration Engineer Job in Hexaware Technologies Ltd

Data Integration Engineer

Chennai, Tamil Nadu
Not Disclosed
Full-time
Permanent

Apply Now

Save Job

Job Summary 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.

Experience Required :

4 to 7 Years

Vacancy :

2 - 4 Hires