Senior Engineer, ETL Testing

Job Description

Total experience 3+years. Strong experience in ETL Testing, data migration, and data validation processes. Solid understanding of complex SQL queries and data validation techniques. Experience working with tools like Apache Airflow, Databricks, or similar data orchestration platforms. Proven track record in managing data readiness for large-scale implementations across multiple geographies. Familiarity with data warehousing and data lake architectures. Develop and maintain automation frameworks using Python for ETL testing. Analyse test results, debug issues, and collaborate with developers for resolution. Excellent understanding of data quality, cleansing strategies, and load validation techniques. Experience in working within structured project frameworks, including SIT/UAT, mock loads, and cutover plans. Strong communication and coordination skills to work with cross-functional and globally distributed teams. 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 projects 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. Bachelor s or master s degree in computer science, Information Technology, or a related field.