ETL, Data & Automation Testing

ETL + Automation Testing

Your Key Responsibilities

• Develop comprehensive and detailed test plans for ETL pipelines.
• Design and execute test cases based on source-to-target mapping documents across layers.
• Create and manage UAT test plans and test cases based on existing dashboards, in close collaboration with the client’s analytics team.
• Execute test cycles end-to-end, track defects, manage issue resolution, and support iterative testing cycles.
• Ensure clear communication, coordination, and status tracking across QA, engineering, and business teams.
• Responsible for decision-making, optimizing processes, resource management, and overseeing team management as needed for task execution.

Skills and attributes for success

Testing skills

• Requirement Analysis
• Test Scenario Design
• Test Case Creation and Execution
• User Acceptance Testing (UAT) Support
• Regression Testing
• JIRA/Confluence (any QC tool)
• Agile/Scrum Methodology
• Defect Management
• Stakeholder Communication

Core Power BI Skills

• Power BI Dashboard and Report Testing
• Data Validation and Reconciliation Testing
• DAX Formula Validation
• KPI and Metric Verification
• Visualizations Testing (Charts, Tables, Maps, Cards)
• Filter, Slicer, and Bookmark Validation
• Security Role (RLS) Testing
• SQL Query Writing and Validation

Additional Skills

• Strong Structured Query Language (SQL), including window functions (ETL Skillset)
• Experience testing Streaming or Change Data Capture (CDC) pipelines (ETL Skillset)
• Databricks/Snowflake or Apache Spark (ETL Skillset) - Strong understanding of data migration, data quality, and reconciliation processes.
• Ability to work with large datasets, complex reporting structures, and high-volume test scenarios.
• Robot Framework (Automation Skillset)
• Python/Pyspark (ETL/Automation)

Please let me know if you are interested in this position and send me your resume to netra.s@twsol.com