<p>Skill: Data Test Lead</p> <p>Must Have Technical/Functional Skills:</p> <p>Required Skills (Mandatory):</p> <ul> <li>Strong hands-on expertise in Python and SQL. </li><li>Extensive experience in ETL testing and data pipeline validation. </li><li>Deep understanding of ETL architecture and data warehousing concepts. </li><li>Proven ability in root cause analysis of data issues. </li><li>Strong communication and stakeholder management skills. </li><li>Experience leading data testing or QA teams </li></ul> <p>Preferred Skills (Good to Have):</p> <ul> <li>Experience with SAS. </li><li>Familiarity with ETL tools (Informatica, Talend, SSIS). </li><li>Knowledge of data orchestration tools (Airflow). </li><li>Exposure to cloud data platforms (AWS, Azure, GCP). </li><li>Experience with test automation frameworks </li></ul> <p>Domain Expertise:</p> <ul> <li>Strong understanding of Banking and Financial Services </li></ul> <p>Experience working with:</p> <ul> <li>Financial data systems. </li><li>Regulatory and compliance requirements. </li><li>Data reconciliation and reporting. </li></ul> <p>Key Competencies:</p> <ul> <li>Leadership and decision-making. </li><li>Strong analytical and problem-solving skills. </li><li>Attention to detail and data accuracy. </li><li>Effective communication and collaboration. </li><li>Ability to manage multiple priorities in fast-paced environments </li></ul> <p>Roles & Responsibilities:</p> <p>Key Responsibilities:</p> <ul> <li>Leadership & Delivery. </li><li>Lead the Data/ETL Testing (EDT) team and own end-to-end quality deliverables. </li><li>Drive testing strategy, planning, execution, and reporting across projects. </li><li>Act as the primary point of accountability for data quality and pipeline validation. </li><li>Mentor team members in Python, SQL, and ETL testing best practices. </li></ul> <p>Data Testing & Technical Oversight:</p> <p>Oversee quality across all phases:</p> <ul> <li>Requirement analysis. </li><li>Test design and scripting. </li><li>Test execution and reporting. </li><li>Lead ETL/data pipeline validation, ensuring data accuracy, completeness, and consistency.. </li></ul> <p>Use Python and SQL for:</p> <ul> <li>Data validation and reconciliation.\ </li><li>Automation of test cases. </li><li>Data profiling and analysis. </li><li>Conduct and lead root cause analysis (RCA) for data issues and drive permanent fixes. </li><li>Validate data transformations, mappings, and business rules. </li></ul> <p>Risk Identification & Quality Assurance:</p> <ul> <li>Identify gaps, ambiguities, and inconsistencies in data flows, UI, and workflows. </li></ul> <p>Highlight risks related to:</p> <ul> <li>Technical debt. </li><li>Data quality issues </li><li>Schedule slippage </li><li>Ensure adherence to data governance, compliance, and quality standards, especially in Banking & Finance context. </li></ul> <p>Planning & Governance:</p> <ul> <li>Estimate and manage the testing effort and resource allocation. </li><li>Coordinate with Shared Services teams for testing needs. </li><li>Manage PLC checkpoints, traceability, and test coverage metrics. </li><li>Perform test result triage and ensure timely defect resolution. </li><li>Provide regular updates on application/project health and data quality metrics. </li><li>Collaboration & Communication </li></ul> <p>Build strong partnerships with:</p> <ul> <li>Tech Leads. </li><li>Project Managers </li><li>Business Analysts </li><li>Data Engineers </li></ul> <p>Actively participate in:</p> <ul> <li>Grooming sessions. </li><li>Sprint planning & status meetings </li><li>Lead the testing communication plan, ensuring transparency with stakeholders. </li><li>Translate banking/business requirements into data validation scenarios </li></ul> <p>Salary Range - $100,00-$120,000 a year</p> <p>TCS Employee Benefits Summary:</p> <ul> <li>Discretionary Annual Incentive. </li><li>Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans. </li><li>Family Support: Maternal & Parental Leaves. </li><li>Insurance Options: Auto & Home Insurance, Identity Theft Protection. </li><li>Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement. </li><li>Time Off: Vacation, Time Off, Sick Leave & Holidays. </li><li>Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing. </li></ul>