Data warehouse validation and automation testing, Citi

Citi

Location:
India, Chennai

Category:
IT - Software Development

Contract Type:
Employment contract

Salary:

Not provided

Save Job

Apply Position

Job Description:

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.

Job Responsibility:

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

Requirements:

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

Nice to have:

experience with Python and Selenium for automation
experience with ETL tools such as Ab-Initio, Talend
familiarity with Python, Java, or Shell scripting

Additional Information:

Job Posted:
October 14, 2025

Employment Type:

Fulltime

Work Type:

On-site work

View All Jobs In This Company

Job Link Share:

Data warehouse validation and automation testing