Data Analyst/Sr.Software Engineer

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

Job summary

Tech Mahindra is seeking a Data Analyst to support Oracle-to-Snowflake migration and data modernization initiatives in a Hyderabad area context. You will perform data profiling, source-to-target mapping, data validation, and requirements gathering to ensure data quality and successful migrations.

The role requires 2–5 years of experience, strong SQL skills, and collaboration with data engineers, architects, and stakeholders. The position is office-based across Chennai, Bengaluru, and Hyderabad.

Qualifications

• 4-6 years of experience as a Data Analyst in Data Warehouse, Data Migration, or Data Modernization projects.
• Hands-on with Oracle SQL/PLSQL, Snowflake SQL, Data Profiling, Data Validation & Reconciliation, and STTM.
• Experience in Oracle-to-Snowflake migration projects.
• Strong understanding of Data Warehousing Concepts, Dimensional Modeling, ETL/ELT, and Data Quality Frameworks.
• Experience gathering and translating business requirements into technical specifications.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and stakeholder management abilities.

Responsibilities

• Perform source-to-target mapping (STTM), data profiling, and gap analysis.
• Analyze source systems and document business and technical requirements.
• Develop complex SQL queries for data analysis, reconciliation, validation, and reporting.
• Support Oracle-to-Snowflake migration and data modernization initiatives.
• Collaborate with Data Engineers, Data Architects, Product Owners, and business stakeholders.
• Conduct data validation, reconciliation, and root cause analysis to ensure data quality.
• Create and maintain business requirement documents, functional specifications, and mapping documents.
• Support SIT, UAT, and Production validation activities.
• Identify data quality issues and provide recommendations for resolution.
• Participate in Agile ceremonies and work closely with cross-functional teams.

Skills

Oracle SQL/PLSQL

Snowflake SQL

Data Profiling

Data Validation & Reconciliation

Source-to-Target Mapping

Data Warehousing Concepts

Dimensional Modeling

ETL/ELT Processes

Data Quality Frameworks

Analytical Thinking

Stakeholder Management

Communication

Job description

Dear Applicants:-

Greetings from Tech Mahindra!!

Position Title

Data Analyst

Experience

2-5 Years

Notice Period:-Immediate

Location Chennai,Bengaluru & Hyderabad

Job Summary

We are looking for a highly motivated Data Analyst with expertise in Oracle SQL/PLSQL, Snowflake, Data Warehousing, and Data Modernization Projects. The ideal candidate will play a key role in Oracle-to-Snowflake migration initiatives by performing data analysis, source-to-target mapping, data validation, and business requirement gathering. The candidate will work closely with business users, data engineers, and architects to ensure successful migration and modernization of enterprise data platforms.

Key Responsibilities

• Perform source-to-target mapping (STTM), data profiling, and gap analysis.
• Analyze source systems and document business and technical requirements.
• Develop complex SQL queries for data analysis, reconciliation, validation, and reporting.
• Support Oracle-to-Snowflake migration and data modernization initiatives.
• Collaborate with Data Engineers, Data Architects, Product Owners, and business stakeholders.
• Conduct data validation, reconciliation, and root cause analysis to ensure data quality.
• Create and maintain business requirement documents, functional specifications, and mapping documents.
• Support SIT, UAT, and Production validation activities.
• Identify data quality issues and provide recommendations for resolution.
• Participate in Agile ceremonies and work closely with cross-functional teams.

Required Skills & Qualifications:-

• 4-6 years of experience as a Data Analyst in Data Warehouse, Data Migration, or Data Modernization projects.
• Strong hands-on experience with:
  • Oracle SQL/PLSQL
  • Snowflake SQL
  • Data Profiling
  • Data Validation & Reconciliation
  • Source-to-Target Mapping (STTM)
• Experience in Oracle-to-Snowflake migration projects.
• Strong understanding of:
  • Data Warehousing Concepts
  • Dimensional Modeling
  • ETL/ELT Processes
  • Data Quality Frameworks
• Experience gathering and translating business requirements into technical specifications.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and stakeholder management abilities.

Preferred Skills:-

• Experience with Azure or AWS cloud platforms.
• Exposure to Power BI, Tableau, or other reporting and visualization tools.
• Experience working in Agile/Scrum environments.
• Snowflake Certification is an added advantage.
• Knowledge of data governance and metadata management concepts.