- 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.
- 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.
Skills Required
- Bachelor's or Master's degree in CS, engineering, operations research or related analytics field
- 3-5 years of QA experience
- Proficient in SQL (queries, subqueries, complex joins, stored procedures)
- Experience with ETL projects and SQL Server Integration Services (SSIS)
- Strong understanding of Data Warehouse concepts (dimensions, facts, SCD)
- Experience extracting and manipulating data from relational databases
- Strong experience in functional testing and test automation
- Ability to create and execute test artifacts (test strategy, test cases, defect logs, status reports)
- Ability to write nonfunctional and negative test cases
- Ability to test data ingestion/curation pipelines and BI/ETL runs
- Excellent written and verbal communication skills
- Insurance industry knowledge
What We Do
Choosing a digital partner is about more than capabilities — it’s about collaboration and character. Unrealistic overhauls and off-the-shelf products ignore what matters most — your unique needs, culture, goals, and your legacy data and technology environments. At EXL, our collaboration is built on ongoing listening and learning to adapt our methodologies. We’re your business evolution partner—tailoring solutions that make the most of data to make better business decisions and drive more intelligence into your increasingly digital operations. Whether your goals are scaling the use of AI and digital, redesign operating models, or driving better and faster decisions, we’re here to partner with you to help you gain—and maintain—competitive advantage with efficient, sustainable models at scale. Our expertise in transformation, data science, and change management helps make your business more efficient and effective, improve customer relationships and enhance revenue growth. Instead of focusing on multi-year, resource- and time-intensive platform designs or migrations, we look deeper at your entire value chain to integrate strategies with impact. We use our specialization in analytics, digital interventions, and operations management—alongside deep industry expertise — to deliver solutions that help you outperform the competition. At EXL, it’s all about outcomes—your outcomes—and delivering success on your terms. Share your goals with us and together, we’ll optimize how you leverage data to drive your business forward. For more information, visit www.exlservice.com.
