ETL Database

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!