Hello
Hope you're doing well
Title : Sr ETL / BI Tester
Location : Hyderabad (Hybrid / Remote)
Duration : Contract / Full time
Salary : DOE
NOTE : Working hours 7 : 30 PM to 3 : 30 AM IST
JD : Job Summary :
We are looking for a detail-oriented ETL / BI Tester to join our QA team. The candidate will be responsible for validating end-to-end data flows across ETL pipelines, data warehouses, and Business Intelligence (BI) reports / dashboards. The role requires strong SQL skills, a solid understanding of ETL processes, and expertise in testing BI tools to ensure 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 to ensure accurate extraction, transformation, and loading of data.
- Perform data validation, reconciliation, and data integrity checks across source and target systems.
- Test BI dashboards, KPIs, visualizations, and reports (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.
- Perform functional, regression, system integration, and UAT testing of ETL & BI solutions.
- Track and log defects in defect management tools (e.g., 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 (complex queries, joins, stored procedures, etc.).Hands-on experience with ETL tools (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 in defect tracking tools (JIRA, HP ALM, Bugzilla, etc.).Familiarity with Agile / Scrum methodologies.Preferred Skills :
Exposure to cloud-based data platforms (Snowflake, AWS Redshift, Azure Synapse, GCP BigQuery).Experience with big data ecosystems (Hive, Spark, Hadoop).Knowledge of automation frameworks for data / BI testing (QuerySurge, Selenium with DB, Python scripts).Familiarity with CI / CD pipelines and DevOps processes.Soft Skills :
Strong analytical and problem-solving abilities.Excellent verbal and written communication.Attention to detail and ability to work independently as well as in cross-functional teams.Strong focus on data accuracy, reliability, and quality assurance .Skills Required
Tableau, Informatica, Jira, Bugzilla, Azure Synapse, snowflake , Selenium, Talend, Python, Aws, BigQuery, Hadoop, Power Bi, Redshift, Ssis, Sql, Hive, Gcp, Datastage, Spark, Hp Alm, Cognos, Qlikview, Etl