Staff Engineer, ETL Tester

Summary

Join Nagarro, a rapidly growing Digital Product Engineering company, as a skilled Automation and ETL Tester. You will play a crucial role in ensuring the quality of our products and services. This position requires 7+ years of experience in automation and ETL testing, proficiency in Java and Selenium, and expertise in SQL and ETL tools like Informatica and Snowflake. You will be responsible for designing and developing automated testing frameworks, preparing test plans and reports, and collaborating with clients and stakeholders. Your strong problem-solving skills, attention to detail, and excellent communication abilities will be essential to success in this dynamic and non-hierarchical work environment.

Requirements

• Total experience 7+years
• Strong working experience in automation and ETL testing
• Proficiency in automation using Java and Selenium
• Experience in scripting and automation using Python
• Strong expertise in SQL for writing complex queries and performing data validation
• Hands-on experience with ETL tools like Informatica and data platforms like Snowflake
• Experience in building reports using Tableau or similar visualization tools
• Strong understanding of data operations, data quality, and data transformation processes
• Familiarity with Agile/Scrum development methodology
• Excellent problem-solving skills and attention to detail
• Strong communication and teamwork skills
• Bachelor’s or master’s degree in computer science, Information Technology, or a related field

Responsibilities

• Understanding the projects functional and non-functional requirements and the business context of the application being developed. Understanding and documenting requirements validated by the SMEs
• Interacting with clients to identify the scope of testing, expectations, acceptance criteria and availability of test data and environment. Working closely with product owner in defining and refining acceptance criteria
• Preparing test plan/strategy
• Estimating the test effort and preparing schedules for testing activities, assigning tasks, identifying constraints and dependencies
• Risk management identifying, mitigating and resolving business and technical risks. Determines the potential causes of problems and analyses multiple alternatives
• Designing and developing a framework for automated testing following the project's design and coding guidelines. Set up best practices for test automation
• Preparing test reports to summarize the outcome of the testing phase and recommending whether the application is in a shippable state or not
• Communicating measurable quality metrics, with the ability to highlight problem areas and suggest solutions
• Participating in retrospective meetings, helping identify the root cause of any quality related issue and identifying ways to continuously improve the testing process
• Conducting demos of the application for internal and external stakeholders
• Reviewing all testing artifacts prepared by the team and ensuring that defects found during the review are tracked to closure
• Working with team and stakeholders to triage and prioritize defects for resolution
• Giving constructive feedback to the team members and setting clear expectations

Preferred Qualifications

• Experience with other ETL tools or reporting platforms
• Exposure to CI/CD pipelines and automation frameworks
• Knowledge of performance testing and data governance