Hiring ETL Tester For Noida/Gurgaon/Pune/Chennai- Only immediatejoiner

Experience :- 5 to 9 yrs

Skills :- ETL Tester, Database testing, DWH testing.

Location :- Delhi/NCR /Pune /Chennai

Work location :- (Noida-sec-142, Guru gram, Pune- Kalyani Nagar)

Shift timings :- 12 :30 PM to 9 :30 PM

Work Mode :- Hybrid (3 Days from office - Tues to Thursday)

Job Description: Senior Data Quality Assurance Engineer

Job Summary:

We are seeking a highly skilled and experienced Senior Data Quality Assurance Engineer with 5-10 years of dedicated experience in data testing using SQL. The ideal candidate will possess deep domain expertise in Risk and Finance IT, ensuring the integrity, accuracy, and reliability of critical financial data. This role requires a strong analytical mindset, meticulous attention to detail, and the ability to work collaboratively within a fast-paced environment. A key requirement is the availability to provide overlap with EST hours to facilitate seamless collaboration with our global teams.

Key Responsibilities:

• Data Testing Strategy & Execution: Design, develop, and execute comprehensive test plans and test cases for data-centric applications, ETL processes, data warehouses, data lakes, and reporting solutions.
• SQL-Driven Validation: Utilize advanced SQL queries to perform complex data validation, data reconciliation, data integrity checks, and data quality assurance across various financial data sources.
• ETL Testing: Conduct thorough testing of ETL (Extract, Transform, Load) processes, ensuring data is accurately extracted, transformed according to business rules, and loaded correctly into target systems.
• Data Quality Assurance: Implement and monitor data quality checks, identify data discrepancies, anomalies, and inconsistencies, and work with development and business teams to resolve issues.
• Performance Testing (Data Focus): Contribute to performance testing efforts for data pipelines and database operations, ensuring optimal query and data load performance.
• Test Data Management: Create and manage robust test data sets for various testing phases, including positive, negative, and edge case scenarios.
• Defect Management: Identify, document, track, and re-test defects in data, collaborating closely with development and data engineering teams for timely resolution.
• Documentation & Reporting: Maintain clear and concise documentation of test plans, test cases, test results, and data quality reports. Provide regular status updates to stakeholders.
• Collaboration: Work effectively with business analysts, data architects, data engineers, and project managers to understand data flows, business requirements, and ensure data quality standards are met.
• Process Improvement: Proactively identify opportunities for process improvements in data testing methodologies and tools.
• Global Team Collaboration: Provide consistent overlap with EST working hours (until noon EST) to facilitate effective communication and collaboration with US-based teams.

Required Skills & Experience:

• Experience: 5-10 years of hands-on experience in Data Quality Assurance, Data Testing, or ETL Testing roles.
• SQL Expertise:
• Advanced proficiency in SQL: Ability to write complex queries, subqueries, analytical functions (Window functions), CTEs, and stored procedures for data validation, reconciliation, and analysis.
• Experience with various SQL databases (e.g., SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, BigQuery).
• Strong understanding of database concepts: normalization, indexing, primary/foreign keys, and data types.
• Data Testing Methodologies: Solid understanding of data warehousing concepts, ETL processes, and various data testing strategies (e.g., source-to-target mapping validation, data transformation testing, data load testing, data completeness, data accuracy).
• Domain Expertise:
• Strong understanding and proven experience in Risk and Finance IT domain: Familiarity with financial data (e.g., trading data, market data, risk metrics, accounting data, regulatory reporting).
• Knowledge of financial products, regulations, and risk management concepts.
• Analytical & Problem-Solving Skills: Excellent ability to analyze complex data sets, identify root causes of data issues, and propose effective solutions.
• Communication: Strong verbal and written communication skills to articulate data issues and collaborate with diverse teams.
• Time Zone Overlap: Proven ability and willingness to provide consistent working hour overlap until noon EST to collaborate with teams in the Eastern Standard Time zone.

Preferred Qualifications (Plus Points):

• Python Knowledge:
• Experience with Python for data manipulation, scripting, or automating data quality checks.
• Familiarity with data processing libraries (e.g., Pandas, NumPy).
• Experience with big data technologies (e.g., Hadoop, Spark) and cloud data platforms (AWS, Azure, GCP).
• Knowledge of data visualization tools (e.g., Tableau, Power BI) for reporting data quality metrics.
• Experience with automated testing frameworks for data validation.
• Familiarity with CI/CD pipelines in a data context.
• Certifications in SQL, Cloud Data Engineering, or relevant financial domains.

Notice Period :- Immediate to 15 Days Joiners