Description

You will lead ETL development and data warehousing design for medium to large-scale environments.

Responsibilities

• Design and develop parallel jobs using DataStage 11.0 or above.
• Build and maintain data marts and data warehouses using dimensional modelling in RDBMS.
• Perform SQL development including triggers, stored procedures, and views.
• Tune SQL performance by interpreting execution plans and remediating query bottlenecks.
• Redesign existing data models to meet evolving business requirements.

Required Skills

• 10+ years of experience in Data Warehousing and BI development.
• Expertise in DataStage ETL and parallel job development.
• Advanced Oracle SQL skills and experience with TOAD or SQL Developer.
• Strong knowledge of data modelling, data mapping, and RDBMS principles.
• Proven ability to handle data migration from diverse data sources.
• Experience working within Agile methodologies using JIRA, Bamboo, GIT, or Confluence.
• Ability to work independently with minimal supervision.

Preferred Skills

• Exposure to Python, Spark, or Java.
• Experience with DevOps practices.

Key Skills

Education

Any Graduate