Redshift DWH Lead

19 hours ago


Pune, Maharashtra, India ADI Group Full time ₹ 15,00,000 - ₹ 25,00,000 per year


Designation: Redshift DWH Lead : 6 to 10 Years
Office Days 3 days (Flexible)
Location Gurgaon, Pune , Bangalore, Chennai , Hyderbad

Role and responsibilities

  • The Lead Data Engineer will design and implement data solutions that support the organizations strategic business goals.
  • Focuses on database design, performance optimization, and ETL pipeline.
  • Redshift design review processes and resolved technical problems.
  • Tests, monitors, manage and validate data warehouse activity including data extraction.
  • Hands-on experience in writing AWS Glue, EMR, Python, and Spark jobs.
  • Participate in design, code, test plans, and dataset implementation performed by other data engineers in support of maintaining data engineering standards.
  • Implement automated workflows and routines using workflow scheduling tools to ensure compliance with technical processes and standards.
  • Identify, communicate, and mitigate Risks, Assumptions, Issues, and Decisions throughout full lifecycle.

Technical skills requirements

  • The candidate must demonstrate proficiency in,
  • Experience in Design, build and configure AWS Redshift DWH to meet business process and application
  • requirements.
  • At least one/two Redshift design end-to-end implementations with long-term project association.
  • Experience in Redshift design review processes and resolved technical problems.
  • Experience in query tuning and optimization, designing Sort and Distribution keys.
  • Experience in processing design optimal queries to aggregate data and build reports or data feeds for downstream sources.
  • Experience in serving Redshift Data to other sources.
  • Having strong SQL skills, data types, and AWS ecosystem components.
  • Experience working on large-scale, distributed systems
  • Exposure to various ETL and Business Intelligence tools
  • Solid grounding in Agile methodologies
  • Experience with git and other source control systems
  • Strong communication and presentation skills

Nice-to-have skills

  • AWS Cloud certification
  • Python, Scala, Spark scripting
  • Strong delivery background across the delivery of high-value, business-facing technical projects in major organizations

Qualifications

B.Tech./M.Tech. or BCA/MCA degree from a reputed university




  • Pune, Maharashtra, India Coforge Full time ₹ 1,00,00,000 - ₹ 2,00,00,000 per year

    AWS Redshift Developer We are hiring AWS Redshift Developer Shift Timings: 2:00 PM – 11:00 PM IST Experience Required: 8 to 10 Years Availability: Immediate joiners preferred Key Skills: AWS Redshift, SQL, ETL & Data Warehousing. Responsibilities:Design and develop high-performance ETL pipelines using Redshift and AWS services. ...

  • Data Engineer Lead

    3 weeks ago


    Pune, Maharashtra, India, Maharashtra Calfus Inc. Full time

    About the role:As a Data Engineer – BI Analytics & DWH, you will play a pivotal role in designing and implementing comprehensive business intelligence solutions that empower our organization to make data-driven decisions. You will leverage your expertise in Power BI, Tableau, and ETL processes to create scalable architectures and interactive...


  • Pune, Maharashtra, India Calfus Inc. Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    About Us:At Calfus, we are known for delivering cutting-edge AI agents and products that transform businesses in ways previously unimaginable. We empower companies to harness the full potential of AI, unlocking opportunities they never imagined possible before the AI era. Our software engineering teams are highly valued by customers, whether start-ups or...

  • Technology Lead

    1 week ago


    Pune, Maharashtra, India Bitwise Solutions Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Technology Lead ETL & Data Engineering (Fandango)Location: Pune / HybridExperience: 10 to 15 YearsEmployment Type: Full-TimeJob SummaryWe are seeking a highly skilled and experienced Technology Lead with 10+ years of expertise in ETL, Data Warehousing, and AWS cloud services. The ideal candidate should have strong hands-on experience with Talend (Data...

  • Tech Lead

    3 days ago


    Pune, Maharashtra, India Growel Softech Pvt. Ltd. Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Payments "12+ Years Hands on Techno Functional lead; Handled a team of 5 to 10 Members; Should have Customer Focused Exposure; Should have complete Design & Development/Testing Experience; Should cover the following in Specific: Funds Transfer(FT), FTM, Standing order(STO) Interfaces related to Payments " Finance "12+ Years Hands on Techno Functional lead;...

  • Data Engineer

    3 days ago


    Pune, Maharashtra, India Vastika Inc Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Experience : 4-7 YearsKey Responsibilities:● Design, develop, and maintain data pipelines and ETL tool ( Informatica ) workflows using GCP-native tools and services.● Build and optimize data warehouses using BigQuery or other DWHs (e.g., Snowflake on GCP, Redshift on GCP).● Write complex and efficient SQL queries for data transformation, analysis, and...


  • Pune, Maharashtra, India Mastercard Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Overview:The MasterCard B&MI Technology development team is engaged in working with new and innovative technologies to build business solutions that keep Mastercard positioned as a leader in delivering value added business analytic and reporting solutions to our diverse customer base. We work collaboratively with our product partners and other technical...

  • Lead Data Engineer

    1 week ago


    Pune, Maharashtra, India Rudder Analytics Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Design and lead scalable, secure data architectures and pipelines across cloud and hybrid setups. Implement DataOps/DevOps, guide teams, ensure automation, quality, and timely delivery while translating business needs into technical solutions. Required Candidate profileProficient in Python, PySpark, SQL, and ETL tools like Airflow, dbt, and Talend....


  • Pune, Maharashtra, India Codvo Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    Job Title: Data & Databricks Practice Lead Location: Remote About UsAt Codvo, we are committed to building scalable, future-ready data platforms that power business impact. We believe in a culture of innovation, collaboration, and growth, where engineers can experiment, learn, and thrive. Join us to be part of a team that solves complex data challenges with...

  • Data Engineer Lead

    7 days ago


    Pune, Maharashtra, India Mappy Global Resources Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Greetings for the DayScouting for a Director, Data Engineering Lead to be associated with a Global Digital Media Agency.Location: PuneShift: EMEARole & responsibilitiesDirector, Data Engineering Lead, you will drive the architecture, design, and implementation of enterprise-scale data platforms and pipelines. You will lead a high-performing team of data...