ETL Database

Ascendion; Maharashtra; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

Ascendion is seeking a DevOps Engineer to design, develop, and maintain ETL/ELT pipelines for extracting, transforming, and loading data in Pune. The role emphasizes advanced SQL, data warehousing concepts, and collaboration with analysts and BI developers.

The candidate should have strong ETL tools experience (Informatica/SSIS/Talend) and cloud familiarity across AWS/Azure/GCP, plus Git and Agile practices. Join a high-impact team delivering data-driven outcomes.

Qualifications

• Strong SQL skills with advanced techniques and optimization.
• Hands-on experience with ETL/ELT tools and data warehousing.
• Experience with multiple RDBMS (SQL Server, Oracle, PostgreSQL/MySQL).
• Experience in SDLC, Agile, and production support.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines for extracting, transforming, and loading data.
• Develop complex SQL queries, stored procedures, functions, and views.
• Work with relational databases and optimize queries for performance.
• Build data integration workflows from multiple sources into data warehouses.
• Monitor ETL jobs, troubleshoot failures, and resolve data-quality issues.
• Implement incremental loads, CDC, error handling, and restart/recovery mechanisms.
• Collaborate with data analysts, BI developers, application teams, and business stakeholders.
• Maintain technical documentation for ETL processes, mappings, and data flows.

Skills

SQL Advanced

Joins Subqueries CTEs

Window functions

Stored procedures functions

Query optimization

ETL/ELT

Data Warehousing

Dimension/Fact tables

Star/Snowflake schema

SCD

Execution plans

Index optimization

Partitioning

Data Quality & reconciliation

Source-to-target mapping

Git

SDLC & Agile

Production support

Tools

Informatica

SSIS

Talend

Azure Data Factory

AWS Glue

Databricks

Snowflake

Power BI

Tableau

CI/CD

Apache Airflow

Linux/Unix scripting

Git

Job description

About Ascendion

Ascendion is a leader in AI-Native platform driven software engineering company that underwrites outcomes, helping businesses innovate faster, smarter, and with greater impact. We partner with Global 2000 clients across North America, UK, Europe, and APAC to solve complex challenges in data, experience design, software product engineering, and workforce transformation. Powered by expert engineers, thousands of AI agents, and our Engineering to the Power of AI™ (EngineeringAI) method, we deliver measurable outcomes that build trust, unlock value, and accelerate growth. Learn more at ascendion.com

About Ascendion

Ascendion is a leader in AI-Native platform driven software engineering company that underwrites outcomes, helping businesses innovate faster, smarter, and with greater impact. We partner with Global 2000 clients across North America, UK, Europe, and APAC to solve complex challenges in data, experience design, software product engineering, and workforce transformation. Powered by expert engineers, thousands of AI agents, and our Engineering to the Power of AI™ (EngineeringAI) method, we deliver measurable outcomes that build trust, unlock value, and accelerate growth. Learn more at ascendion.com

Ascendion | Engineering to elevate life

We have a culture built on opportunity, inclusion, and a spirit of partnership. Come, change the world with us:

• Build the coolest tech for world's leading brands
• Solve complex problems – and learn new skills
• Experience the power of transforming digital engineering for Fortune 500 clients
• Master your craft with leading training programs and hands-on experience

Experience a community of change makers! Join a culture of high-performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion.

About The Role

We are looking for a DevOps Engineer to join our team. In this role, you will design, develop, and maintain ETL/ELT pipelines for extracting, transforming, and loading data.

Job Title: ETL Database

Key Responsibilities

• Design, develop, and maintain ETL/ELT pipelines for extracting, transforming, and loading data.
• Develop complex SQL queries, stored procedures, functions, and views.
• Work with relational databases and optimize queries for performance.
• Build data integration workflows from multiple source systems into data warehouses.
• Monitor ETL jobs, troubleshoot failures, and resolve data-quality issues.
• Implement incremental loads, CDC, error handling, and restart/recovery mechanisms.
• Collaborate with data analysts, BI developers, application teams, and business stakeholders.
• Maintain technical documentation for ETL processes, mappings, and data flows.

Minimum Qualifications

• Perform data cleansing, validation, transformation, and reconciliation.
• Required Skills
• SQL — Advanced
• Joins, subqueries, CTEs
• Window functions
• Stored procedures/functions
• Query optimization and indexing
• ETL Tools
• Informatica / SSIS / Talend / Azure Data Factory / AWS Glue — depending on the project
• Databases
• SQL Server
• Oracle
• PostgreSQL or MySQL
• Data Warehousing
• Fact and dimension tables
• Star/snowflake schema
• Slowly Changing Dimensions (SCD)
• ETL/ELT architecture
• Performance Tuning
• Execution plans
• Index optimization
• Partitioning
• Large-volume data processing
• Data Quality
• Validation and reconciliation
• Duplicate handling
• Null/error handling
• Source-to-target mapping
• Version Control: Git
• Good understanding of SDLC, Agile, and production support.
• Good-to-Have Skills
• Python
• Cloud platforms: AWS / Azure / GCP
• Databricks / Snowflake
• Power BI or Tableau
• CI/CD
• Apache Airflow
• Linux/Unix scripting

Location: Pune

Want to change the world? Let us know. Tell us about your experiences, education, and ambitions. Bring your knowledge, unique viewpoint, and creativity to the table. Let's talk!