BI and ETL Tester

BI & ETL Tester

Key Responsibilities

1. ETL / Data Pipeline Testing

• Validate end-to-end ETL workflows including

  data extraction, transformation, and loading

  .
• Perform

  source-to-target data validation

  , record counts, reconciliation, schema checks, and transformation logic checks.
• Test data ingestion from multiple sources (databases, files, SAP, cloud platforms).
• Verify scheduling, dependencies, and error-handling processes in ETL jobs.
• Conduct regression, functional, and sanity testing for data loads.

2. BI / Reporting Testing

• Validate BI reports and dashboards for

  accuracy, formatting, filters, drill-downs, KPIs, and aggregations

  .
• Compare visual outputs with backend data using SQL queries.
• Test performance, data refresh cycles, row-level security, and report-level access.

3. SQL & Data Quality Validation

• Write complex SQL queries to validate business rules, calculations, and data transformations.
• Identify data issues, anomalies, and integrity gaps.
• Collaborate with Data Engineers, BI Developers, and Data Analyst to resolve defects.

4. Test Planning & Execution

• Create detailed

  test plans, test cases, test scenarios

  , and acceptance criteria.
• Perform manual testing and assist in setting up

  automated testing frameworks

  (e.g., Python, PyTest, dbt tests).
• Document defects in tools like

  JIRA

  and follow through to closure.
• Participate in sprint planning, reviews, and Agile ceremonies.

Required Skills & Experience

• 5–10+ years of BI/ETL testing or QA experience.
• Strong SQL skills (joins, window functions, aggregations, CTEs).
• Experience testing ETL tools such as: Airflow
• Experience with BI tools:

  • Power BI, SAP BO

    , etc.
• Understanding of data warehousing (Star/Snowflake schema, dimensions, facts).
• Knowledge of cloud data platforms ( GCP is a plus).
• Familiarity with Agile/Scrum methodology.
• Experience in defect management and test documentation tools.

Preferred Qualifications

• Experience with SAP source systems (SAP ECC, S/4HANA, SAP BW, SAP IBP) for data validation.
• Exposure to big data technologies (BigQuery).
• Automation experience using Python or SQL-based frameworks.
• Knowledge of CI/CD pipelines for data testing.
• Experience with version control (Git).

Soft Skills

• Strong analytical and problem-solving abilities.
• Excellent communication with business and technical teams.
• Ability to work independently and manage multiple assignments.
• Detail-oriented with a focus on data accuracy and quality.