ETL Automation Tester

Join us as an “

ETL Automation Tester " at Barclays, where you'll spearhead the evolution of our digital landscape, driving innovation and excellence. You'll harness cutting-edge technology to revolutionise our digital offerings, ensuring unapparelled customer experiences. You may be assessed on the key critical skills relevant for success in role, such as experience with, skills to meet business requirement as well as job-specific skillsets. To be successful as an “

ETL Automation Tester ", you should have experience with:

Basic/ Essential Qualifications

• Expertise in ETL tool e.g. Informatica or AbInitio. 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 Shell 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.

Desirable Skillsets/ Good To Have

• Detail understanding of Cloud technology viz AWS, Confluent Kafka & added advantage if have hands on experience in BDD / TDD. This role will be based out of Pune.

Purpose of the role Facilitates and supports Agile teams by ensuring they follow Scrum principles. To remove obstacles, enhance team collaboration, and ensure smooth communication, enabling the team to focus on delivering high-quality, iterative results. Facilitate Scrum events, promote continuous improvement, and act as a bridge between the team and external stakeholders.

Accountabilities

• Facilitate Events: Facilitate events, as needed, and ensure that all events take place and are positive, productive, and kept within the timebox
• Support Iteration Execution: Ensure quality of ceremony artefacts and continuous customer value through iteration execution, maintain backlog refinement, and iterate on stakeholder feedback
• Optimize Flow: Identify and facilitate the removal of conflict impacting team flow, utilizing metrics to empower the team to communicate effectively, making all work visible
• Mitigate Risks: Identify and escalate risks to remove impediments and shield the Squad from interruptions
• Build High-Performing Teams: Foster and coach Agile Team attributes and continuous improvement, encourage stakeholder collaboration, deputise ‘in the moment leadership’, and drive high-performing team attributes
• Stakeholder Management: Facilitate stakeholder collaboration (e.g., business stakeholders, product teams, vendors) and build trust with stakeholders
• Governance and Reporting: Ensure data quality and provide representation at required governance forums, if applicable

Analyst Expectations To perform prescribed activities in a timely manner and to a high standard consistently driving continuous improvement. Requires in-depth technical knowledge and experience in their assigned area of expertise Thorough understanding of the underlying principles and concepts within the area of expertise They lead and supervise a team, guiding and supporting professional development, allocating work requirements and coordinating team resources. 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 develop technical expertise in work area, acting as an advisor where appropriate. Will have an impact on the work of related teams within the area.

Partner With Other Functions And Business Areas. Takes responsibility for end results of a team’s operational processing and activities. Escalate breaches of policies / procedure appropriately. Take responsibility for embedding new policies/ procedures adopted due to risk mitigation. Advise and influence decision making within own area of expertise. Take ownership for managing risk and strengthening controls in relation to the work you own or contribute to. Deliver your work and areas of responsibility in line with relevant rules, regulation and codes of conduct. Maintain and continually build an understanding of how own sub-function integrates with function, alongside knowledge of the organisations products, services and processes within the function. Demonstrate understanding of how areas coordinate and contribute to the achievement of the objectives of the organisation sub-function. Make evaluative judgements based on the analysis of factual information, paying attention to detail. Resolve problems by identifying and selecting solutions through the application of acquired technical experience and will be guided by precedents. Guide and persuade team members and communicate complex / sensitive information. Act as contact point for stakeholders outside of the immediate function, while building a network of contacts outside team and external to the organisation. 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.