Description

You will transform technical specifications into data warehouse, database, and business intelligence solutions. You own the full lifecycle of ETL development, from design to deployment and optimization.

Responsibilities

• Transform technical specifications into data warehouse and business intelligence solutions.
• Perform detailed data analysis to determine the structure, content, and quality of source system data.
• Develop, test, and review code for queries, scripts, stored procedures, database objects, indices, and triggers.
• Optimize SQL performance by interpreting execution plans and remediating query bottlenecks.
• Create use cases and support UAT testing efforts for developed solutions.

Required Skills

• Mandatory expertise in Oracle, SQL, and PL/SQL.
• Proficiency in Python scripting for file processing and database connections.
• Experience with Unix/Shell scripting.
• Knowledge of T-SQL and MS SQL.
• Experience with AutoSys.
• Experience with Oracle Warehouse Builder and Data Integrator.
• Strong understanding of ETL design, development, and data quality implementation.
• Solid grasp of SDLC processes and data warehouse concepts.
• Ability to work the afternoon shift.

Preferred Skills

• Experience interacting with onshore stakeholders and teams.

Key Skills

Education

Any graduate