Lead Data Engineer (ETL)

Blumetra Solutions logo

Blumetra Solutions

View Salaries, Reviews, and more  

Job Description

Job Title: Lead Data Engineer

Location: Hyderabad

Experience: 10+ Years

Employment Type: Full-Time

Role Overview

We are seeking an experienced Lead Data Engineer to design, build, and lead enterprise-scale data platforms across Data Warehousing, Data Lake, Data Mesh, and Data Vault architectures. This role requires deep technical expertise combined with strong architectural vision, leadership capability, and business communication skills.

The ideal candidate will drive modern data platform initiatives, enable analytics and AI use cases, and ensure scalable, high-performance, and governed data ecosystems.

Key Responsibilities

  • Lead the design and implementation of enterprise data architectures including:
    • Data Warehousing
    • Data Lakes
    • Data Mesh
    • Data Vault modeling
  • Architect and build scalable ETL/ELT pipelines using:
    • Informatica Intelligent Data Management Cloud (IDMC)
    • Python and PySpark-based data engineering frameworks
  • Design and manage data orchestration workflows using tools like Apache Airflow
  • Develop and optimize data solutions across:
    • Oracle databases
    • Snowflake
    • Databricks
  • Drive best practices in:
    • Data modeling (Dimensional, Data Vault, Normalized models)
    • Data quality
    • Metadata management
    • Performance optimization
    • Data governance
  • Collaborate with business, analytics, and AI teams to enable:
    • BI dashboards
    • Self-service analytics
    • AI/ML and GenAI use cases
  • Provide technical leadership:
    • Conduct architecture reviews
    • Mentor junior engineers
    • Establish coding and design standards
    • Lead technical discussions and stakeholder presentations
Required Skills & ExperienceCore Technical Skills

  • Strong expertise in:
    • Data Warehousing concepts (Kimball, Inmon)
    • Data Vault 2.0 architecture
    • Modern Data Lakehouse patterns
    • Data Mesh principles
  • Hands-on experience with:
    • IDMC or similar enterprise ETL tools
    • Python & PySpark
    • Apache Airflow
    • Oracle, Snowflake, Databricks
  • Strong SQL and performance tuning capabilities
  • Experience in designing reusable, scalable data pipelines
Analytics & AI Exposure

  • Familiarity with BI tools (Power BI, Tableau, etc.)
  • Working knowledge of AI/ML pipelines
  • Exposure to Generative AI integration within data platforms is a plus

Soft Skills

  • Excellent communication and presentation skills
  • Ability to explain complex data architectures to business stakeholders
  • Strong problem-solving mindset
  • Experience leading data engineering teams

Preferred Qualifications

  • Experience in BFSI, Healthcare, or regulated industries
  • Cloud certifications (AWS/Azure/GCP)
  • Snowflake or Databricks certifications
  • Exposure to Data Governance tools

Skills: datawarehousing,snowflake,data,idmc

Interview Questions of Lead Data Engineer (ETL) at Blumetra Solutions

Currently, there aren't any interview questions for this role at Blumetra Solutions shared by other job seekers.
View more interview questions of similar roles from other companies โ†’
banner icon
Prepare For Your Interview in 1 Week?
Equip yourself with possible questions that interviewers might ask you, based on your work experience and job description.
Get Started!

Salary Insights of Lead Data Engineer (ETL) at Blumetra Solutions

Currently, there aren't any salaries for this role at Blumetra Solutions shared by other job seekers.

View more salaries from Blumetra Solutions โ†’

Achieve your dream job with our top-notch tools!

Resume Checker Illustration

Resume Checker

Our free resume checker analyzes the job description and identifies important keywords and skills missing from your resume in just a minute!

Check Now
Interview Preparation Illustration

AI InterviewPrep

Utilizing advanced AI, our tool generates tailored interview questions based on your industry, role, and experience. Practice and receive feedback on your answers in real time!

Check Now
Resume Builder Illustration

Resume Builder

Let us show you the differences between a bad, good, and great resume, and guide you in building a resume that helps you stand out to employers, ensuring you land your next position faster!

Check Now