Senior ETL Developer

Knoldus; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Knoldus is seeking an ETL Developer III to support enterprise data warehouse initiatives. You will design source systems and data marts, implement ETL workflows, and develop complex transformations using Snowflake, Oracle, SQL and PL/SQL.

You will collaborate with business users and cross-functional teams, optimize queries, document data models, and ensure reliable data integration with quality and delivery ownership.

Qualifications

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

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

ETL Development

Snowflake

Oracle

SQL

PL/SQL

Data Warehousing

STAR Schema

Performance Tuning

Education

BE/BS or MS in CS

Tools

Datastage ETL tools

SSIS

Control-M

Job description

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.

Key Skills:

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