ETL Database
Ascendion · Pune · onsite · Posted 43d ago
Undisclosed4–6 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
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!
Sourced from naukri
Skills
sql queriesAws GlueInformaticaAgilePostgresqlApachecdgoogle cloud platformamazon web servicesSSISUnix ScriptingTalendOracle DBDatabricksPythonPower BiTableauMySQLSQLData WarehousingAzure Data FactorySnowflakeETLMicrosoft AzureSQL ServerGITLinuxCi/Cd
About Ascendion
Ascendion
IT Services & Consulting
3.3k+
employees
2022
4 years old
Basking Ridge, NJ
India
About
Ascendion is a leading provider of AI-first software engineering services. Our applied AI, software engineering, cloud, data, experience design, and talent transformation capabilities accelerate innovation for Global 2000 clients. Ascendion is headquartered in New Jersey. In addition to our remote/hybrid workforce, we have a presence in 12 countries and 40+ global offices across North America, Europe, and APAC. We are committed to building technology powered by Generative AI with an inclusive workforce, service to our communities, and a vibrant culture. For more information, please go to www.ascendion.com.
Industries
IT Services & Consulting
Employee ratings
799 reviews
3.2/ 5
Culture
3.2
Career growth
2.7
Work-life
3.3
Employees rate it well for
Salary80Work Life Balance52Work Culture47Senior Management40Appraisal33
Find them on