BENGALURU · FULLTIME
Data/ETL Engineer
Ascendion
Bengaluru · onsite · Posted 68d ago
About a minute. You'll make an account on the way through.
agent · working
- Read this posting0.6s
- Found the form on Foundit · 9 questions to answer1.1s
- Decided the answers for all of them2.4s
- Tailor your résumé to this role
- Waiting for you
Section · 01
About this role
Position Overview
We are looking for an experienced ETL / Data Warehousing Developer with strong expertise in SQL, SSIS, ETL development, and data warehouse solutions. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining data integration pipelines and scalable data warehouse solutions.
The candidate should have strong hands-on experience working with complex data sets, developing ETL workflows, writing optimized SQL queries, and supporting enterprise data integration and reporting requirements.
Key Responsibilities
- Design, develop, and maintain robust ETL processes to extract, transform, and load data from multiple source systems.
- Develop and manage SSIS packages for enterprise-scale data integration and migration.
- Write complex and optimized SQL queries, stored procedures, functions, and views.
- Design and implement data warehouse solutions, including dimensional models, fact tables, dimension tables, and ETL workflows.
- Perform data cleansing, transformation, validation, and reconciliation to ensure data quality and accuracy.
- Analyze existing data pipelines and identify opportunities for performance optimization and automation.
- Troubleshoot and resolve ETL, SQL, data integration, and production data issues.
- Work with business analysts, data engineers, architects, and reporting teams to understand data requirements and translate them into technical solutions.
- Develop processes to support incremental data loads, historical data management, and data synchronization.
- Monitor ETL jobs and ensure successful execution of scheduled data loads.
- Participate in data migration and integration initiatives across multiple systems.
- Create and maintain technical documentation related to ETL processes, data mappings, workflows, and data warehouse structures.
- Strong hands-on experience with ETL development.
- Strong expertise in Microsoft SSIS (SQL Server Integration Services).
- Advanced proficiency in SQL and Microsoft SQL Server.
- Strong understanding of Data Warehousing concepts and architecture.
- Experience with dimensional data modeling, including Star and Snowflake schemas.
- Knowledge of Fact and Dimension tables, slowly changing dimensions (SCD), and incremental data loading.
- Strong understanding of data extraction, transformation, cleansing, and loading processes.
- Experience troubleshooting and optimizing ETL workflows and SQL queries.
- Strong analytical and problem-solving skills.
- Experience working with large-scale enterprise data environments.
- Exposure to SQL Server Integration Services, SQL Server Agent, and related Microsoft data technologies.
- Experience with data migration and system integration projects.
- Familiarity with BI/reporting environments such as Power BI or SSRS is a plus.
- Experience working in Agile/Scrum development environments.
- Strong communication and collaboration skills.
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
- 5+ years of experience in ETL/Data Engineering/Data Warehousing, with strong hands-on experience in SSIS and SQL.
- Demonstrated experience delivering enterprise-level data integration and data warehouse solutions.
Sourced from foundit
Section · 02
Skills
Section · Company
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
Employee ratings
799 reviews
Culture
3.2
Career growth
2.7
Work-life
3.3
Employees rate it well for
Find them on