2921 - AWS Data Engineer

3 days ago

Gulbarga, 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

  • Senior Data Engineer

    6 days ago

    Gulbarga, India Tata Consultancy Services Full time

    Greetings from TCS TCS has been a great pioneer in feeding the fire of Techies like you. We are a global leader in the technology arena and there's nothing that can stop us from growing together. Your role is of key importance, as it lays down the foundation for the entire project. Make sure you have a valid EP number before the interview. To create an EP...

  • ▷ Apply in 3 Minutes! AI Data Architect

    1 week ago

    Gulbarga, India Tata Consultancy Services Full time

    Role:- AI Data Architect Experience- 8 to 15years Location - PAN India Job Description We are seeking an inventive Data Architect for AI with 8-15 years of experience to lead the strategic design and implementation of enterprise-scale AI solutions. 8+ years of experience in ETL/ELT, Big Data cloud data solutioning, with at least 3 years in architectural...

  • AI/ML Engineer

    1 week ago

    Gulbarga, India TransPerfect Full time

    AI/ML Engineer (Remote - Bangalore, India) Location: Bangalore, India (Remote) Contract: 5 months (with potential 12-month extension based on performance) Client: A leading multinational telecommunications company (name disclosed at interview) About the Role We're looking for an experienced AI/ML Engineer to join our advanced analytics and product innovation...

  • ▷ Immediate Start: Lead Software Engineer

    1 week ago

    Gulbarga, India Pocket FM Full time

    About Pocket FM Pocket FM is India's leading audio entertainment platform, powering a new generation of storytelling through audiobooks, audio series, and podcasts across multiple languages. With millions of monthly active users and a vast creator community, we are redefining how content is consumed in the audio-first world. Role Overview We are looking for...

  • Software Engineer Ii

    1 week ago

    Gulbarga, India Nike Full time

    SOFTWARE ENGINEER II Core Infrastructure Services Core Infrastructure Services Infrastructure Engineering Global Technology WHO WE ARE LOOKING FOR We are looking for a emerging Software Engineer with the skills to update legacy code to current programming languages while improve its capabilities develop integrated solutions and assist in the delivery of...

  • Apply in 3 Minutes: Artificial Intelligence Architect

    3 weeks ago

    Gulbarga, India Apexon Full time

    About Apexon: Apexon is a digital-first technology services firm specializing in accelerating business transformation and delivering human-centric digital experiences. We have been meeting customers wherever they are in the digital lifecycle and helping them outperform their competition through speed and innovation.Apexon brings together distinct core...

  • (Urgent Search) Welding Engineer

    1 week ago

    Gulbarga, India SATRAC Full time

    Job Purpose: Welding is responsible for overseeing all welding operations, ensuring the highest standards of safety, quality, and efficiency. This role involves strategic planning, team leadership, and continuous improvement initiatives to drive operational excellence in welding processes. Principal Accountabilities: Leadership and Management: Lead, mentor,...

  • Apply Now! Business Analyst

    3 days ago

    Gulbarga, India Superset Full time

    Job Description – Business Analyst (Dashboards & Insights) Location: Bangalore Function: Product & Engineering Reports to: Engineering Manager Type: Full-time About Superset At Superset, India’s largest university recruitment platform, we’re passionate about building software that solves real problems. We partner with leading educational institutions...

  • Principal AI Security Engineer

    2 weeks ago

    Gulbarga, India Sennovate Inc. Full time

    Position: Principal AI Security Engineer Location: Remote Experience: 4–8 years Shift: Open to night shift About Sennovate Sennovate is a global Managed Security Services Provider (MSSP) specializing in Identity and Access Management (IAM), Cybersecurity, and Cloud Security. We help enterprises build secure, scalable, and intelligent systems that enable...

  • Platform Architect

    1 week ago

    Gulbarga, India Prospecta Software Full time

    About Us: Founded in 2002 in Sydney, with offices in India and a presence across the Americas and Europe, Prospecta is a leading data management software company. Our flagship platforms: Master Data Online (MDO), enables accurate, compliant, and relevant master data for asset-intensive industries including Energy, Utilities, Oil & Gas, Mining,...