Associate - Data Engineer-Data Management and Analytics-Database Warehousing
Bengaluru, Karnataka, India
- Pay
- Pay not listed
- Work setting
Hybrid — work setting source
Work setup in the employer’s posting: Hybrid
From the employer’s posting- Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting
What you’ll work on
Full postingDevelop complex SQL for extraction, transformation and loading in the warehouse
Implement and maintain star and snowflake dimensional models
Write stored procedures, functions, views and triggers to automate workflows
Optimize SQL scripts and database objects for performance and data quality
Manage slowly changing dimensions to track historical data changes
From the employer’s posting
Develop complex SQL queries for data extraction, transformation, and loading (ETL) processes within the data warehouse
Implement and maintain dimensional data models (star schema, snowflake schema) using SQL
Write stored procedures, functions, views, and triggers to automate data workflows
Design and optimize SQL scripts to improve data retrieval performance and data quality
Manage Slowly Changing Dimensions (SCD) to accurately track historical data changes over time
What you’ll bring
All qualificationsCore experience
- Strong SQL: complex queries, joins, stored procedures, views, performance tuning
- 3-5 years of experience
- Solid understanding of data warehouse concepts: fact/dimension tables, SCD, schema design
- Experience with AWS data services such as Redshift, Glue, S3, Lambda and RDS/Aurora
- Bachelor's or Master's in Engineering
Qualification wording
Strong SQL skills: complex queries, joins, stored procedures, views, and performance tuning
3-5 years
Solid understanding of Data Warehouse concepts: fact/dimension tables, slowly changing dimensions (SCD), schema design
Experience with AWS data services, including but not limited to:
Bachelor's/Master's in Engineering
Education & alternatives
Assist in data collection and processing, Support data pipeline development, Document data engineering processes, Perform basic data analysis, Collaborate with senior data engineers. Bachelor's/Master's in Engineering 3-5 years
Tools in this posting
- SQL
- AWS
- Redshift
- S3
Source — Tool mentions in context
Job Summary: We are looking for a Data Warehouse Developer with strong expertise in SQL and a deep understanding of Data Warehouse (DWH) concepts. The role involves designing, developing, and optimizing SQL queries for data extraction, transformation, and reporting within large-scale data warehouse environments. The ideal candidate will translate business needs into efficient SQL queries and data models to support analytics and decision-making. Key Responsibilities:
Key Responsibilities: - Develop complex SQL queries for data extraction, transformation, and loading (ETL) processes within the data warehouse—Document SQL development standards and procedures. - Design and optimize SQL scripts to improve data retrieval performance and data quality.
- Develop complex SQL queries for data extraction, transformation, and loading (ETL) processes within the data warehouse—Document SQL development standards and procedures. - Design and optimize SQL scripts to improve data retrieval performance and data quality. - Implement and maintain dimensional data models (star schema, snowflake schema) using SQL.
- Design and optimize SQL scripts to improve data retrieval performance and data quality. - Implement and maintain dimensional data models (star schema, snowflake schema) using SQL. - Write stored procedures, functions, views, and triggers to automate data workflows.
- Write stored procedures, functions, views, and triggers to automate data workflows. - Collaborate with BI teams and business stakeholders to gather reporting requirements and translate them into SQL-based solutions. Optimize existing SQL queries and database objects for better performance. Work with large datasets to validate and ensure data accuracy and consistency. - Perform data profiling and data cleansing using SQL to ensure high-quality data in the warehouse.
- Collaborate with BI teams and business stakeholders to gather reporting requirements and translate them into SQL-based solutions. Optimize existing SQL queries and database objects for better performance. Work with large datasets to validate and ensure data accuracy and consistency. - Perform data profiling and data cleansing using SQL to ensure high-quality data in the warehouse. - Troubleshoot and debug SQL code related to data warehousing processes.
- Perform data profiling and data cleansing using SQL to ensure high-quality data in the warehouse. - Troubleshoot and debug SQL code related to data warehousing processes. - Manage Slowly Changing Dimensions (SCD) to accurately track historical data changes over time.
Must Have Skills: - Strong SQL skills: complex queries, joins, stored procedures, views, and performance tuning. - Solid understanding of Data Warehouse concepts: fact/dimension tables, slowly changing dimensions (SCD), schema design.
- Experience with ETL development and orchestration in AWS environments. - Ability to optimize data workflows and SQL queries for performance and cost-efficiency on AWS Good to Have Skills:
- Apply data governance and security best practices to protect sensitive data within the warehouse. - Use SQL extensively for data extraction, transformation, and analysis in the data warehouse Key Skills - AWS Solutions Architecture, Omnia Platform Knowledge, Vector Db, RDBMS with ANSI SQL
- Use SQL extensively for data extraction, transformation, and analysis in the data warehouse Key Skills - AWS Solutions Architecture, Omnia Platform Knowledge, Vector Db, RDBMS with ANSI SQL Assist in data collection and processing, Support data pipeline development, Document data engineering processes, Perform basic data analysis, Collaborate with senior data engineers.
- Solid understanding of Data Warehouse concepts: fact/dimension tables, slowly changing dimensions (SCD), schema design. - Experience with AWS data services, including but not limited to: - Amazon Redshift (managed data warehouse)
- Amazon Redshift (managed data warehouse) - AWS Glue (ETL service) - Amazon S3 (data lake/storage)
- Amazon S3 (data lake/storage) - AWS Lambda (serverless compute for ETL automation) - Amazon RDS/Aurora (relational databases)
- Amazon RDS/Aurora (relational databases) - Familiarity with cloud architecture and security best practices on AWS. - Experience with ETL development and orchestration in AWS environments.
- Familiarity with cloud architecture and security best practices on AWS. - Experience with ETL development and orchestration in AWS environments. - Ability to optimize data workflows and SQL queries for performance and cost-efficiency on AWS
- Experience with AWS data services, including but not limited to: - Amazon Redshift (managed data warehouse) - AWS Glue (ETL service)
- AWS Glue (ETL service) - Amazon S3 (data lake/storage) - AWS Lambda (serverless compute for ETL automation)
Posting record
Report an error- Status in our records
- Live
- First seen by us
- Aug 12, 2026 · 79 days ago
- Recorded sightings
- 332
- Last seen by us
- Oct 30, 2026
- Employer says posted
- Oct 29, 2025
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Your next step
- Have your resume and examples of relevant work ready.
- Check the listed location, eligibility and core experience before starting.
- Ask the employer about the pay range before committing time to the process.
Complete your application on fa-ewjt-saasfaprod1.fa.ocs.oraclecloud.com. The employer’s form will show what is required.
Already applied? Track this application
Job description
Job Summary:
We are looking for a Data Warehouse Developer with strong expertise in SQL and a deep understanding of Data Warehouse (DWH) concepts. The role involves designing, developing, and optimizing SQL queries for data extraction, transformation, and reporting within large-scale data warehouse environments. The ideal candidate will translate business needs into efficient SQL queries and data models to support analytics and decision-making.
Key Responsibilities:
- Develop complex SQL queries for data extraction, transformation, and loading (ETL) processes within the data warehouse—Document SQL development standards and procedures.
- Design and optimize SQL scripts to improve data retrieval performance and data quality.
- Implement and maintain dimensional data models (star schema, snowflake schema) using SQL.
- Write stored procedures, functions, views, and triggers to automate data workflows.
- Collaborate with BI teams and business stakeholders to gather reporting requirements and translate them into SQL-based solutions. Optimize existing SQL queries and database objects for better performance. Work with large datasets to validate and ensure data accuracy and consistency.
- Perform data profiling and data cleansing using SQL to ensure high-quality data in the warehouse.
- Troubleshoot and debug SQL code related to data warehousing processes.
- Manage Slowly Changing Dimensions (SCD) to accurately track historical data changes over time.
- Ensure data quality and consistency by implementing validation rules and data cleansing procedures within the data warehouse. Develop and maintain metadata and documentation for data warehouse architecture, schemas, and ETL processes.
Must Have Skills:
- Strong SQL skills: complex queries, joins, stored procedures, views, and performance tuning.
- Solid understanding of Data Warehouse concepts: fact/dimension tables, slowly changing dimensions (SCD), schema design.
- Experience with AWS data services, including but not limited to:
- Amazon Redshift (managed data warehouse)
- AWS Glue (ETL service)
- Amazon S3 (data lake/storage)
- AWS Lambda (serverless compute for ETL automation)
- Amazon RDS/Aurora (relational databases)
- Familiarity with cloud architecture and security best practices on AWS.
- Experience with ETL development and orchestration in AWS environments.
- Ability to optimize data workflows and SQL queries for performance and cost-efficiency on AWS
Good to Have Skills:
- Design and develop dimensional and normalized data models (star schema, snowflake schema) to efficiently support analytical queries.
- Understand the differences between OLTP and OLAP systems and design solutions tailored for analytical workloads. Collaborate with business analysts and data consumers to gather requirements and translate them into data warehouse design and reporting solutions.
- Apply data governance and security best practices to protect sensitive data within the warehouse.
- Use SQL extensively for data extraction, transformation, and analysis in the data warehouse
Key Skills - AWS Solutions Architecture, Omnia Platform Knowledge, Vector Db, RDBMS with ANSI SQL
Assist in data collection and processing, Support data pipeline development, Document data engineering processes, Perform basic data analysis, Collaborate with senior data engineers.
Bachelor's/Master's in Engineering 3-5 years
Source details
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
No pay amount identified in the saved description.
- Location & working pattern
Bengaluru, Karnataka, India
Working pattern and location restrictions need checking in the full posting.
- Work authorization
No clear work-authorization passage found. Eligibility is unconfirmed.
See how this role fits your experience
Add your resume to compare the role’s scope, tools and requirements with your experience.