Sr Specialist - Data Engineering

Requirements & Design Review: Review business requirements, source-to-target mappings, and technical design documents to identify validation needs, test coverage gaps, and quality risks, and provide timely engineering feedback.

• Test Planning & Scenario Coverage: Review requirements, source-to-target mappings, and technical designs to identify test scenarios, edge cases, validation rules, and quality risks.
• Data Testing & Validation: Write and execute SQL-based data validations, reconcile source and target data, validate transformation logic, support functional and regression testing, and help resolve defects through root-cause analysis.
• Test Automation: Develop, maintain, and enhance automation scripts and reusable test assets to improve validation coverage, repeatability, and release confidence across data engineering workflows.
• AI-Assisted Automation Development: Use AI-assisted tools and techniques responsibly to accelerate development of automation scripts, improve test design efficiency, and strengthen validation productivity while adhering to enterprise engineering and control standards.
• Defect & Release Support: Coordinate with cross-functional teams during test cycles and releases, track defects, validate fixes, and ensure timely completion of assigned testing and quality assurance activities.
• Documentation & Test Standards: Maintain test documentation, validation evidence, reusable QA assets, and engineering artifacts in line with Schwab delivery and control standards.

10+ years of overall experience with strong hands-on expertise in data engineering testing, ETL validation, QA automation, or data warehouse environments.

• Experience working on large-scale data testing or data engineering quality assurance initiatives with strong hands-on ownership of automation development in an Agile delivery model.
• Strong foundation in data validation, defect identification, troubleshooting, and quality engineering best practices across testing lifecycles.
• Ability to work collaboratively across product, development, and QA teams in a fast-paced enterprise setting.

Required Experience

• Hands-on experience in Data Warehouse and ETL testing, validation, or quality engineering, with demonstrated ability to develop automation scripts for test execution, reconciliation, and validation, preferably using IICS or PowerCenter.
• Experience with Google Cloud Platform (GCP) and modern cloud-based data engineering practices.
• Proficiency in SQL, Python, and basic Unix/shell scripting to develop automation scripts and support testing, validation, automation, and troubleshooting.
• Experience using AI-assisted engineering tools to help create, refine, and optimize automation scripts and testing accelerators while applying sound engineering judgment, validation, and governance.
• Experience with Agile delivery tools such as Jira or Rally, with a solid understanding of software development lifecycle practices.
• Strong analytical, troubleshooting, defect diagnosis, test evidence review, and root-cause analysis skills.
• Ability to manage priorities independently, communicate clearly, and deliver high-quality work within tight timelines.
• Addresses QA challenges by applying best practices in testing and compliance.

• Analytical Thinking - Approaching a problem by using a logical, systematic, sequential approach
• Thoroughness - Ensuring that one's own and other's work and information are complete and accurate

Careful preparation for meetings and presentations

Following up with others to ensure that agreements and commitments have been fulfilled

• Oral Communication - Expressing oneself clearly in conversations and interactions with others
• Results Orientation - Focusing on the desired end result of one's own or one's units work

Setting challenging goals, focusing effort on the goals, and meeting or exceeding them

• Personal Credibility - Demonstrated concern that one be perceived as responsible, reliable, and trustworthy
• Quality Assurance Testing - Confirming the integrity and reliability of business operations through rigorous testing and compliance verification

At Schwab India, you're empowered to shape your future. We support your growth through meaningful work, continuous learning, and a culture rooted in trust and collaboration - so you can build the skills to make a lasting impact. Our benefits are designed to care for your wellbeing, your family, and your long-term financial security.

Our base benefits, wellbeing, and total rewards include:

• Competitive compensation and retirement programs including Employee Provident Fund (EPF), Gratuity, and optional National Pension System (NPS) contributions
• Robust Paid Time Off, including annual/privilege leave, sick and casual leave, public holidays, maternity/paternity leave, and more
• Education assistance for continued learning to help you grow
• Comprehensive medical insurance with Outpatient Department (OPD) services, including vaccination, pharmacy, dental, and vision coverage
• Annual reimbursement for health check-ups and mental health support through our Employee Assistance Program (EAP)
• Childcare (creche) reimbursement for eligible employees
• Transportation and meal benefits that support your day-to-day work
• Group life, personal accident, and critical illness insurance