Senior ETL Automation Tester

Job Description

Purpose of the role

To design, develop, and execute testing strategies to validate functionality, performance, and user experience, while collaborating with cross-functional teams to identify and resolve defects, and continuously improve testing processes and methodologies, to ensure software quality and reliability. 

Accountabilities

• Development and implementation of comprehensive test plans and strategies to validate software functionality and ensure compliance with established quality standards.

• Creation and execution automated test scripts, leveraging testing frameworks and tools to facilitate early detection of defects and quality issues.         .

• Collaboration with cross-functional teams to analyse requirements, participate in design discussions, and contribute to the development of acceptance criteria, ensuring a thorough understanding of the software being tested.

• Root cause analysis for identified defects, working closely with developers to provide detailed information and support defect resolution.

• Collaboration with peers, participate in code reviews, and promote a culture of code quality and knowledge sharing.

• Stay informed of industry technology trends and innovations, and actively contribute to the organization's technology communities to foster a culture of technical excellence and growth.

Assistant Vice President Expectations

• To advise and influence decision making, contribute to policy development and take responsibility for operational effectiveness. Collaborate closely with other functions/ business divisions.

• Lead a team performing complex tasks, using well developed professional knowledge and skills to deliver on work that impacts the whole business function. Set objectives and coach employees in pursuit of those objectives, appraisal of performance relative to objectives and determination of reward outcomes

• If the position has leadership responsibilities, People Leaders are expected to demonstrate a clear set of leadership behaviours to create an environment for colleagues to thrive and deliver to a consistently excellent standard. The four LEAD behaviours are: L – Listen and be authentic, E – Energise and inspire, A – Align across the enterprise, D – Develop others.

• OR for an individual contributor, they will lead collaborative assignments and guide team members through structured assignments, identify the need for the inclusion of other areas of specialisation to complete assignments. They will identify new directions for assignments and/ or projects, identifying a combination of cross functional methodologies or practices to meet required outcomes.

• Consult on complex issues; providing advice to People Leaders to support the resolution of escalated issues.

• Identify ways to mitigate risk and developing new policies/procedures in support of the control and governance agenda.

• Take ownership for managing risk and strengthening controls in relation to the work done.

• Perform work that is closely related to that of other areas, which requires understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function.

• Collaborate with other areas of work, for business aligned support areas to keep up to speed with business activity and the business strategy.

• Engage in complex analysis of data from multiple sources of information, internal and external sources such as procedures and practises (in other areas, teams, companies, etc).to solve problems creatively and effectively.

• Communicate complex information. 'Complex' information could include sensitive information or information that is difficult to communicate because of its content or its audience.

• Influence or convince stakeholders to achieve outcomes.

All colleagues will be expected to demonstrate the Barclays Values of Respect, Integrity, Service, Excellence and Stewardship – our moral compass, helping us do what we believe is right. They will also be expected to demonstrate the Barclays Mindset – to Empower, Challenge and Drive – the operating manual for how we behave.

Join us as a Senior ETL Automation Tester at Barclays, responsible for supporting the successful delivery of location strategy projects to plan, budget, agreed quality and governance standards. You'll spearhead the evolution of our digital landscape, driving innovation and excellence. You will harness cutting-edge technology to revolutionise our digital offerings, ensuring unparalleled customer experiences.

To be successful as a Senior ETL Automation Tester you should have experience with: 

• Expertise in ETL tool (e.g. Informatica)

• Develop and execute ETL test cases, Test scripts and data validation scenarios.

• Validation on data extraction, transformation and loading along with data completeness.

• Test Automation experience in developing and implementing ETL test automation scripts using Python, SQL scripting, QuerySurge, Unix and Shall Scripts.

• Automate comparison, schema validation and regression testing.

• Integrate test automation with CICD pipeline (Jenkins, Gitlab, DevOps)

• Optimize and maintain automated test suite for scalability and performance.

• Understand requirements, user stories and able to relate them with design document.

• Work closely with business analyst, Dev team to define the test scope. 

• Maintain Test Plan, Test Data and Automation in version control.

• Document best practices, lesson learnt and continues improvement strategies. 

• Identify and log defects via JIRA & defect management. 

• Work with business analyst and developers to troubleshoot data issues and pipeline failures.

• Provide detailed report on test execution, coverage, and defect analysis.

• Understanding of agile development/test methodology and practice it in day-to-day work

• Unearth gaps between business requirement and User stories

• Ensure ETL process adhere to data privacy and compliance. Validate data masking encryption and access control. Audit and data Recon testing to tack the data modification. 

Some other highly valued skills may include:

• Detail understanding of Cloud technology viz AWS, Confluent Kafka

• Good if have hands on experience in BDD / TDD

You may be assessed on key critical skills relevant for success in role, such as risk and controls, change and transformation, business acumen, strategic thinking and digital and technology, as well as job-specific technical skills.

This role is based out of Pune.