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.
- Robust 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.

📌 Lead Data Architect/Lead Data Engineer (Bengaluru)
🏢 Tech Mahindra
📍 Bengaluru