Job Description

Description

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 a 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 reusable as possible.

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 documentat...

    • Ready to Apply?

    Take the next step in your AI career. Submit your application to Hexaware Technologies today.

    Submit Application