Join us as a Test Engineer - Salesforce ETL QA at Barclays, where you will play a key role in ensuring the quality, accuracy, and integrity of data across Salesforce and enterprise applications. You will work on large-scale data migration, integration, and transformation initiatives, driving high standards of quality throughout the software delivery lifecycle.
To be successful as a Test Engineer - Salesforce ETL QA, you should have experience with:
- Strong experience in ETL Testing, Data Migration Testing, and Data Warehouse Testing.
- Strong SQL knowledge and ability to perform source-to-target data validation and reconciliation.
- Experience testing Salesforce applications, preferably Service Cloud and/or Sales Cloud.
- Strong understanding of Salesforce data model, standard and custom objects, relationships, and data validation rules.
- Experience validating complex data transformations, business rules, and data mappings.
- Experience with Integration and API Testing using Postman or similar tools.
- Strong working knowledge of Ab Initio, Teradata, and enterprise data processing frameworks.
- Experience working with AWS services and cloud-based data platforms.
- Good understanding of Unix/Linux commands, shell scripting basics, PuTTY, and WinSCP for log analysis, file validation, and batch process verification.
- Experience using Salesforce Data Loader, Salesforce Inspector, or similar data management tools.
- Experience validating batch jobs, file transfers, ETL workflows, and end-to-end data pipelines.
- Strong problem-solving skills and ability to troubleshoot data quality and integration issues.
- Experience working in Agile delivery environments utilizing JIRA and Confluence.
Some other highly valued skills may include:
- Experience building and executing automated data validation frameworks.
- Knowledge of Selenium and Java-based automation frameworks.
- Experience working with CI/CD tools such as Jenkins, GitLab, or Azure DevOps.
- Understanding of enterprise integration patterns and data architecture.
- Experience working with large-scale data migration and transformation programmes.
- Ability to work as an individual contributor while collaborating effectively with analysts, developers, architects, and product owners.
- Good communication skills and ability to articulate testing outcomes, data quality findings, and delivery risks to stakeholders.
- Banking and Financial Services domain experience.
Key Responsibilities
- Design, develop, and execute ETL, integration, and data validation test scenarios and test cases.
- Validate source-to-target mappings, transformation rules, and data migration activities.
- Perform backend data validation using SQL and reconcile data across multiple systems including Salesforce, AWS, and Teradata platforms.
- Validate Ab Initio workflows, batch processes, interfaces, file-based integrations, and data pipelines.
- Perform file validation and production support activities using Linux/Unix commands, PuTTY, and WinSCP.
- Test APIs, interfaces, batch jobs, and data pipelines supporting Salesforce and downstream applications.
- Identify, log, track, and retest defects through to closure.
- Support SIT, UAT, release validation, and production verification activities.
- Contribute to test automation and continuous quality improvement initiatives.
- Ensure compliance with Barclays testing standards, controls, and risk management requirements.
- Collaborate with cross-functional teams to support successful project delivery.
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.
The role is based out of Pune.
Purpose of the role
To design, develop and improve software, utilising various engineering methodologies, that provides business, platform, and technology capabilities for our customers and colleagues.
Accountabilities
- Development and delivery of high-quality software solutions by using industry aligned programming languages, frameworks, and tools. Ensuring that code is scalable, maintainable, and optimized for performance.
- Cross-functional collaboration with product managers, designers, and other engineers to define software requirements, devise solution strategies, and ensure seamless integration and alignment with business objectives.
- 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.
- Adherence to secure coding practices to mitigate vulnerabilities, protect sensitive data, and ensure secure software solutions.
- Implementation of effective unit testing practices to ensure proper code design, readability, and reliability.
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.
