[Remote] Tosca Data QA Analyst

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

Company H1B Sponsorship