Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

For Employers

Add office photos

Engaged Employer

Mphasis

Compare

3.3

based on 8.9k Reviews

Video summary

127 Mphasis Jobs

Senior Test Engineer - Automation

Mphasis Limited

3.3

based on 8.9k Reviews

4-6 years

₹ 6.4 - 18.5L/yr (AmbitionBox estimate)

Chennai

1 vacancy

Senior Test Engineer - Automation

Mphasis

posted 26d ago

Job Role Insights

Flexible timing

Key skills for the job

Manual Testing Data Analysis Python SQL Analytical Chemistry Windows System Administration

+ 3 more

Job Description

C 1. Experience in Python /Java programming required to automate data analysis tasks - Must have

2. Experience in writing Advance SQL queries (Topics listed below) - Must have

3. Knowledge of BDD and Cucumber - Good to have

4. Knowledge of Agile methodologies, CI/CD etc. - Good to have

5. Hands on Functional Data / ETL Testing Experience - Good to have

Advanced SQL topics delve into more complex database operations and query optimization techniques. Here are some key areas to explore:

Window Functions

RANK, DENSE_RANK, ROW_NUMBER: Assign a rank to each row within a partition.

LEAD, LAG: Access rows preceding or following the current row within a partition.

PARTITION BY, ORDER BY: Define partitions and the order within each partition.

Window frames: Specify the range of rows included in a window function calculation.

Common Table Expressions (CTEs)

Recursive CTEs: Create recursive queries to process hierarchical data.

Multiple CTEs: Use multiple CTEs to break down complex queries into smaller, more manageable parts.

Subqueries

Correlated subqueries: Subqueries that reference columns from the outer query.

Scalar subqueries: Subqueries that return a single value.

EXISTS and NOT EXISTS: Test for the existence or non-existence of rows in a subquery.

Analytical Functions

CUME_DIST: Calculate the cumulative distribution of a value within a group.

PERCENT_RANK: Calculate the percentile rank of a value within a group.

NTILE: Divide a result set into a specified number of groups.

Full-Text Search

Full-text indexes: Create indexes that support full-text search capabilities.

Ranking functions: Rank search results based on relevance.

Stop words: Exclude common words from search queries.

Hierarchical Queries

CONNECT BY PRIOR: Traverse hierarchical relationships in a table.

START WITH: Specify the starting point for a hierarchical query.

Optimization Techniques

Indexes: Create appropriate indexes to improve query performance.

Query tuning: Analyze query execution plans and optimize queries.

Materialized views: Pre-calculate and store query results for faster access.

Employment Type: Full Time, Permanent

Read full job description

What people at Mphasis are saying

3.6

Rating based on 67 Senior Test Engineer reviews

Anonymous · Engineering - Software & QA in Bangalore / Bengaluru

Likes

Learning and work life balance

Skill development - Good

+4 more

Dislikes

No appraisal and promotions

Salary - Poor

+1 more

Read 67 Senior Test Engineer reviews

Senior Test Engineer salary at Mphasis

reported by 811 employees with 4-10 years exp.

₹6.3 L/yr - ₹22.6 L/yr

28% more than the average Senior Test Engineer Salary in India

View more details

What Mphasis employees are saying about work life

based on 8.9k employees

66%

82%

68%

63%

Flexible timing

Monday to Friday

No travel

Day Shift

View more insights

Compare Mphasis with

Cognizant

3.7

Compare

Wipro

3.7

Compare

Accenture

3.8

Compare

TCS

3.6

Compare

Infosys

3.6

Compare

LTIMindtree

3.7

Compare

DXC Technology

3.7

Compare

EXL Service

3.7

Compare

Sutherland Global Services

3.5

Compare

Optum Global Solutions

4.0

Compare

Hexaware Technologies

3.5

Compare

L&T Technology Services

3.3

Compare

eClerx

3.3

Compare

Virtusa Consulting Services

3.7

Compare

Coforge

3.3

Compare

CGI Group

4.0

Compare

GlobalLogic

3.6

Compare

Bosch Global Software Technologies

3.9

Compare

Cyient

3.7

Compare

UST

3.8

Compare

Similar Jobs for you

Senior Data Analyst at GreyOrange

Gurgaon / Gurugram

4-5 Yrs

₹ 5-9 LPA

Senior Automation Test Engineer at Oracle India Pvt. Ltd.

Bangalore / Bengaluru

3-5 Yrs

₹ 10-14 LPA

Automation Test Engineer at Tata Consultancy Services

Hyderabad / Secunderabad

4-9 Yrs

₹ 10-18 LPA

Data Engineer at Zensar Technologies

Hyderabad / Secunderabad

5-10 Yrs

₹ 13-14 LPA

Automation Test Engineer at Persistent Systems Limited

Bangalore / Bengaluru

4-8 Yrs

₹ 6-11 LPA

Automation Test Engineer at Persistent Systems Limited

Hyderabad / Secunderabad

4-8 Yrs

₹ 6-11 LPA

Automation Test Engineer at Persistent Systems Limited

Pune

4-8 Yrs

₹ 6-11 LPA

Data Engineer at Turing

Remote

6-8 Yrs

₹ 8-10 LPA

Senior Engineer at BA Continuum India Pvt. Ltd.

Chennai

4-7 Yrs

₹ 9-13 LPA

Selenium Automation Test Engineer at Infosys Limited

Noida

3-5 Yrs

₹ 4-9 LPA

Mphasis Chennai Office Locations

View all

Chennai (2)

Chennai Office

Mphasis Limited DLF SEZ IT Park, Block 8, 4th, 8th, 9th and 10th Floor, 1/124, Shivaji Garden, Moonlight Stop, Mount Poonamalle Road, Chennai Chennai
600089

Chennai Office

Mphasis Limited DLF SEZ IT Park, Tower 1B, Level 1-5, 1/124, Shivaji Garden, Manapakkam, Mount Poonamalle Road, Chennai Chennai
600089