Postgres PL/SQL Data Engineer

Tech Mahindra; Pune District, Bengaluru; Hybrid; INR 1,200,000 - 2,400,000; Full time

Job summary

Tech Mahindra in Pune, India is seeking a Data Engineer to design, develop and optimize data pipelines and database solutions. The role requires hands-on Oracle PL/SQL, PostgreSQL and Apache Spark experience, with a solid grounding in database administration concepts.

You will work with business stakeholders to deliver scalable data solutions and ensure data security and quality. The ideal candidate will have strong SQL skills, ETL/data integration know-how, and the ability to troubleshoot

Qualifications

• Experience designing and optimizing data pipelines and database solutions.
• Hands-on with Oracle PL/SQL, PostgreSQL and Spark, with basic DBA concepts.
• Strong SQL expertise and data integration knowledge.

Responsibilities

• Design, develop and optimize Oracle PL/SQL procedures, functions, packages and triggers.
• Develop and maintain data models, ETL processes and PostgreSQL solutions.
• Build large-scale data processing workflows using Apache Spark.
• Monitor database performance and apply tuning strategies.
• Support data migration, data integration and data quality initiatives.
• Collaborate with stakeholders to deliver scalable data solutions.
• Apply basic DBA knowledge for health, backups, recovery and security.
• Troubleshoot production issues and ensure data integrity.

Skills

Strong SQL

ETL

Problem solving

Analytical thinking

Communication skills

Tools

Oracle PL/SQL

PostgreSQL

Apache Spark

Python

Shell scripting

Job description

Role Summary

We are seeking a skilled and motivated Data Engineer with strong expertise in database technologies and big data processing. The ideal candidate should have hands‑on experience in Oracle PL/SQL, PostgreSQL, Apache Spark, and possess a solid understanding of database administration concepts. The role involves designing, developing, optimizing, and maintaining data pipelines and database solutions to support business‑critical applications and analytics initiatives.

Key Responsibilities

• Design, develop, and optimize complex Oracle PL/SQL procedures, functions, packages, and triggers.
• Develop and maintain data models, ETL processes, and database solutions using PostgreSQL.
• Build and optimize large‑scale data processing workflows using Apache Spark.
• Monitor database performance and implement tuning strategies for improved efficiency.
• Support database migration, data integration, and data quality initiatives.
• Collaborate with business stakeholders, architects, and development teams to understand data requirements and deliver scalable solutions.
• Apply basic DBA knowledge to manage database health, backups, recovery, user management, and performance monitoring.
• Ensure data security, integrity, and compliance with organizational standards.
• Troubleshoot production issues and provide timely resolutions.

Required Skills

• Strong experience in Oracle PL/SQL
• Hands‑on experience with PostgreSQL
• Basic Database Administration (DBA) knowledge
• Experience in Apache Spark
• Strong SQL query writing and performance tuning skills
• Understanding of ETL/Data Integration concepts

Preferred Skills

• Experience with cloud platforms such as AWS, Azure, or GCP.
• Knowledge of data warehousing concepts.
• Familiarity with Python or Shell scripting.
• Experience with data migration and performance optimization projects.

Soft Skills

• Strong analytical and problem‑solving abilities.
• Good stakeholder management and communication skills.
• Ability to work independently and within cross‑functional teams.
• Willingness to support critical incidents and production activities when required.