QA Engineer - Data Testing & Automation

Discover your future at Citi

Working at Citi is far more than just a job. A career with us means joining a team of more than 230,000 dedicated people from around the globe. At Citi, you’ll have the opportunity to grow your career, give back to your community and make a real impact.

Job Overview

Job Summary:

We are seeking a highly skilled and experienced Senior QA Engineer with a strong background in data testing, both manual and automated, to join our Quality Assurance team. You will play a crucial role in ensuring the quality and integrity of our data pipelines, data warehousing solutions, and reporting systems. The ideal candidate possesses a keen eye for detail, a passion for quality, and a proven track record of designing and executing comprehensive test strategies. Experience in the banking domain is highly preferred.

Responsibilities:

Data Testing:
Design, develop, and execute test plans, test cases, and test scripts for data validation, transformation, and loading processes.
Perform in-depth data analysis and validation using SQL and other data analysis tools.
Validate data integrity, accuracy, and completeness across various data sources and systems.
Identify and document data anomalies, inconsistencies, and defects.
Test Automation:
Develop and maintain automated test frameworks and scripts for data testing using Python or other scripting languages.
Automate data validation checks, ETL processes, and data quality rules.
Integrate automated tests into CI/CD pipelines.
Manual Testing:
Perform manual testing of data-related functionalities, including data entry, reporting, and dashboards.
Execute exploratory testing to uncover hidden defects and edge cases.
Collaboration and Communication:
Collaborate effectively with data engineers, developers, and business analysts to understand data requirements and testing needs.
Communicate test results, defects, and risks clearly and concisely.
Qualifications:

Bachelor's degree in Computer Science, Information Systems, or a related field.
5+ years of experience in software quality assurance, with a strong focus on data testing.
Proven experience in designing and executing both manual and automated data testing strategies.
Strong SQL skills for data analysis and validation.
Experience with test automation frameworks and scripting languages (e.g., Python, Java).
Experience with data warehousing concepts, ETL processes, and data quality tools.
Deep understanding of software testing methodologies and best practices.
Excellent analytical, problem-solving, and communication skills.
Experience in the banking or financial services domain is highly preferred.
Preferred Skills:

Experience with CI/CD tools (e.g., Jenkins, GitLab CI).
Familiarity with cloud-based data warehousing solutions (e.g., Snowflake, AWS Redshift).
Experience with performance testing of data pipelines and databases.