Associate - Data Engineer-Data Management and Analytics-Database Warehousing

1 week ago

Bengaluru, Karnataka, India EXL Full time ₹ 12,00,000 - ₹ 36,00,000 per year
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

Responsibilities

Assist in data collection and processing, Support data pipeline development, Document data engineering processes, Perform basic data analysis, Collaborate with senior data engineers.

Qualifications

Bachelor's/Master's in Engineering 3-5 years

  • Technical Lead- Data Engineer

    2 weeks ago

    Bengaluru, Karnataka, India Astar Data Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Kindly find the Job Description Below.Job Title:Technical Lead- Data EngineerLocation: BangaloreYears of Experience: 8+ years of experienceSigmoidworks with a variety of clients from start-ups to fortune 500 companies. We are looking for a detailed oriented self-starter to assist our engineering and analytics teams in various roles as a Software...

  • Data Engineer/Data Warehousing

    5 days ago

    Bengaluru, Karnataka, India Datamatics Full time

    Would it be possible to also share one or two additional profiles with more extensive experience in Data Warehousing / Data Engineering on SQL Server?Our ETL scripts are developed in both R and Python, and we aim with your support to standardize these processes while further enhancing our Data Model, including adding indexes and enhancing data quality...

  • Data Engineer

    1 day ago

    Bengaluru, Karnataka, India NTT DATA Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    As a Data Engineer, your main responsibilities will involve: The project is a migration of a SAS code to DBT code, so it's important that the candidate has experience in this type of projects. Analyze data models and derive logical conclusions. Processes modeling. Hands on development and monitoring of the Azure cloud Platform and various associated...

  • Associate Analytics Manager

    1 day ago

    Bengaluru, Karnataka, India Zen Data Shastra Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Role & Responsibilities:Team & Delivery LeadershipLead and mentor a cross-functional team of developers, data analysts, and AI engineers.Manage the full analytics delivery lifecycle - from requirement definition and data design to solution deployment and insight communication.Ensure alignment between business needs, data capabilities, and technical...

  • Senior Associate Data Scientist

    2 weeks ago

    Bengaluru, Karnataka, India NTT DATA Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion – it's a place where you can grow, belong and thrive.Your day at NTT DATAThe Senior...

  • Data Engineer

    1 week ago

    Bengaluru, Karnataka, India Excellence and Eminence LLP Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    We are looking for Data Engineer with 4 - 5 Years of Experience for our esteemed client for Bangalore Location. Key Skills: SQL script, ITSM, Data modelling, Data warehousing, Snowflake cloud, Data integration, P1/P2/P3/P4. This is an immediate requirement. Please apply if you can join within 20 days or close to 20 days. Roles and Responsibilities:Ability to...

  • Data engineering manager

    1 week ago

    Bengaluru, Karnataka, India Careernet Technologies Full time ₹ 20,00,000 - ₹ 40,00,000 per year

    Data Engineering Stack:  Analytics: Python / R / SQL + Excel / PPT, Google Colab  Database: PostgreSQL, Amazon Redshift, DynamoDB, Aerospike  Warehouse: Redshift, S3  ETL: Airflow + DBT + Custom-made Python + Amundsen (Discovery)  Business Intelligence / Visualization: Metabase + Google Data Studio  Frameworks: Spark + Dash + StreamLit ...

  • Data Senior Engineer

    1 week ago

    Bengaluru, Karnataka, India NTT DATA Global Delivery Services Ltd Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Data Senior Engineer Req ID: 337668 NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a Data Senior Engineer to join our team in Bangalore, Karnātaka (IN-KA), India (IN). Job...

  • Data Engineer

    2 weeks ago

    Bengaluru, Karnataka, India Factspan Analytics Full time ₹ 8,00,000 - ₹ 24,00,000 per year

    Factspan Overview: Factspan is a pure play data and analytics services organization. We partner with fortune 500 enterprises to build an analytics center of excellence, generating insights and solutions from raw data to solve business challenges, make strategic recommendations and implement new processes that help them succeed. With offices in Seattle,...

  • AWS Sr Data Engineer

    2 weeks ago

    Bengaluru, Karnataka, India NTT DATA Full time ₹ 10,00,000 - ₹ 25,00,000 per year

    Req ID: NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now. We are currently seeking a AWS Sr Data Engineer to join our team in Bangalore or Remote, Karnātaka (IN-KA), India (IN). Position Location:OUS with...