Senior ETL Developer

Beyond Key; Mumbai; On-site; INR 1,500,000 - 2,100,000; Full time

Job summary

Beyond Key in Mumbai is seeking an experienced ETL Developer III to design data warehouse and data mart models, and to implement robust ETL workflows using Snowflake and Oracle. You will translate business requirements into scalable data integrations.

The role demands strong SQL/PLSQL skills, dimensional modeling, and collaboration with cross-functional teams to deliver reliable data solutions for global clients.

Qualifications

• 5-9 years of experience in ETL development, data warehousing, or related roles.
• Hands-on expertise with Snowflake and Oracle.
• Strong SQL and PL/SQL development skills.
• Experience in data mart design and dimensional modeling.
• Familiarity with STAR schema and ETL processes.

Responsibilities

• Design data warehouse and data mart models.
• Develop, optimize, and maintain ETL workflows.
• Implement complex data transformations with SQL/PLSQL.
• Collaborate with business users and cross-functional teams.
• Document data models, rules, workflows, and implementations.

Skills

ETL development

Data warehousing

SQL

PL/SQL

Dimensional modeling

STAR schema

Data mart design

Analytical skills

Communication skills

Education

BE/BS or MS in Computer Science or equivalent

Tools

Snowflake

Oracle

SSIS

Control-M

Datastage ETL tools

Job description

About Beyond Key

We are a Microsoft Solution Partner and a Great Place to Work-certified company. "Happy Team Members, Happy Clients" is a principle we hold dear. 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 United States, Canada, Europe, Australia, the Middle East, and India, and we create and design IT solutions for them. If you need any more details, you can get them at https://www.beyondkey.com/

Role 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.

Key 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.

Qualifications & Skills Technical

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.

Preferred Skills

• Experience with Datastage ETL tools.
• Familiarity with Agile development environments.
• Exposure to macOS, iOS, and Browser-Dealer environments.

Key Skills

• Snowflake, Oracle, Strong SQL, PL/SQL, SSIS, Control-M.