Data warehouse validation and automation Testing

7 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.

  • Testing and Validation Engineer

    10 hours ago

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

    Overview: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...

  • Automation Test Engineer

    8 hours ago

    Chennai, Tamil Nadu, India Data Software Research Company (DSRC) Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Experience : above 4 years Location: ChennaiResponsibilities:Design, implement, and optimize test automation frameworks using Playwright and JavaScript to ensure effective validation of our web applications.Develop and execute automated test scripts for UI components, ensuring high performance and reliability of our applications.Translate manual test cases...

  • ETL Testing

    6 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

    2 weeks 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...

  • Automation Test Lead

    9 hours ago

    Chennai, Tamil Nadu, India Zuci Systems Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    Develop test strategies, plans, and maintain automation test data.Develop and continuously improve automated tests as new system features and enhancements are developed.Execute automated tests and manage the resulting defect log through the point of defect fix validation.Ensure the appropriate test environments and infrastructures are in place and kept up to...

  • Senior Data Engineer – QA Process Automation

    2 weeks ago

    Chennai, Tamil Nadu, India Systech Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Senior Visualization Engineer – PowerBIAbout the CompanySystech is a modern Data and Analytics consulting firm, helping clients embed data-driven capabilities into their business operations. We offer end-to-end data engineering services and outcomes-based analytics solutions, to drive your business forward in the digital age. Systech has over 30 years of...

  • Architect, Test Automation

    8 hours ago

    Chennai, Tamil Nadu, India ValGenesis Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    About ValGenesisValGenesis 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 working...

  • Snowflake Data Warehouse Engineers

    4 days ago

    Chennai, Tamil Nadu, India IDESLABS PRIVATE LIMITED Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    We need an experienced, collaborative Snowflake Data Warehouse Engineers with5+ Yrs of experience in developing Snowflake data models, data ingestion, views, Stored procedures, complex queriesGood experience in SQLExperience in Informatica Powercenter IICS ETL toolsTesting and clearly document implementations, so others can easily understand the...

  • Test Engineer

    2 weeks ago

    Chennai, Tamil Nadu, India, Tamil Nadu HCLTech Full time

    Key Responsibilities1. Plan, design, and execute test strategies for cloud applications, ensuring comprehensive testing coverage.2. Implement and maintain automated testing frameworks for efficient and reliable testing processes.3. Lead and mentor the testing team to deliver high-quality results within the stipulated timelines.4. Collaborate with cross...

  • QA Test Lead

    5 hours ago

    Chennai, Tamil Nadu, India ResourceTree Global Services Pvt Ltd Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Years of Experience: 6Job Description: We are seeking an experienced and detail-oriented Senior Data Engineer with strong expertise in QA process automation for data validation and testing. The ideal candidate will bring hands-on experience with QuerySurge and a solid foundation in ETL/ELT processes, data integration, and data quality assurance. In this...