Note: The job is a remote job and is open to candidates in USA. CEI.AI is an AI engineering and transformation partner seeking a Data Tosca QA Analyst to support enterprise data platforms within a healthcare environment. The role involves ensuring data accuracy, integrity, and reliability through structured testing and validation processes, while collaborating with technical and business teams.
Responsibilities
- Design and develop automated test cases using Tricentis Tosca to validate data pipelines and ETL workflows, ensuring coverage across integration, regression, and smoke testing scenarios
- Build and maintain reusable test components, modules, and libraries within the Tosca framework to support scalable and repeatable testing efforts
- Execute automated and manual test scenarios to validate data accuracy across source and target systems, including structured validation of transformations and business rules
- Write and execute complex SQL queries to verify data completeness, consistency, and integrity across multiple databases and environments
- Perform detailed validation of ETL processes, including testing aggregations, joins, and transformations within enterprise data workflows
- Validate data loads into data warehouses, data lakes, and reporting systems to ensure alignment with expected outputs and business requirements
- Conduct data reconciliation activities across systems to identify discrepancies and ensure consistency between upstream and downstream data sources
- Support testing for data migration initiatives, ensuring no data loss and confirming accuracy of migrated datasets
- Collaborate with business analysts and data engineers to understand data requirements, define test scenarios, and ensure proper test coverage
- Participate in requirement reviews and provide feedback on testability, data dependencies, and potential risks within data workflows
- Develop and maintain test plans, test strategies, and execution schedules aligned with project timelines and deliverables
- Log, track, and manage defects using tools such as JIRA or HP ALM, including detailed documentation with reproduction steps and SQL validation evidence
- Participate in defect triage sessions, working with development teams to identify root causes and validate fixes
- Generate test reports, dashboards, and metrics to communicate testing progress and data quality outcomes to stakeholders
- Support User Acceptance Testing (UAT) by coordinating with business users and ensuring alignment between technical validation and business expectations
- Maintain version control of test assets using tools such as Git or SVN, ensuring proper governance and traceability of testing artifacts
- Integrate testing processes into CI/CD pipelines to support continuous testing and automated validation within deployment workflows
Skills
- Bachelor's degree in Computer Science, Information Systems, Engineering, or related field
- 3–5 years of QA/testing experience with at least 2 years using Tricentis Tosca
- Proven experience in data testing, ETL validation, or data warehouse testing
- Hands-on experience testing data integration projects
- Proficiency in Tosca Commander, Tosca Executor, and test case design
- Experience with Tosca modules including TBox, XScan, API testing, and database testing
- Strong SQL skills with ability to write complex queries for data validation (joins, aggregations, CTEs, stored procedures)
- Experience with database platforms such as Oracle, SQL Server, Teradata, PostgreSQL, or MySQL
- Understanding of ETL concepts and data warehouse architectures including star schema & dimensional modeling
- Knowledge of data profiling and data comparison techniques
- Familiarity with version control systems such as Git or SVN
- Strong understanding of QA methodologies and SDLC
- Experience with test management and defect tracking tools such as JIRA, TestRail, qTest, or HP ALM
- Experience working within Agile/Scrum environments
- Experience with API testing including REST and SOAP
- Understanding of CI/CD pipelines and test automation integration
- Tosca Certification (Automation Specialist Level 1 or Automation Specialist Level 2)
- Experience with Tosca Data Integrity (TDI) module
- Experience with ETL tools such as Informatica, SSIS, or Talend
- Familiarity with cloud data platforms such as Snowflake, Azure Synapse, AWS Redshift, or Google BigQuery
- Experience with performance testing for data loads
- Python or scripting experience for automation
- Exposure to Big Data technologies such as Hadoop, Spark, or Hive
- ISTQB or similar testing certification
- Industry experience within healthcare, finance, or retail
Benefits
- Benefits available (•optional•) [Medical, Dental, Vision, and 401(k) match]
Company Overview
CEI is an AI engineering and transformation partner that designs, builds, and operationalizes production grade AI across enterprise systems. It was founded in 1992, and is headquartered in Pittsburgh, Pennsylvania, USA, with a workforce of 1001-5000 employees. Its website is http://www.ceiamerica.com/.Company H1B Sponsorship
CEI has a track record of offering H1B sponsorships, with 5 in 2026, 17 in 2025, 7 in 2024, 17 in 2023, 12 in 2022, 17 in 2021, 27 in 2020. Please note that this does not guarantee sponsorship for this specific role.