Senior ETL / DW tester

As a Senior ETL / BI / DW Tester, your role involves validating end-to-end data flows across ETL pipelines, data warehouses, and Business Intelligence reports/dashboards. Strong SQL skills, understanding of ETL processes, and expertise in testing BI tools are crucial for ensuring accurate data representation and reporting. Key Responsibilities: - Review and analyze business requirements, data mapping documents, and report specifications. - Develop, execute, and maintain test cases, test scripts, and test plans for ETL and BI layers. - Validate ETL workflows for accurate extraction, transformation, and loading of data. - Perform data validation, reconciliation, and integrity checks across source and target systems. - Test BI dashboards, KPIs, visualizations, and reports using tools like Power BI, Tableau, QlikView, Cognos, etc. - Validate report calculations, aggregations, drill-throughs, and filters against business logic. - Write and execute complex SQL queries for backend and front-end data validation. - Conduct functional, regression, system integration, and UAT testing of ETL & BI solutions. - Track and log defects in tools like JIRA, ALM, and collaborate with developers for resolution. - Ensure compliance with data governance, accuracy, and quality standards. - Support automation initiatives for ETL/BI testing wherever possible. Required Skills & Experience: - Bachelor's degree in Computer Science, IT, or related field. - 6 to 10 years of experience in ETL testing, BI testing, or Data Warehouse testing. - Proficiency in SQL including complex queries, joins, stored procedures, etc. - Hands-on experience with ETL tools like Informatica, Talend, SSIS, DataStage, etc. - Experience testing BI/Reporting tools such as Power BI, Tableau, Qlik, Cognos, or MicroStrategy. - Strong knowledge of data warehouse concepts, data modeling (star/snowflake schema), and reporting layers. - Experience with defect tracking tools like JIRA, HP ALM, Bugzilla, etc. - Familiarity with Agile/Scrum methodologies. You will be part of an IT Services and IT Consulting company in Hyderabad, with the opportunity for full-time employment.,