Etl Tester

**Job title**: ETL Tester

**Location**: Pune

About Barclays
Barclays is a British universal bank. We are diversified by business, by different types of customers and clients, and by geography. Our businesses include consumer banking and payments operations around the world, as well as a top-tier, full service, global corporate and investment bank, all of which are supported by our service company which provides technology, operations and functional services across the Group.

Risk and Control Objective
Ensure that all activities and duties are carried out in full compliance with regulatory requirements, Enterprise Wide Risk Management Framework and internal Barclays Policies and Policy Standards.

Working Flexibly

BUK & BX - All locations

Please discuss the detail of the working pattern options for the role with the hiring manager.

**Introduction**:

- Under minimum or no supervision carries out procedures and tests to ensure that information systems meet standards and end user requirements.
- Mitigate risks to Business through timely and precise execution of manual/automated test scripts under mínimal supervision.
- Responsible for specific test phases
- Preparation and execution of test ware - scenarios, cases and data
- Produce test results/screenshots & evidence those through Agile Central/ JIRA

What will you be doing?
- Understanding functionality related to given module.
- Develop and execute formal test plans within schedule and budget constraints.
- Develop test specifications based on various requirement documents within schedule constraints
- Document defects & track till closure
- Create & execute complex test ware - estimates, scenarios, cases, data
- Develop test bed and verify test environments.
- Set up necessary monitoring / profiling tools to identify and isolate performance bottlenecks
- Perform functional and technical test execution activities (automated tests, where applicable) as per engagement level in the project
- Assist the Test lead/ manager in managing the testing day to day
- Build knowledge repository on best practices on using specific test tools
- Uses utilities and tools to support testing
- Create and maintain required MI for the project/ module, update agile central.
- Sharing of re-usable components to test engineering colleagues and other test teams
- Deliver test automation improvement initiatives within the project group.
- Conform to established best practices and any appropriate test automation standards

**What we’re looking for**:

- Extensive experience working in UNIX environment
- Extensive experience in ETL tools Abinitio and Informatica (Preferably Abinitio) and Data warehouse testing
- Very strong SQL skills
- Exposure to testing Hadoop systems (Sqoop, Spark, Hive, Pig etc.)
- Strong technical background with detail driven and excellent problem solving abilities
- Good product and testing acumen
- Proven track record for agile, test-driven development, behaviour driven development, continuous integration, and automated testing

**Skills that will help you in the role**:

- Conform to established good practice and any appropriate test automation standards
- Strong experience in Agile with experience working in Agile Scrum methodology. Some Agile certification is preferred.
- Exposure to Continuous Integration (CI) Environment/ tools such as Jenkins, Team City, etc and BDD
- Knowledge of Agile Central and JIRA

**o Certification**: ISTQB/CSTE / CSQA

Where will you be working?
Pune

Be More at Barclays
Interested and want to know more about Barclays? Visit home.barclays/who-we-are/ for more details.
Purpose, Values and Mindset

We deploy finance responsibly to support people and businesses, acting with empathy and integrity, championing innovation and sustainability, for the common good and the long term.

**Our values underpin everything we do**: Respect, Integrity, Service, Excellence and Stewardship.

Respect
We harness the power of diversity and inclusion in our business, trust those we work with, and value everyone's contribution.
Integrity
We operate with honesty, transparency and fairness in all we do.
Service
We act with empathy and humility, putting the people and businesses we serve at the centre of what we do.
Excellence
We champion innovation, and use our energy, expertise and resources to make a positive difference.
Stewardship
We prize sustainability, and are passionate about leaving things better than we found them.

Our Mindset shapes how we take action, living by our Values, driven by our Purpose, always with our customers and clients at the heart of what we do; our Mindset is to Empower, Challenge and Drive.

Empower
Trust and support each other to deliver. Make decisions with those closest to the topic. Include diverse perspectives. Celebrate success and learn from failure.
Challenge
Question whether things can be done better. Use insights based on data to inform decisions. Be curious about how we can adapt and improve. Speak up and