Data warehouse validation and automation Testing

2 days ago

SHIVAJI GARDENS MOONLI, India Citi Full time ₹ 9,00,000 - ₹ 12,00,000 per year

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.

  • data testing

    2 weeks ago

    /, SHIVAJI GARDENS, MOONLI, India Citi Full time US$ 1,04,000 - US$ 1,30,878 per year

    Job Description: Test Data ArchitectThis job posting is for a senior-level manager who specializes in automating the movement and transformation of data (ETL) within a banking environment.We are seeking a highly skilled and self-driven Data Testing Architect to oversee and own design, build, and deploy of scalable ETL pipelines across hybrid environments...

  • Test Automation Junior Engineer

    2 days ago

    /, SHIVAJI GARDENS, MOONLI, India Citi Full time ₹ 2,50,000 - ₹ 7,50,000 per year

    Test Automation Junior Engineer is a developing professional role. Applies specialty area knowledge in monitoring, assessing, analyzing and/or evaluating processes and data. Identifies policy gaps and formulates policies. Interprets data and makes recommendations. Researches and interprets factual information. Identifies inconsistencies in data or results,...

  • QA Automation Engineer Testing Analyst

    6 days ago

    /, SHIVAJI GARDENS, MOONLI, India Citi Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    The Applications Development Intermediate Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming...

  • Testing Intermediate Analyst

    8 hours ago

    /, SHIVAJI GARDENS, MOONLI, India Citi Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    The Testing Intermediate Analyst is a developing professional role. Deals with most problems independently and has some latitude to solve complex problems. Integrates in-depth specialty area knowledge with a solid understanding of industry standards and practices. Good understanding of how the team and area integrate with others in accomplishing the...

  • Big Data/Cloud Developer Assistant Vice President

    1 week ago

    /, SHIVAJI GARDENS, MOONLI, India Citi Full time ₹ 1,04,000 - ₹ 1,30,878 per year

    The Applications Development Senior Programmer Analyst is an intermediate level position responsible for participation in the establishment and implementation of new or revised application systems and programs in coordination with the Technology team. The overall objective of this role is to contribute to applications systems analysis and programming...

  • Data Analytics Assistant Vice President

    2 weeks ago

    /, SHIVAJI GARDENS, MOONLI, India Citi Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    The Data Analytics Senior Analyst is a seasoned professional role. Applies in-depth disciplinary knowledge, contributing to the development of new techniques and the improvement of processes and work-flow for the area or function. Integrates subject matter and industry expertise within a defined area. Requires in-depth understanding of how areas collectively...

  • Apps Dev Intmd Programmer Analyst

    2 weeks ago

    /, SHIVAJI GARDENS, MOONLI, India Citi Full time US$ 1,00,000 - US$ 1,50,000 per year

    Application / Team Overview: TTS Data and Analytics team takes care of all Analytics related initiates for TTS this includes Compliance Analytics, Pricing Analytics. Self Service Analytics and Conformance modelling. Team good exposure to most of the business units within TTS to source data and produce meaningful Analytics Dashboard for Client and TTS Senior...

  • Applications Support Analyst

    2 weeks ago

    /, SHIVAJI GARDENS, MOONLI, India Citi Full time ₹ 4,80,000 - ₹ 7,20,000 per year

    The Applications Support Analyst 2 is a developing professional role. Applies specialty area knowledge in monitoring, assessing, analyzing and/or evaluating processes and data. Identifies policy gaps and formulates policies. Interprets data and makes recommendations. Researches and interprets factual information. Identifies inconsistencies in data or...

  • Apps Support Intmd Analyst

    2 weeks ago

    /, SHIVAJI GARDENS, MOONLI, India Citi Full time ₹ 4,00,000 - ₹ 12,00,000 per year

    The Apps Support Intmd Analyst is a developing professional role. Deals with most problems independently and has some latitude to solve complex problems. Integrates in-depth specialty area knowledge with a solid understanding of industry standards and practices. Good understanding of how the team and area integrate with others in accomplishing the objectives...

  • Senior Web Developer- C11

    2 weeks ago

    /, SHIVAJI GARDENS, MOONLI, India Citi Full time US$ 80,000 - US$ 1,50,000 per year

    The Digital S/W Engineer Intmd Analyst is a developing professional role. Deals with most problems independently and has some latitude to solve complex problems. Integrates in-depth specialty area knowledge with a solid understanding of industry standards and practices. Good understanding of how the team and area integrate with others in accomplishing the...