Quality Analyst - Manual Testing

Description :

We are the only Pure play analytics company focused on brining this expertise to credit unions. Trellance is a leading provider of business analytics and technology consulting for credit unions, helping them meet the financial needs of todays digital consumer. With a comprehensive suite of data science solutions, professional staffing and professional services, the Trellance team ensures credit unions increase efficiency, manage risk, and improve member experience. As credit unions tech partner, Trellance brings them to the next frontiers of fintech, filled with powerful tools such as artificial intelligence and machine learning.

Designation : Quality Analyst

Experience Required : 1-3+ years

Job Description :

As a QA Analyst, you will play a crucial role in our development process by implementing our organizational testing standards, automating test procedures, and collaborating with cross-functional teams to deliver high-quality software. You will be responsible for designing and executing test plans, identifying defects, and providing actionable feedback to improve our products.

Responsibilities :

- Perform manual testing (Functional, Regression, Smoke, Sanity)

- Validate data by writing and executing SQL queries

- Conduct data validation testing between :

1. UI / API / Source systems / Database / Data Warehouse / Reports/Dashboards

- Perform Data Warehousing testing including :

1. Data extraction, transformation, and loading validation (ETL testing)

2. Data reconciliation between source and target systems

3. Testing fact and dimension tables

- Verifying data integrity, completeness, and consistency

- Identify defects and log them using tools like JIRA / Azure DevOps

- Work closely with Developers, BA, and Data Engineering teams for defect resolution

- Prepare and share test execution reports and defect metrics

- Participating in Agile ceremonies (Daily standup, Sprint planning, Retrospective)

Required Skills & Qualifications :

- 3+ years of experience in software quality assurance and testing

- Experience as a Test Analyst / QA Analyst

- Strong understanding of STLC and Defect Life Cycle

- Good knowledge of manual testing processes and methodologies

- Proficiency in SQL query writing for data validation

- Knowledge of Data Warehousing concepts

- Star schema / Snowflake schema

- Fact tables and Dimension tables

- Data modeling basics

- Data validation and reconciliation techniques

- Basic understanding of ETL process and data pipeline testing

- Familiarity with defect tracking tools : JIRA / Azure DevOps / Bugzilla

- Knowledge of Agile/Scrum methodology

- Strong analytical and communication skills

Good to have Skills (Preferred) :

- Experience with BI reporting tools like Power BI / Tableau

- Awareness of Automation Testing tools (Selenium / Playwright)

- Knowledge of cloud platforms like Azure / AWS / GCP

- Experience with continuous testing in DevOps environments

- Knowledge of test data management and test environment provisioning