Assistant Vice President - Test Environment Analyst

Test Data Analyst

Job Title: Test Data Analyst - Assistant Vice President

Location: Pune, India

Role Description

• We are seeking a proactive and skilled Assistant Vice President, Test Data Analyst, to join our Corporate Bank. In this role, you will be instrumental in the execution and support of test data management activities, ensuring the provision of high-quality, relevant, and compliant test data for our diverse technology landscape.

• You will work closely with Test Data Manager, development and QA teams to facilitate efficient testing cycles, enhance test coverage, and contribute to the delivery of robust and reliable banking applications.

• This position requires a strong technical aptitude, an understanding of corporate banking data, and a collaborative spirit.

Deutsche Bank’s Corporate Bank division is a leading provider of cash management, trade finance and securities finance. We complete green-field projects that deliver the best Corporate Bank - Securities Services products in the world. Our team is diverse, international, and driven by shared focus on clean code and valued delivery.  At every level, agile minds are rewarded with competitive pay, support, and opportunities to excel. 

You will work as part of a cross-functional agile delivery team. You will bring an innovative approach to software development, focusing on using the latest technologies and practices, as part of a relentless focus on business value. You will be someone who sees engineering as team activity, with a predisposition to open code, open discussion and creating a supportive, collaborative environment. You will be ready to contribute to all stages of software delivery, from initial analysis right through to production support.

What we’ll offer you

As part of our flexible scheme, here are just some of the benefits that you’ll enjoy

• Best in class leave policy

• Gender neutral parental leaves

• 100% reimbursement under childcare assistance benefit (gender neutral)

• Sponsorship for Industry relevant certifications and education

• Employee Assistance Program for you and your family members

• Comprehensive Hospitalization Insurance for you and your dependents

• Accident and Term life Insurance

• Complementary Health screening for 35 yrs. and above

Your key responsibilities

• Data Discovery & Profiling: Assist in the analysis of production data models, volumes, and relationships across various corporate banking systems. Support liaison with Operations teams during the discovery phase to understand data characteristics and usage patterns.

• Data Procurement: Execute processes for the secure extraction of production data using specified ETL tools and procedures, adhering to data privacy and security regulations.

• Data Masking & Obfuscation: Apply defined data masking and obfuscation techniques to sensitive fields, ensuring data privacy and regulatory compliance (e.g., GDPR, CCPA) while maintaining data integrity for effective testing. Collaborate with Operations and Information Security as required.

• Meaningful Dataset Extraction: Perform extraction of smaller, highly focused, and meaningful datasets as requested by QA and development teams, contributing to faster and more efficient testing.

• Synthetic Data Generation: Generate synthetic data based on predefined requirements for critical testing scenarios, including negative testing, edge cases, performance testing, and where production data is insufficient or unavailable.

• Data Refresh & Versioning: Perform periodic or on-demand data refreshes in lower environments, ensuring test environments reflect realistic and up-to-date production conditions. Assist in managing versioning of test data sets.

• Data Provisioning & Self-Service Support: Support the implementation and maintenance of mechanisms for Quality Assurance (QA) and Development (Dev) teams to provision test data independently. Provide guidance and support to users of test data self-service platforms.

• Documentation & Reporting: Maintain comprehensive documentation of test data processes, data models, and masking rules. Generate reports on test data availability, usage, and quality.

• Tooling & Automation Support: Assist in the evaluation, implementation, and maintenance of Test Data Management (TDM) tools and technologies, contributing to the automation of data provisioning, masking, and refreshing processes.

• Stakeholder Collaboration: Work closely with Development, QA, Operations, and Business Analysts to understand their data requirements and facilitate timely test data delivery.

Your skills and experience

• 9+ years of experience in Test Data Management (TDM), Data Management, or a related data-centric role, preferably within the financial services industry.

• Proven experience with data masking, data subsetting, and synthetic data generation techniques and tools.

• Strong understanding of relational databases (e.g., Oracle, SQL Server, DB2) and SQL.

• Familiarity with ETL tools and data integration concepts.

• Solid understanding of data privacy regulations (e.g., GDPR, CCPA) and information security principles.

• Experience with test automation frameworks and methodologies (e.g., Agile, DevOps).

• Excellent analytical, problem-solving, and communication skills.

• Ability to work effectively in a fast-paced, complex, and highly regulated environment.

• Strong leadership qualities with the ability to influence and collaborate across diverse teams.

Preferred Skills:

• Hands-on experience with specific TDM tools (e.g., Delphix, Broadcom Test Data Manager, Informatica Test Data Management).

• Knowledge of Corporate Banking products and processes (e.g., Payments, Trade Finance, Lending, Securities Services).

• Experience with scripting languages (e.g., Python, Perl, Shell) for data manipulation and automation.

• Familiarity with cloud-based data platforms and services.

How we’ll support you

• Training and development to help you excel in your career

• Coaching and support from experts in your team

• A culture of continuous learning to aid progression

• A range of flexible benefits that you can tailor to suit your needs

About us and our teams

Please visit our company website for further information:

https://www.db.com/company/company.html

We strive for a culture in which we are empowered to excel together every day. This includes acting responsibly, thinking commercially, taking initiative and working collaboratively.

Together we share and celebrate the successes of our people. Together we are Deutsche Bank Group.

We welcome applications from all people and promote a positive, fair and inclusive work environment.