Data warehouse validation and automation Testing

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

The candidate should be responsible for ensuring the quality and integrity of our data warehouse applications. This role requires a professional with sound knowledge of Oracle and Unix environments, capable of coordinating closely with various technology teams to deliver high-quality solutions. A strong understanding of data warehouse testing methodologies is crucial for validating applications and enhancing validation automation through scripting tools. Experience with Python and Selenium for automation is considered a significant advantage.
Responsibilities
Utilize in-depth data warehouse testing knowledge to validate applications and enhance validation automation using scripting tools.
Collaborate with partner systems to conduct near-partner and End-to-End (E2E) validations.
Create and develop test scenarios for requirements originating from partner systems.
Log defects in designated defect tracking tools and manage test cases in respective test management tools, with a focus on automated execution.
Demonstrate experience in using, designing, or contributing to a data comparison tool.
Perform thorough testing of ETL software, verifying the integrity and performance of data warehouse components.
Develop and execute test cases and test plans.
Write SQL queries for testing scenarios and to perform data integrity testing.
Conduct various types of testing, including but not limited to metadata testing, data transformation testing, and data quality testing.
Qualifications
4-7 years of relevant experience in data warehouse testing.
Strong domain knowledge and proven automation skills are an added advantage.
Demonstrated problem-solving and decision-making skills.
Consistently exhibits clear and concise written and verbal communication.
Ability to work effectively under pressure and manage deadlines or unexpected changes in expectations or requirements.
Proficiency in SQL is essential for querying databases and checking data.
Experience with ETL tools such as Ab-Initio, Talend is highly desirable.
Familiarity with Python, Java, or Shell scripting for automation is beneficial.
Understanding of data warehousing concepts and architecture
Education
Bachelor's degree / University degree or equivalent.

Education:

• Bachelor’s degree/University degree or equivalent experience

This job description provides a high-level review of the types of work performed. Other job-related duties may be assigned as required.

------------------------------------------------------

Job Family Group:

Technology

------------------------------------------------------

Job Family:

Applications Development

------------------------------------------------------

Time Type:

Full time

------------------------------------------------------

Most Relevant Skills

Please see the requirements listed above.

------------------------------------------------------

Other Relevant Skills

For complementary skills, please see above and/or contact the recruiter.

------------------------------------------------------

Citi is an equal opportunity employer, and qualified candidates will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other characteristic protected by law.

If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi.

View Citi’s EEO Policy Statement and the Know Your Rights poster.