ETL Tester

Greeting from PRI Global.!

Job Description (JD):

Job Title: ETL Tester

Location: Kochi

Work Mode: Hybrid - 2 Days WFO

Project Duration: 6 Months (Strong performers will be considered for full-time conversion after 6 Months or Project will be extended)

Experience: 4+ Years

Notice Period: Immediate to 30 Days

Interview Process: 2 rounds (if needed a F2F will be there)

Key skills: ETL Tester, Data Warehouse Testing, SQL, Informatica, SSIS, Azure Data Factory, Power BI, Tableau, Microsoft Fabric, Source-to-Target, Validation, Data Reconciliation.

Key Responsibilities

Backend / ETL Testing

• Validate ETL processes, data transformations, and data migration activities.
• Perform source-to-target data validation and reconciliation.
• Develop and execute test cases, test scenarios, and test scripts for ETL workflows.
• Validate data quality, completeness, accuracy, and integrity across systems.
• Execute SQL queries to verify data loads and business rule implementations.
• Analyze mapping documents, technical specifications, and data models.
• Identify, log, track, and retest defects through closure.
• Work closely with developers, data engineers, and business stakeholders to resolve issues.

Frontend / Reporting Testing

• Validate reports, dashboards, and visualizations for data correctness.
• Perform functional, integration, regression, and user acceptance testing for BI solutions like PBI, Tableau and MS Fabrics.
• Verify KPIs, metrics, calculations, filters, drill-downs, and dashboard interactions.
• Ensure consistency between backend data sources and frontend reports.
• Validate report performance, usability, and business requirements.

Quality Assurance

• Prepare test plans, test cases, execution reports, and defect reports.
• Participate in requirement reviews and estimation activities.
• Support release validation and production deployment testing.
• Contribute to continuous improvement of testing processes and automation initiatives.

Required Skills

• 6+ years of experience in ETL/Data Warehouse Testing.
• Strong SQL skills with hands-on experience in complex queries and data validation.
• Experience in ETL testing using tools such as Informatica, DataStage, SSIS, Talend, Azure Data Factory, or equivalent.
• Strong understanding of Data Warehousing concepts, Star/Snowflake Schemas, and Data Marts.
• Experience in validating large datasets and complex business transformations.
• Experience in frontend testing of Power BI, Tableau, MS Fabric or similar BI platforms.
• Knowledge of testing methodologies, SDLC, and Agile practices.
• Experience with defect management tools such as JIRA or Azure DevOps.
• Strong analytical, problem-solving, and communication skills.

Note:
If you or someone in your network is looking for a great career opportunity please share your updated CV at meghana.vasanthi@priglobal.com .