QA Lead Consultant, Data Testing

Job Summary:

Techstra is seeking a highly experienced and detail-oriented QA Lead Consultant, Data Testing with a strong background in banking or financial services. The ideal candidate will be responsible for ensuring the accuracy, completeness, and integrity of data across various systems, platforms, and reports. You will work closely with data engineers, analysts, developers, and business stakeholders to validate complex data pipelines, ETL processes, and reporting outputs.

From the day you join, you will hit the ground running surrounded by amazing people. Here is a look of some of the expectations and responsibilities for this position:

Key Responsibilities:

Design, develop, and execute test strategies and plans for data-related projects (ETL, data lakes, data warehouses).

Validate data integrity, transformations, and business logic from source to target systems.

Perform advanced SQL queries to verify large data sets and identify anomalies or inconsistencies.

Automate data validation processes using appropriate tools and scripting languages (e.g., Python, SQL, Shell).

Collaborate with cross-functional teams (developers, BAs, DBAs, data engineers) to understand data flow and requirements.

Validate regulatory and compliance-related reports (e.g., AML, KYC, Basel, CCAR, etc.).

Participate in Agile ceremonies (stand-ups, sprint planning, retrospectives).

Investigate and document data defects and work with teams to ensure timely resolution.

Create and maintain detailed test documentation, test cases, and test results for audit and compliance purposes.

Qualifications:

Bachelor’s degree in Computer Science, Information Systems, or a related field.

7+ years of QA experience, with a focus on data testing, ETL validation, and database QA.

Strong knowledge of SQL (joins, CTEs, window functions, aggregations).

Experience testing data in data warehouses (e.g., Snowflake, Redshift, Teradata) and ETL tools (e.g., Informatica, Talend, Apache NiFi).

Hands-on experience with banking or financial domain data, including compliance and risk reporting.

Familiarity with data quality frameworks, data governance, and metadata management.

Knowledge of testing tools and frameworks (e.g., Selenium for UI, PyTest for data validation, JIRA, TestRail).

Experience working in Agile/Scrum environments.

Excellent analytical, communication, and problem-solving skills.

Preferred Skills:

Experience with Big Data platforms (e.g., Hadoop, Spark).

Knowledge of cloud data services (AWS, Azure, GCP).

Familiarity with data visualization tools like Tableau or Power BI.

Financial certifications (e.g., CFA, FRM) or QA certifications (e.g., ISTQB) are a plus.

At Techstra Solutions, we help top companies and brands achieve the business value of Digital and Talent Transformation. We believe there are three components in successful business transformation: Business Strategy, Technology and Talent. It is the coming together of these three disciplines that enables companies to take full advantage of opportunities. It differentiates us. Our approach is holistic and all encompassing. We consider the full picture as we guide our clients on this journey.

We are experts in transformation, business strategy, technology, innovation, and human capital management. We deliver our expertise through client consulting, innovative staffing solutions and software development. From strategy through implementation, we are dedicated to bringing our clients world-class business and talent solutions that fit strategic requirements and most importantly, deliver results.

Equal Employment Opportunity Statement

Techstra Solutions is an equal opportunity employer. The Company makes its decisions on merit, and its policy of equal opportunity prohibits discrimination in all phases of the employment process, including, but not limited to, recruitment, hiring, promotion, selection, transfer, demotion, layoff, termination, compensation, benefits, and other terms and conditions of employment. The policy of equal opportunity applies without regard to race, color, creed, religion, gender,, sexual orientation, gender identification, pregnancy, marital status, national origin, ancestry, age, disability that can reasonably be accommodated without undue hardship, military status, veteran status, genetic predisposition or carrier status, alienage or citizenship, domestic partnership status, arrest or conviction record, status as a victim of domestic violence, or any other protected categories under federal, state, or local law. The Company also prohibits discrimination or harassment based upon the perception that a person has, or is associated with a person who has, any of these characteristics.