Data warehouse validation and automation Testing

6 days ago

Chennai, Tamil Nadu, India Citi Full time ₹ 15,00,000 - ₹ 25,00,000 per year
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.

  • ETL Testing

    6 hours ago

    Chennai, Tamil Nadu, India Virtusa Full time ₹ 5,00,000 - ₹ 25,00,000 per year

    Excellent in writing SQL Scripts to validate data in ODS and Mart.Should be able to develop and execute test plans, test cases, test scripts.Strong in validation of Visual Analytics reports using tools like Power BI, MicroStrategy, etc. and running different types of test within the same. Identifies, manages, and resolves defects during testing cycles...

  • Testing and Validation Engineer

    2 weeks ago

    Chennai, Tamil Nadu, India Expleo Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Minimum 5 years of experience/ 10 years of experience in software testing/validation in a regulated environment.Ability to successfully manage multiple tasks and timelinesAbility to effectively liaise with project team members and other teams/departments, on-site and remotely.Ability to perform and coordinate activities required to bring/maintain systems to...

  • Validation Testing Engineer

    2 weeks ago

    Chennai, Tamil Nadu, India Reveille Technologies,Inc Full time ₹ 4,00,000 - ₹ 12,00,000 per year

    Hiring: Validation Testing Engineer FTE Experience: 4–10 Years (Minimum 4+ Years Relevant) Notice Period: Immediate Joiners Preferred Location: chennaiKey Skills (Mandatory): Validation Testing with SQLGood to Have: Automation Testing DM or share your ./.

  • ETL Testing

    4 days ago

    Chennai, Tamil Nadu, India Cognizant Full time ₹ 4,00,000 - ₹ 8,00,000 per year

    Key skills: ETL TestingExperience: 6 to 9 yearsLocation: BhubaneswarJob Summary: We are seeking a detail-oriented and experienced Testing Engineer to join our team. The ETL Testing Engineer will be responsible for designing, executing, and automating test cases to ensure the quality and integrity of data extracted, transformed, and loaded into data...

  • Data Quality Engineer

    1 week ago

    Chennai, Tamil Nadu, India Epam Systems Full time ₹ 10,00,000 - ₹ 18,00,000 per year

    We are seeking a highly skilled and detail-oriented Data Quality Engineer (Automation) to join our data engineering team.The ideal candidate will have a strong background in ETL automation, data warehouse testing, and cloud data services, along with hands-on experience in test automation frameworks and CI/CD practices.ResponsibilitiesDesign, develop, and...

  • ETL Testing

    2 weeks ago

    Chennai, Tamil Nadu, India Kumaran Systems Full time ₹ 2,50,000 - ₹ 7,50,000 per year

    Required Skills & ExperienceTechnical Expertise:Strong hands-on experience in Azure Data Factory (ADF) and Databricks.Proficiency in SQL for data validation and reconciliation (including advanced joins, window functions, aggregates).Hands-on experience with PySpark for large-scale data validation and transformations.Strong programming/scripting skills in...

  • Senior Automation Testing

    13 hours ago

    Chennai, Tamil Nadu, India Sequoia Applied Technologies Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Job Title: Senior QA EngineerExperience: 4 to 6 years Location: Chennai / Kochi / TrivandrumEmployment Type: Full-time  Job Description:  We are looking for a skilled Senior QA Engineer with 4-6 years of experience to join our team. The ideal candidate will have a strong background in testing data-intensive applications, ensuring data integrity,...

  • SFDC QA Automation

    1 week ago

    Chennai, Tamil Nadu, India NTT DATA North America Full time ₹ 5,00,000 - ₹ 12,00,000 per year

    Job Description:We are seeking a skilled and detail-oriented Salesforce QA Engineer to ensure the quality, performance, and reliability of our Salesforce Service Cloud applications. This role requires hands-on experience in manual and automated testing, REST API validation, performance testing, and Agile/Scrum methodologies. The ideal candidate will work...

  • Automation Test Engineer

    6 days ago

    Chennai, Tamil Nadu, India Centific Full time ₹ 40,00,000 - ₹ 80,00,000 per year

    Job Title:SDET/Automation Test Engineer,Location:Chennai, TN, India.Work Type:Fulltime/Permanent.Job Description:Key ResponsibilitiesDevelop, maintain, and execute automated test cases for Intune features across Web UI, Mobile (Android/iOS), and Windows devices.Perform functional, regression, compatibility, UX, and end-to-end testing across multiple...

  • Architect, Test Automation

    2 days ago

    Chennai, Tamil Nadu, India ValGenesis Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    About ValGenesis  ValGenesis is a leading digital validation platform provider for life sciences companies. ValGenesis suite of products are used by 30 of the top 50 global pharmaceutical and biotech companies to achieve digital transformation, total compliance and manufacturing excellence/intelligence across their product lifecycle.    Learn more about...