Manager – ETL Testing & Test Data Management

Job Description Summary

Job Description

Leads ETL/Data Testing and Test Data Management initiatives by working closely with SQM, Development, Data, and Business Partners to ensure the delivery of high-quality data and reliable data pipelines. Acquires a deep understanding of data architecture, ETL processes, data flows, and test data requirements to ensure comprehensive and effective testing. Collaborates with development and testing teams to establish data testing strategies, standards, and reusable frameworks that support functional, integration, regression, and end-to-end testing. Identifies opportunities to improve ETL testing and Test Data Management processes and recommends enhancements to testing methods, tools, automation, and frameworks. Drives the adoption of innovative technologies, including AI agents, for test case generation, data validation, anomaly detection, and synthetic test data creation. Collaborates with SQM teams to ensure data testing and test data practices align with SDLC standards and remain reusable across projects. Collaborates with SQM leadership to ensure appropriate allocation of resources across ETL Testing and Test Data Management activities. Works closely with Development, Data, and Business teams to establish priorities and facilitate decisions pertaining to data quality and testing.

Key Responsibilities:

• Lead, mentor, grow ETL Testing and Test Data Management teams, ensuring high performance, clear priorities, and career development for team members.
• Own the end-to-end test strategy for ETL/data pipelines — covering source-to-target validation, transformation logic, data completeness, accuracy, reconciliation, and performance testing.
• Drive data lineage validation and data comparison testing using Ab Initio and oversee testing of Oracle-based ETL jobs built on ODI (Oracle Data Integrator).
• Define and drive the Test Data Management strategy, including data provisioning, sub setting, masking/anonymization, synthetic data generation, and data refresh processes across environments.
• Champion automation-first testing — evaluate, adopt, and build tools/frameworks (including AI-driven/agentic solutions) to reduce manual testing effort and increase test coverage.
• Explore and implement AI agents to automate repetitive data testing tasks such as test case generation, data profiling, anomaly detection, schema drift detection, and synthetic test data creation.
• Partner closely with Data Engineering, BI/Analytics, and Product teams to embed quality checks early in the data pipeline lifecycle (shift-left testing).
• Establish metrics, dashboards, and reporting to track test coverage, defect trends, data quality KPIs, and team productivity.
• Manage stakeholder relationships, set delivery timelines, and ensure testing milestones align with overall project/program schedules.
• Stay current with emerging trends in data quality engineering, test automation, and AI/ML-based testing tools, and bring innovative ideas into the team's roadmap.

Experience and Skills:

• 10+ years of overall experience in QA/Testing, with strong hands-on experience in ETL/Data Testing, SQL, data warehousing concepts, and data integration testing.
• Mandatory hands-on experience with Informatica for building and validating ETL workflows/mappings and performing data integration testing.
• Mandatory hands-on experience with Ab Initio, specifically for data lineage tracking and data comparison across source and target systems.
• Mandatory hands-on experience with Oracle Data Integrator (ODI) for testing and validating Oracle-based ETL jobs and data pipelines.
• 5+ years of experience in Test Data Management, including data masking, subsetting, synthetic data generation, data provisioning, and TDM tools such as Informatica TDM, CA Test Data Manager, or similar.
• Proven experience leading and managing testing teams, including ETL testing, Test Data Management, or cross-functional data quality teams.
• Strong SQL skills and solid understanding of data warehousing, data lakes, and cloud data platforms such as Snowflake, Redshift, BigQuery, Databricks, or similar technologies.
• Demonstrated experience with test automation for data pipelines, including Python/PySpark frameworks, dbt tests, Great Expectations, or similar tools. Exposure to scripting and development of custom testing and automation utilities is preferred.
• Working knowledge of or hands-on experience with CI/CD pipelines and integrating automated data testing into deployment workflows.
• Working knowledge of or hands-on experience adopting AI/agentic solutions for testing, including LLM-based agents for test case generation, data validation, data profiling, anomaly detection, or custom AI-driven QA tooling. Experience piloting or scaling AI-driven testing initiatives is preferred.
• Experience with cloud platforms and native data services such as AWS, Azure, or GCP is preferred.
• Strong analytical and problem-solving skills, with a demonstrated ability to drive process improvements, innovation, and automation in data testing practices.
• Excellent communication and stakeholder management skills, with the ability to collaborate across technical and business teams and present effectively to senior leadership.
• Experience working in Agile/Scrum environments with frequent releases and cross-functional development teams.

Core Competencies:

• Strategic Thinking and Analysis: Identify and evaluate complex issues, problems, opportunities, and organizational needs; analyze information from multiple sources to develop effective strategies and solutions. Anticipate future challenges and opportunities and translate business and technology trends into actionable plans. Ability to develop innovative approaches that improve quality, efficiency, scalability, and productivity.
• Communication and Influence: Communicate clearly and effectively with senior management, business partners, development teams, and technical resources through a variety of media. Tailor communication to the audience, effectively present complex information and recommendations, and influence decisions across organizational boundaries.
• Leadership and People Development: Lead, motivate, and develop teams by establishing clear expectations, priorities, and accountability. Foster collaboration, innovation, and continuous improvement while providing coaching, feedback, and opportunities for professional growth. Build a culture of ownership and high performance.
• Strategic Planning and Execution: Establish priorities and translate organizational objectives into actionable strategies, plans, and measurable outcomes. Effectively manage competing priorities, resources, timelines, and dependencies across multiple projects and teams to ensure successful delivery.
• Exercising Judgment and Decision Making: Evaluate complex situations and risks to determine appropriate courses of action. Make timely, informed, and risk-based decisions using available facts, business objectives, constraints, and probable consequences. Take accountability for decisions and outcomes.
• Technical and Professional Knowledge: Demonstrate advanced technical and professional knowledge in position-related areas and understand how technology, processes, tools, and industry trends impact the organization. Remain current with emerging technologies and identify opportunities to apply new capabilities to improve quality, efficiency, and business outcomes.
• Relationship Management and Collaboration: Build and maintain effective relationships across business, technology, and leadership organizations. Collaborate across organizational boundaries to resolve issues, manage dependencies, gain alignment, and achieve shared objectives.

Licenses/Certifications:

• None required.
  

Education

Work Experience

Certifications

Travel

Workstyle

The total compensation for this position includes base salary or wages, and may include components such as additional compensation (cash or equity), discretionary bonuses, or commissions. This position is eligible for a benefits package that may include medical, dental, and vision; life insurance; critical illness insurance and accident insurance; disability benefits; retirement savings; paid time off (including vacation, holidays, and sick leave); and parental leave.  Eligibility for benefits and specific offerings may vary based on position and employment status. To view more details of the benefits offered, visit Myrjbenefits.com.

At Raymond James our associates use five guiding behaviors (Develop, Collaborate, Decide, Deliver, Improve) to deliver on the firm's core values of client-first, integrity, independence and a conservative, long-term view. 

We expect our associates at all levels to:
•  Grow professionally and inspire others to do the same
•  Work with and through others to achieve desired outcomes
•  Make prompt, pragmatic choices and act with the client in mind
•  Take ownership and hold themselves and others accountable for delivering results that matter
•  Contribute to the continuous evolution of the firm

At Raymond James – as part of our people-first culture, we honor, value, and respect the uniqueness, experiences, and backgrounds of all of our Associates.  When associates bring their best authentic selves, our organization, clients, and communities thrive. The Company is an equal opportunity employer and makes all employment decisions on the basis of merit and business needs.