Data Quality Engineer

2 weeks ago

Chennai, India NexionPro Services Full time

Data Quality Engineer (Role)

Exp: - 3 - 11 Yrs.

Job Location: Chennai/Pune

WFO—3 days from client location

Notice Period: Immediate to 15 days

Work Timing: Normal Shift (9 am to 6 pm)


Ready to work as DQE.

Share the resume with Deepikanexionpro.com/rupali@nexionpro.com.

1. Python/Java Coding (any programming language) - Must have

2. Advanced SQL (Mandatory) - Must have

3. Knowledge of BDD (Selenium, Cucumber) - Good to have (Training can be provided)

4. Working knowledge of CI/CD is good to have (training can be provided).

5. Hands-on Functional Testing Experience - Good to have (Training can be provided)

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.

  • Chief Data Science Engineer

    4 weeks ago

    Chennai, Tamil Nadu, India NTT DATA Full time

    Job SummaryWe are seeking an experienced Chief Data Science Engineer to join our team at NTT DATA. As a key member of our organization, you will be responsible for designing and implementing machine learning systems, researching and developing ML algorithms and tools, and selecting appropriate data sets.About the RoleYou will work closely with...

  • Data Quality Engineer

    4 weeks ago

    Chennai, Tamil Nadu, India Mphasis Full time

    Mphasis is seeking a Data Quality Engineer to join our team.Estimated salary: $120,000 - $180,000 per year.Job Description:We are looking for an experienced Data Quality Engineer who can develop test cases, test suites, and execute test plans to ensure the quality of data and data-driven applications.The ideal candidate will design, build, and maintain...

  • Senior Data Engineer

    2 months ago

    chennai, India Wavicle Data Solutions Full time

    We are seeking an experienced Senior AWS Data Engineer to join our team. The ideal candidate will have a strong background in designing, building, and maintaining scalable data pipelines and solutions on AWS. You will work closely with data scientists, analysts, and cross-functional teams to optimize and manage our data infrastructure. This role requires a...

  • Senior Data Engineer

    1 month ago

    Chennai, India Wavicle Data Solutions Full time

    We are seeking an experienced Senior AWS Data Engineer to join our team. The ideal candidate will have a strong background in designing, building, and maintaining scalable data pipelines and solutions on AWS. You will work closely with data scientists, analysts, and cross-functional teams to optimize and manage our data infrastructure. This role requires a...

  • Senior Data Engineer

    2 months ago

    Chennai, India Wavicle Data Solutions Full time

    We are seeking an experienced Senior AWS Data Engineer to join our team. The ideal candidate will have a strong background in designing, building, and maintaining scalable data pipelines and solutions on AWS. You will work closely with data scientists, analysts, and cross-functional teams to optimize and manage our data infrastructure. This role requires a...

  • Senior Data Engineer

    2 months ago

    Chennai, India Wavicle Data Solutions Full time

    We are seeking an experienced Senior AWS Data Engineer to join our team. The ideal candidate will have a strong background in designing, building, and maintaining scalable data pipelines and solutions on AWS. You will work closely with data scientists, analysts, and cross-functional teams to optimize and manage our data infrastructure. This role requires a...

  • Senior Data Engineer

    2 months ago

    chennai, India Wavicle Data Solutions Full time

    We are seeking an experienced Senior AWS Data Engineer to join our team. The ideal candidate will have a strong background in designing, building, and maintaining scalable data pipelines and solutions on AWS. You will work closely with data scientists, analysts, and cross-functional teams to optimize and manage our data infrastructure. This role requires a...

  • Senior Data Engineer

    2 months ago

    Chennai, India Wavicle Data Solutions Full time

    We are seeking an experienced Senior AWS Data Engineer to join our team. The ideal candidate will have a strong background in designing, building, and maintaining scalable data pipelines and solutions on AWS. You will work closely with data scientists, analysts, and cross-functional teams to optimize and manage our data infrastructure. This role requires a...

  • Data Quality Engineer

    6 days ago

    Chennai, Tamil Nadu, India NexionPro Services Full time

    NexionPro Services: Data Quality EngineerAre you a skilled professional looking to take your data quality expertise to the next level? Do you have experience with programming languages, database operations, and testing methodologies? We are seeking an experienced Data Quality Engineer to join our team at NexionPro Services in Chennai/Pune.About the Role:Job...

  • Crayon Data | Senior Software Engineer | chennai

    4 weeks ago

    chennai, India Crayon Data Full time

    Role: Senior Software Engineer – Backend Experience level: 5+ years Location: Hybrid Who are we? ​ Crayon Data is a leading provider of AI-led revenue acceleration solutions, headquartered in Singapore with a local presence in India and the UAE. The company was founded in 2012 with the vision of simplifying the world’s choices. Our flagship...

  • Crayon Data | Senior Software Engineer | chennai

    4 weeks ago

    chennai, India Crayon Data Full time

    Role: Senior Software Engineer – BackendExperience level: 5+ yearsLocation: HybridWho are we?​Crayon Data is a leading provider of AI-led revenue acceleration solutions, headquartered in Singapore with a local presence in India and the UAE. The company was founded in 2012 with the vision of simplifying the world’s choices. Our flagship platform,...

  • Crayon Data | Senior Software Engineer | chennai

    4 weeks ago

    chennai, India Crayon Data Full time

    Role: Senior Software Engineer – Backend Experience level: 5+ years Location: Hybrid Who are we? ​ Crayon Data is a leading provider of AI-led revenue acceleration solutions, headquartered in Singapore with a local presence in India and the UAE. The company was founded in 2012 with the vision of simplifying the world’s choices. Our flagship...

  • Senior Data Engineer

    1 month ago

    Chennai, Tamil Nadu, India Wavicle Data Solutions Full time

    We are seeking an Experienced AWS Data Architect with a strong background in designing, building, and maintaining scalable data pipelines and solutions on AWS. The ideal candidate will have a deep understanding of AWS services, data engineering best practices, and cloud architecture.Key Responsibilities:Design, develop, and maintain robust ETL pipelines on...

  • Cybersecurity Engineer for NTT DATA

    4 weeks ago

    Chennai, Tamil Nadu, India NTT DATA Full time

    Company OverviewNTT DATA is a $30+ billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long-term success.We invest over $3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the...

  • Senior Machine Learning Engineer

    1 week ago

    Chennai, Tamil Nadu, India Crayon Data Full time

    We are seeking a highly skilled Senior Machine Learning Engineer to join our team in Chennai. This is a fantastic opportunity to work on large scale data solutions using machine learning, operation research and pattern searching methods.About Crayon DataCrayon Data is a leading provider of AI-led revenue acceleration solutions, headquartered in Singapore...

  • Engineer (L1) - Titus Data Classification

    1 month ago

    Chennai, India NTT DATA Full time

    Job Description Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion – it’s a place where you can grow, belong and thrive.Your day at NTT...

  • Data Quality Engineer

    1 week ago

    Chennai, Tamil Nadu, India NexionPro Services Full time

    About the RoleNexionPro Services is seeking a highly skilled Data Quality Engineer to join our team in Chennai/Pune. As a key member of our organization, you will play a vital role in ensuring the accuracy and reliability of our data.Job DescriptionWe are looking for an experienced Data Quality Engineer with a strong background in advanced SQL topics. The...

  • Data Quality Engineer

    2 weeks ago

    Chennai, India NexionPro Services Full time

    Data Quality Engineer (Role)Exp: - 3 - 11 Yrs.Job Location: Chennai/PuneWFO—3 days from client locationNotice Period: Immediate to 15 daysWork Timing: Normal Shift (9 am to 6 pm)Ready to work as DQE.Share the resume with Deepikanexionpro.com/ 1. Python/Java Coding (any programming language) - Must have2. Advanced SQL (Mandatory) - Must have3. Knowledge of...

  • Data quality engineer

    2 weeks ago

    Chennai, India NexionPro Services Full time

    Data Quality Engineer (Role) Exp: - 3 - 11 Yrs.Job Location: Chennai/PuneWFO—3 days from client locationNotice Period: Immediate to 15 daysWork Timing: Normal Shift (9 am to 6 pm)Ready to work as DQE.Share the resume with Deepikanexionpro.com/ 1. Python/Java Coding (any programming language) - Must have2. Advanced SQL (Mandatory) - Must have3. Knowledge...

  • Data Science Strategist

    3 weeks ago

    Chennai, Tamil Nadu, India NTT DATA Services Full time

    Job SummaryWe are seeking an experienced Data Science Strategist to join our team at NTT DATA Services.About the RoleThe ideal candidate will have a strong background in designing and implementing machine learning systems, as well as researching and developing new algorithms and tools. The successful candidate will be responsible for selecting appropriate...