ETL Test Automation Engineer

Join us as an ETL Test Automation Engineer 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 unparalleled customer experiences. As a part of team of developers, you will deliver technology stack, using strong analytical and problem solving skills to understand the business requirements and deliver quality solutions.

To be successful as an ETL Test Automation Engineer you should have experience with:

• ETL Tools: Proficiency with enterprise ETL platforms like Abinitio primarily, Informatica PowerCenter, IBM DataStage, Talend, SSIS, or Matillion

• Scripting/Programming: Strong skills in Python, Java, or Scala for automation development

• SQL: Advanced database querying and optimization techniques across multiple database platforms

• Data Warehousing: Understanding of dimensional modeling and data warehouse architectures

• Cloud Platforms: Experience with AWS (Glue, Redshift), Azure (Data Factory, Synapse), or GCP (Dataflow, BigQuery)

• Hadoop Ecosystem: Hands-on experience with HDFS, MapReduce, YARN, and Spark

Some other highly valued skills includes:

• CI/CD Pipelines: Implementation of automated deployment for ETL processes

• Testing Frameworks: Data validation and automated testing methodologies i.e. Pytest

• Workflow Orchestration: Tools like Airflow, Control-M, or Oozie, Tivoli for process scheduling

• Version Control: Git-based workflows for ETL code management

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.

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.

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.