QA Lead

Work Location  : United States
Work Mode      : Remote
Pay Range       :$110K-$130K /Yr Base + Annual Bonus

The posted range is the hiring range for this role — a subset of the broader range available to employees over time — and reflects base salary across our national hiring scale. Final offers are based on several factors, including the candidate's skills and experience, internal pay equity, work location, market conditions for the role, and the specific scope and responsibilities of the position. The top of the range is reserved for candidates who notably exceed the requirements; the lower end applies to those with less experience or fewer preferred qualifications. For positions based in higher-cost zones (e.g., California, New York, New Jersey), actual compensation may exceed the posted range; your recruiter will share specifics during the process

For more information on benefits and what we offer please visit us at https://www.exlservice.com/us-careers-and-benefits
 

Role and Responsibilities Overview:

• 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 Systems Implementation (SI) 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.
• Database testing
  • Database design – Normalization, Administration, Security
  • ETL testing
  • Master Data Management
  • Reference Data management
  • Knowledge of different type of Keys in Database Management
  • Working knowledge of any of these databases DB2, Oracle, SQL Server etc.
• Extensive experience in writing test cases, test Scenarios, defect reporting
• Proficient in test planning, Quality Assurance, defect tracking
• Proficient in Analyzing bugs and interacting with development teams
• 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 software 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 the the SI maintains High quality and accuracy up to software release.
• 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.
• Able to lead & mentor offshore team members ( 4 – 5)

Candidate Profile

• 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.
• 5-8 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. 

What we offer: 

• EXL Analytics offers an exciting, fast paced and innovative environment, which brings together a group of sharp and entrepreneurial professionals who are eager to influence business decisions. From your very first day, you get an opportunity to work closely with highly experienced, world class analytics consultants.
• You can expect to learn many aspects of businesses that our clients engage in. You will also learn effective teamwork and time-management skills - key aspects for personal and professional growth 
• We provide guidance/ coaching to every employee through our mentoring program wherein every junior level employee is assigned a senior level professional as advisors.
• Sky is the limit for our team members. The unique experiences gathered at EXL Analytics sets the stage for further growth and development in our company and beyond.

Role and Responsibilities Overview:

• 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 Systems Implementation (SI) 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.
• Database testing
  • Database design – Normalization, Administration, Security
  • ETL testing
  • Master Data Management
  • Reference Data management
  • Knowledge of different type of Keys in Database Management
  • Working knowledge of any of these databases DB2, Oracle, SQL Server etc.
• Extensive experience in writing test cases, test Scenarios, defect reporting
• Proficient in test planning, Quality Assurance, defect tracking
• Proficient in Analyzing bugs and interacting with development teams
• 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 software 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 the the SI maintains High quality and accuracy up to software release.
• 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.
• Able to lead & mentor offshore team members ( 4 – 5)

• 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