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

📌 Data Analyst/Sr.Software Engineer (Bengaluru)
🏢 Tech Mahindra
📍 Bengaluru