Job description

• Minimum of 6 years of work experience using Data Stage for multi-terabyte Data warehouse in the area of ETL design, implementation and deployment. • Provide end-to-end solution for both analytics ETL process and point-to-point application integration. • Ability to articulate technical specifications, business requirements and systems specifications. • Design and develop ETL jobs from function specification. • Performance tuning of ETL jobs to keep data loads within SLA. • Troubleshoot ETL processes failures or warnings and provide technical support for all. • Coordinate with offshore team and train new team members. • In-depth experience with DB2 and SQL Server database and UNIX scripting.

Requirements

Must-haves

Minimum of 6 years of work experience using Data Stage for multi-terabyte Data warehouse in the area of ETL design, implementation and deployment.
Provide end-to-end solution for both analytics ETL process and point-to-point application integration.
Ability to articulate technical specifications, business requirements and systems specifications.
Design and develop ETL jobs from function specification.
Performance tuning of ETL jobs to keep data loads within SLA.
Troubleshoot ETL processes failures or warnings and provide technical support for all.
Coordinate with offshore team and train new team members.
In-depth experience with DB2 and SQL Server database and UNIX scripting.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: smartrecruiters
Effort: medium