JD for ETL Tester The ETL Tester is responsible for validating data extraction, transformation, and loading (ETL) processes across data warehouse and analytics platforms. The role ensures data accuracy, completeness, integrity, and compliance by designing and executing test cases, performing SQL-based validations, and identifying defects throughout the ETL lifecycle. Key Responsibilities Test Planning & Execution • Analyze source-to-target mappings, business requirements, and technical specifications. • Design and develop ETL test cases, test scenarios, and validation strategies. • Execute ETL, integration, system, regression, and end-to-end testing. • Validate data movement across source systems, staging layers, and target data warehouses. • Verify data transformation rules and business logic implementation. Data Validation • Develop and execute SQL queries for data reconciliation and validation. • Validate data quality, completeness, consistency, accuracy, and referential integrity. • Verify primary keys, foreign keys, constraints, indexes, and data standards. • Validate Slowly Changing Dimensions (SCD), facts, dimensions, star schemas, and snowflake schemas. Defect Management • Identify, document, and track defects using tools such as Jira. • Work closely with ETL developers and business teams to reproduce and resolve issues. • Participate in defect triage meetings and retesting activities. • Verify bug fixes and perform regression testing. Collaboration & Compliance • Collaborate with Business Analysts, Data Architects, ETL Developers, and Data Engineers. • Review ETL design documents, data mappings, and technical specifications. • Ensure adherence to SDLC, testing standards, validation processes, and data governance requirements. • Escalate risks, blockers, and critical issues to project leads.
At Hexaware, we're not just a global technology and business process services company; we're a community of 31,600+ Hexawarians dedicated to one singular purpose: creating smiles through the power of great people and technology. With a presence in 58 offices across 28 countries, we empower enterprises worldwide to embark on their digital transformation journey with unparalleled scale and speed.
As an employer, we're more than just a workplace. We put our people first, foster diversity and inclusivity, and prioritize their growth through robust learning and development programs. Our culture is a canvas for innovation as we work toward our shared vision of becoming the world’s most loved digital transformation partner.
Exciting, isn’t it? Visit www.hexaware.com to join us in embracing the magic of technology, as we passionately advocate for its potential to transform lives today and shape a brighter future. Together, we'll make the digital world a better place.
