Lead Data Architect/Lead Data Engineer

Tech Mahindra Limited; Hyderabad, Chennai, Bengaluru; Hybrid; INR 2,500,000 - 4,500,000; Full time

Job summary

Tech Mahindra in India, Hyderabad seeks an experienced Data Engineer / Data Architect with expertise in Informatica, Snowflake, Oracle SQL/PLSQL, and PySpark to design, develop, and optimize enterprise data solutions.

The role focuses on data modeling, ETL/ELT development, data warehousing, and cloud-based data platforms, with collaboration across stakeholders to deliver high-quality data assets.

Qualifications

• 7+ years of experience in data engineering or architecture.
• Hands-on with Informatica IICS/IDMC, Snowflake, Oracle SQL/PLSQL, PySpark.
• Experience in data modeling, warehousing, and ETL/ELT development.
• Strong problem-solving and communication skills.

Responsibilities

• Design and implement enterprise data architectures and scalable data models.
• Develop and maintain ETL/ELT solutions using Informatica (IICS/IDMC preferred).
• Build, optimize, and support data pipelines using Snowflake and PySpark.
• Perform data analysis, validation, troubleshooting, and performance tuning.
• Develop complex SQL queries, stored procedures, and integrations using Oracle SQL/PLSQL.
• Design and implement data warehousing solutions to support business reporting and analytics.
• Collaborate with business stakeholders, architects, and technical teams to deliver high-quality data solutions.
• Ensure data quality, governance, and adherence to best practices across data platforms.

Skills

Data engineering

Data architecture

ETL/ELT development

SQL performance tuning

Stakeholder communication

Tools

Informatica (IICS/IDMC)

Snowflake

Oracle SQL/PLSQL

PySpark

Job description

Dear Applicants,

Position Overview:-

We are seeking an experienced Data Engineer / Data Architect with strong expertise in Informatica, Snowflake, Oracle SQL/PLSQL, and PySpark to design, develop, and optimize enterprise data solutions. The ideal candidate will have extensive experience in data architecture, data modeling, ETL/ELT development, and cloud-based data platforms.

Key Responsibilities

• Design and implement enterprise data architectures and scalable data models.
• Develop, enhance, and maintain ETL/ELT solutions using Informatica (IICS/IDMC preferred).
• Build, optimize, and support data pipelines using Snowflake and PySpark.
• Perform data analysis, validation, troubleshooting, and performance tuning.
• Develop complex SQL queries, stored procedures, and integrations using Oracle SQL/PLSQL.
• Design and implement data warehousing solutions to support business reporting and analytics.
• Collaborate with business stakeholders, architects, and technical teams to deliver high-quality data solutions.
• Ensure data quality, governance, and adherence to best practices across data platforms.

Required Skills & Experience

• 7+ years of experience in Data Engineering, Data Architecture, or related roles.
• Strong hands-on experience with:
• Informatica (IICS/IDMC)
• Snowflake
• Oracle SQL/PLSQL
• PySpark
• Experience in data modeling, data warehousing, and ETL/ELT development.
• Strong understanding of database design, data integration, and performance optimization.
• Excellent analytical, troubleshooting, and problem-solving skills.
• Strong communication and stakeholder management abilities.

Preferred Qualifications

• Experience with Azure or AWS cloud platforms.
• Exposure to BI and reporting tools such as Power BI or Tableau.
• Snowflake and/or Informatica certifications.
• Experience working in Agile delivery environments.