Skip to content

Senior ETL Developer

Beyond KeyHyderabad, India; Indore, India; Mumbai, India; Pune, IndiaOn-Site

Estimated salary, not published by the employer: Est. ₹12–18 LPA

Needs a free Superjobs account. You'll finish on Beyond Key's site.

Skill score

Summary

The Senior ETL Developer III designs source system and data mart models, builds ETL workflows and complex transformations, and tunes SQL across Snowflake and Oracle for an enterprise data warehouse. This suits a database developer with 5 to 9 years of experience who enjoys dimensional modeling, troubleshooting and working with business users.

Function
Development
Estimated salary
Est. ₹12–18 LPA
Estimated for a senior role, ~5 yrs experience, India. Not published by the employer.
Work mode and location
On-Site, Hyderabad, India; Indore, India; Mumbai, India; Pune, India
Experience
5–9 yrs

Job description

Overview

We are looking for a skilled ETL Developer III to support enterprise data warehouse and data mart development initiatives. The successful candidate will be responsible for designing source system and data mart models, implementing ETL workflows, developing complex transformation logic, and maintaining reliable data integration processes using Snowflake, Oracle, SQL, and PL/SQL.

The candidate should bring strong database development and troubleshooting capabilities, a solid understanding of dimensional modeling, and the ability to deliver quality solutions while working with business users and cross-functional teams.

Roles and responsibilities

  • Data Warehouse Design: Design and implement data mart models, source system models, and data warehouse structures.
  • ETL Development & Maintenance: Develop, enhance, and maintain ETL code and data integration workflows.
  • Transformation Logic: Implement complex data transformation logic using PL/SQL and SQL.
  • Snowflake & Oracle Development: Build and maintain database solutions across Snowflake and Oracle environments.
  • Data Modeling: Develop dimensional models and implement STAR schema designs.
  • SQL Performance Tuning: Diagnose performance bottlenecks and optimize SQL queries and database processes.
  • Technical Troubleshooting: Investigate and resolve data processing and database-related issues.
  • Stakeholder Collaboration: Understand business requirements and coordinate with technical teams and business users to deliver appropriate solutions.
  • Technical Documentation: Document data models, transformation rules, ETL workflows, and technical implementation details.
  • Delivery Ownership: Manage assigned deliverables independently and ensure timely completion with appropriate quality.

Skills required

Top skills

  • Snowflake
  • Oracle
  • SQL
  • PL/SQL

All skills (8)

  • ETL development
  • Data warehousing
  • Dimensional modeling
  • STAR schema
  • SQL performance tuning
  • Datastage
  • Agile
  • SSIS

Qualifications

Skills (Must Have)

  • 5–9 years of experience in ETL development, database development, or data warehousing.
  • Hands-on expertise in Snowflake and Oracle.
  • Strong SQL and PL/SQL development skills.
  • Experience in data mart design, source system modeling, and data warehouse development.
  • Knowledge of dimensional modeling and STAR schema design.
  • Experience implementing ETL processes and complex data transformations.
  • Strong SQL performance tuning and troubleshooting capabilities.
  • Ability to analyze requirements and translate them into technical solutions.

Professional Skills

  • Strong analytical and problem-solving abilities.
  • Excellent written and verbal communication skills.
  • Ability to work independently and handle multiple tasks in parallel.
  • Flexibility to adapt to changing technical and business requirements.
  • Strong collaboration skills and attention to detail.

Education

  • BE/BS or MS in Computer Science or an equivalent qualification.

Nice to have

  • Experience with Datastage ETL tools.
  • Familiarity with Agile development environments.
  • Exposure to macOS, iOS, and Browser-Dealer environments.
  • Snowflake, Oracle, Strong SQL, PL/SQL, SSIS, Control-M.

Company info

We are an international IT consulting and software services firm committed to providing. Cutting-edge services and products that satisfy our clients' global needs. Our company was established in 2005, and since then we've expanded our team by including more than 350+ Talented skilled software professionals. Our clients come from the

More jobs at Beyond Key