EXL

Analyzes business data and runs outsourced operations

Quality Assurance

Manual & Functional QAConfirmed live in the last 24 hours

Full-timeGurugram, Haryana, IndiaNo salary listedIn-person

About the Job

Requirements

A Bachelor's or Master's degree in computer science, engineering, operations research, or related analytics areas; BA/BS degrees in the same fields from top-tier academic institutions are also accepted.
Three to five years of quality assurance experience.
Strong experience in functional testing and test automation.
Proficiency in SQL queries, subqueries, complex joins, and generating stored procedures.
Experience working on ETL projects and with ETL technologies such as SQL Server Integration Services (SSIS).
Understanding of data warehouse concepts, including dimensions and fact tables, slowly changing dimensions (SCD), online analytical processing (OLAP), and online transaction processing (OLTP).
Experience extracting and manipulating data from relational databases using advanced SQL.
Ability to test data ingestion and curation pipelines.
Experience creating test artifacts, including test strategies, test cases, defect logs, and status reports.
Ability to write nonfunctional and negative test cases.
Ability to work with clients across the globe and understand cross-cultural differences.

Responsibilities

Oversee quality assurance, including establishing and reporting metrics, applying industry best practices, and developing tools and processes to meet quality goals.
Ensure the Data & BI Implementation team follows formal QA processes and industry-accepted best practices.
Ensure data accuracy in SQL and SSIS, document tested features and identified bugs, and identify stale or erroneous calculations and performance optimization needs.
Serve as the key contact for release QA, providing testing services and coordinating QA resources internally and externally.
Create and provide feedback on manual and automated test cases, scripts, plans, and procedures, and execute them.
Support testing across the Data/BI solution development lifecycle, including unit, regression, functional, system, stress and scale, smoke, and sanity testing.
Break down processes and test scenarios at every step.
Diagnose defects and track them from discovery through resolution.
Ensure testing follows the testing plan, schedule, and quality requirements.
Collaborate with the data warehouse architect, ETL lead, and BI developers to construct and execute test scenarios for development, test, and production data warehouse environments.
Perform BI user experience testing and BI and ETL runs, and maintain quality monitoring dashboards and reports.
Use metrics and closed-loop feedback to improve software deliverables and the predictability and reliability of releases.

Desired Qualifications

Knowledge of the insurance industry.

Oversee all aspects of quality assurance including establishing and reporting on metrics, applying industry best practices and developing new tools and processes to ensure quality goals are met.
Adhere to formal QA processes, ensuring that the Data & BI Implementation team is using Industry accepted best Practices.
Ensure data accuracy in both SQL and SSIS. Detailed and effective written communication skills documenting the features tested and bugs found.
Document necessity of performance optimization, identify the stale & error calculations.
Act as key point of contact for all QA aspects of releases, providing test services and coordinating QA resources internally and externally in SQL.
Create and Provide Feedback on test cases, scripts, plans and Procedures (manual and automated) responsible for executing them.
The entire Data/BI solution development life cycle and test cycles (unit, Regression, Functional, Systems, stress& scale, smoke and sanity)
Strong experience in functional testing and test automation.
Process breakdown & testing the different scenarios at every step.
Diagnose defects and track them from discovery to resolution.
Ensure all testing work is carried out in accordance with the testing plan, Including schedule and quality requirement.
Collaborates with data warehouse architect, the ETL lead and BI developers in the construction and execution of test scenarios including those applicable to the development, test and production data warehouse environment.
Perform necessary BI UX testing, BI run, ETL runs, maintain quality monitoring dashboard/report etc.

Bachelor’s/Master's degree in computer science/engineering, operations research or related analytics areas; candidates with BA/BS degrees in the same fields from the top tier academic institutions are also welcome to apply
Insurance Industry knowledge preferred.
Proficient in SQL queries, sub queries, and complex joins for generating stored procedures.
Experience working in ETL projects and ETL technologies like SQL Server Integration Services (SSIS).
Good Understanding of Data Warehouse concepts such as Dimensions and Facts tables, SCD, OLAP, OLTP etc.
Experience extracting and manipulating data from relational databases with advanced SQL.
3-5 years of QA experience.
Able to test the data ingestion/curation pipelines.
Experience with the test artifacts (test strategy, test cases, defect logs, status report)
Able to write nonfunctional and negative test cases.
Outstanding written and verbal communication skills
Able to work in fast pace continuously evolving environment and ready to take up uphill challenges.
Able to understand cross cultural differences and can work with clients across the globe.
Self-Motivated, works well independently and with others.
Using metrics-driven approach and closed loop feedback to improve software deliverables and improve predictability and reliability of releases.

Oversee all aspects of quality assurance including establishing and reporting on metrics, applying industry best practices and developing new tools and processes to ensure quality goals are met.
Adhere to formal QA processes, ensuring that the Data & BI Implementation team is using Industry accepted best Practices.
Ensure data accuracy in both SQL and SSIS. Detailed and effective written communication skills documenting the features tested and bugs found.
Document necessity of performance optimization, identify the stale & error calculations.
Act as key point of contact for all QA aspects of releases, providing test services and coordinating QA resources internally and externally in SQL.
Create and Provide Feedback on test cases, scripts, plans and Procedures (manual and automated) responsible for executing them.
The entire Data/BI solution development life cycle and test cycles (unit, Regression, Functional, Systems, stress& scale, smoke and sanity)
Strong experience in functional testing and test automation.
Process breakdown & testing the different scenarios at every step.
Diagnose defects and track them from discovery to resolution.
Ensure all testing work is carried out in accordance with the testing plan, Including schedule and quality requirement.
Collaborates with data warehouse architect, the ETL lead and BI developers in the construction and execution of test scenarios including those applicable to the development, test and production data warehouse environment.
Perform necessary BI UX testing, BI run, ETL runs, maintain quality monitoring dashboard/report etc.

About the Company

EXL

Analyzes business data and runs outsourced operations

EXL analyzes business data and runs outsourced operations for insurers, healthcare payers, banks, retailers, and other large organizations. Its teams combine industry expertise with data engineering and AI to handle tasks such as claims processing, payment reviews, customer service, and finance within existing technology environments. The company also builds software, including LifePRO, which manages insurance policies, and EXLdata.ai, which connects fragmented data for use in AI systems. Clients pay for consulting projects, ongoing managed services, and software delivered through the cloud. EXL was founded in 1999 and is headquartered in New York City.

Company size: 10,001+
Company stage: IPO
Headquarters: New York City, New York
Founded: 1999

Recently Posted Jobs

Explore more opportunities at EXL

See more jobs