Description

You will lead enterprise data warehouse ETL development and provide technical architecture for data loads and reporting.

This role is remote.

Responsibilities

• Design, code, test, and debug data warehouse ETL and reporting code following security and compliance standards.
• Translate business requirements into technical solutions and oversee application architecture integrity.
• Document ETL logic, workflow processing, and technical requirements for business and technical stakeholders.
• Manage multiple assignments within waterfall and agile methodologies throughout the systems development lifecycle.
• Participate in a 24x7 on-call rotation to support daily data loads and maintain reporting SLAs.

Required Skills

• 12-15 years of Enterprise Data Warehouse ETL development experience.
• 10 years of Informatica PowerCenter development.
• 10 years of SQL proficiency with Oracle and/or Teradata databases.
• 10 years of experience with dimensional data marts and OLTP databases.
• 10 years of experience in data analysis, research, and validation.
• 5 years of experience designing, developing, and maintaining IBM/ Tivoli Workload Scheduler (IWS).
• Proficiency in UNIX and UNIX shell scripting.
• Experience working within virtual teams with minimal direction.
• Strong ability to document ETL logic and manage release processes.

Preferred Skills

• 5 years of experience as a SAS Base programmer and DI developer.
• Experience with CI/CD using Jenkins, Git, and shell scripting.
• Knowledge of Oracle PL/SQL and SQL tuning using explain plans.

Key Skills

Education

ANY GRADUATE