Home
Jobs
Mphasis logo

Sr Test Engineer - Automation

0 years

0 Lacs

Chennai Tamil Nadu India

Posted:1 week ago| Platform: Linkedin logo

Apply

Skills Required

test automation data python programming automate analysis writing sql agile etl testing database query optimization calculation subquery indexes support ranking connect tuning analyze

Work Mode

On-site

Job Type

Full Time

Job Description

Current JD – Data Quality Engineer (Role). Ready to work as DQE. Location – Pune/Chennai Experience in Python /Java programming required to automate data analysis tasks - Must have Experience in writing Advance SQL queries (Topics listed below) - Must have Knowledge of BDD and Cucumber - Good to have Knowledge of Agile methodologies, CI/CD etc. - Good to have 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. Show more Show less

More Jobs at Mphasis

Junior Operations Analyst support in India

Chennai, Bengaluru, Hyderabad

2 - 4 yrs
|

INR 0 - 3 Lacs

Mphasis Hiring For Accounts Payable (Canada Process) - Pune Location

Pune

Experience: Not specified

|

INR 1 - 5 Lacs

Operations Analyst

Bengaluru

2 - 4 yrs
|

INR 2 - 5 Lacs

Urgent opening For JR |Junior Operations Analyst

Chennai, Bengaluru, Hyderabad

1 - 2 yrs
|

INR 1 - 5 Lacs

Customer Support Officer

Bengaluru

Experience: Not specified

|

INR 3 - 4 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Test Interview Now

My Connections Mphasis

Download Chrome Extension (See your connection in the Mphasis )

chrome image
Download Now
Mphasis
Mphasis
www.mphasis.com

Information Technology and Services

Grapevine

around 30,000 Employees

294 Jobs

    Key People

  • Nitin Rakesh

    CEO

  • Sandeep Kumar

    Chief Financial Officer

RecommendedJobs for You

Mphasis logo

Sr Test Engineer - Automation

Mphasis

Chennai, Tamil Nadu, India

Mphasis logo

Sr Test Engineer - Automation

Mphasis

Chennai, Tamil Nadu, India

Mphasis logo

Sr Test Engineer - Automation

Mphasis

Pune

Mphasis logo

Sr Test Engineer - Automation

Mphasis

Chennai, Tamil Nadu, India