Sr.Software engineer-Snowflake Oracle

Tech Mahindra Limited; Hyderabad, Chennai, Bengaluru; Hybrid; INR 1,200,000 - 2,400,000; Full time

Job summary

Tech Mahindra is seeking a Data Engineer with 5-6 years of hands-on experience to design, build, and optimize scalable data pipelines. You will work with Snowflake, PySpark, SQL, and Oracle in a data warehousing environment to enable data-driven decision making.

The role requires strong analytical skills, data profiling and validation capabilities, and collaboration with analysts and architects to meet data requirements across enterprise analytics initiatives.

Qualifications

• 5-6 years of experience in Data Engineering or Data Warehousing.
• Strong hands-on experience with Snowflake, Oracle SQL/PLSQL, PySpark, SQL.
• Experience in Data Analysis, Data Profiling, and Data Validation.
• Strong understanding of ETL/ELT concepts and data integration methodologies.
• Experience with Data Warehousing concepts, dimensional modeling, and performance tuning.
• Excellent communication and stakeholder management skills.

Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake, PySpark, and Oracle.
• Perform ETL/ELT processes for data extraction, transformation, and loading from multiple sources.
• Analyze, profile, validate, and troubleshoot data to ensure high data quality and integrity.
• Develop and optimize SQL queries, stored procedures, and database objects for performance and efficiency.
• Collaborate with business analysts, architects, and cross-functional teams to understand data requirements.
• Support data warehousing, reporting, analytics, and business intelligence initiatives.
• Monitor and enhance data pipeline performance, reliability, and scalability.
• Implement best practices for data governance, security, and documentation.

Skills

Data Engineering

Data Warehousing

Snowflake

Oracle SQL

PL/SQL

PySpark

SQL

Data Analysis

Data Profiling

Data Validation

ETL/ELT

Azure

AWS

GCP

Python

Data Orchestration Tools

Snowflake Certification

Tools

Snowflake

Oracle SQL/PLSQL

PySpark

SQL

Job description

Dear Applicants,

Greetings from Tech Mahindra!

We are seeking a skilled Data Engineer with 5-6 years of experience in designing, developing, and supporting enterprise data integration and analytics solutions. The ideal candidate should have strong hands-on expertise in Snowflake, Oracle, PySpark, SQL, and Data Warehousing, with experience in building scalable data pipelines and enabling data-driven decision-making.

Role: Data Engineer

Experience: 5-6 Years

Location: PAN India

Notice Period: Immediate

Key Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake, PySpark, and Oracle.
• Perform ETL/ELT processes for data extraction, transformation, and loading from multiple sources.
• Analyze, profile, validate, and troubleshoot data to ensure high data quality and integrity.
• Develop and optimize SQL queries, stored procedures, and database objects for performance and efficiency.
• Collaborate with business analysts, architects, and cross-functional teams to understand data requirements.
• Support data warehousing, reporting, analytics, and business intelligence initiatives.
• Monitor and enhance data pipeline performance, reliability, and scalability.
• Implement best practices for data governance, security, and documentation.

Required Skills

• 5-6 years of experience in Data Engineering or Data Warehousing.
• Strong hands-on experience with:
  • Snowflake
  • Oracle SQL / PLSQL
  • PySpark
  • SQL
• Experience in Data Analysis, Data Profiling, and Data Validation.
• Strong understanding of ETL/ELT concepts and data integration methodologies.
• Experience with Data Warehousing concepts, dimensional modeling, and performance tuning.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and stakeholder management skills.

Preferred Skills

• Experience with cloud platforms such as Azure, AWS, or GCP.
• Knowledge of Python and data orchestration tools.
• Experience working with enterprise reporting and analytics solutions.
• Snowflake Certification is an added advantage.