2921 - AWS Data Engineer

16 hours ago

Bengaluru, India EXL Full time

Job Title – Data Warehouse Developer Exp – 3-5 Years 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

  • 2921 - AWS Data Engineer

    2 weeks ago

    Bengaluru, India EXL Full time

    Job Title – Data Warehouse Developer Exp – 3-5 Years 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...

  • 2921 - AWS Data Engineer

    2 weeks ago

    Bengaluru, India EXL Full time

    Job Title – Data Warehouse Developer Exp – 3-5 Years 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...

  • 2921 - AWS Data Engineer

    2 weeks ago

    Bengaluru, India EXL Full time

    Job Title – Data Warehouse DeveloperExp – 3-5 Years 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...

  • 2921 - AWS Data Engineer

    2 weeks ago

    Bengaluru, India EXL Full time

    Job Title – Data Warehouse DeveloperExp – 3-5 Years 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...

  • 2921 - AWS Data Engineer

    3 weeks ago

    Bengaluru, India EXL Full time

    Job Title – Data Warehouse DeveloperExp – 3-5 YearsJob 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...

  • ▷ [15h Left] 2921 - AWS Data Engineer

    4 days ago

    Bengaluru, India EXL Full time

    Job Title – Data Warehouse DeveloperExp – 3-5 YearsJob 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...

  • Data Engineer

    1 week ago

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

    Migrate ETL workflows from SAP BODS to AWS Glue/dbt/Talend. Develop and maintain scalable ETL pipelines in AWS. Write PySpark scripts for large-scale data processing. Optimize SQL queries and transformations for AWS PostgreSQL. Work with Cloud Engineers to ensure smooth deployment and performance tuning. Integrate data pipelines with existing Unix systems....

  • Aptus Data Labs

    4 days ago

    Bengaluru, India Aptus Data Labs Full time

    Job Title : Enterprise Data Architect (AWS)Experience : 12+ yearsLocation : BangaloreEmployment Type : Full-timeNotice : Prefer with shorter notice or can join within 30 daysAbout the Role :We are seeking a seasoned Enterprise Data Architect with over 12+ years of experience in designing, implementing, and optimizing enterprise data platforms.The ideal...

  • Data Scientist

    3 days ago

    Bengaluru, India AWS ProServe IN - Karnataka Full time

    A Bachelor or Masters Degree in a highly quantitative field (Computer Science, Machine Learning, Operational Research, Statistics, Mathematics, etc.) or equivalent experience - 6+ years of industry experience in predictive modeling, data science and analysis - Previous experience in a ML or data scientist role and a track record of building ML or DL models -...

  • AWS Data Engineer

    1 week ago

    Bengaluru, India Pradeepit Consulting Services Full time

    Job Description As an AWS Data Engineer, you will be responsible for designing, building, and maintaining data pipelines and data storage solutions on Amazon Web Services (AWS). Your expertise will help us leverage data for critical business insights and analytics. Primary Skills: - Experience in implementing at least 2 end-to-end Data Engineering projects....