Senior Data Analyst- ETL Testing

Test planning: Create a test strategy, plan, and test cases for ETL validation and regression testing.

Data validation: Use SQL queries and ETL tools to ensure data is accurate, complete, and consistent.

Collaboration: Work with business stakeholders, data analysts, and developers to understand requirements.

Defect reporting: Identify, document, and report issues, defects, and risks.

Root cause analysis: Analyze issues that arise during testing and recommend solutions.

Test execution: Perform manual and automated testing.

Data quality: Analyze source data for quality concerns throughout the ETL process.

Test case management: Create and maintain test cases, scripts, and documentation in test management tools.

Test strategy: Develop a test strategy for cloud projects, including platform, application, integration, and UAT testing.

Test case design: Design test cases, including manual and automated scripts.

Test execution and reporting: Perform test execution and report progress.

Defect resolution: Liaise with development and other teams to resolve defects.

Ability to transform complex business logic into SQL or PL/SQL queries.

Define comprehensive test scenarios and acceptance criteria to validate data early in the development process.

Execute both manual and automated tests for new features and regression testing, supporting smooth feature releases.

Lead testing efforts throughout the development lifecycle, ensuring thorough coverage.

Strong expertise in structured testing and quality assurance methodologies, particularly in Analytics Reporting (Dashboard) and ETL testing.

Proficient in writing SQL Queries for data verification against databases like SQL Server.

Skilled in crafting complex SQL queries and determining appropriate testing types (e.g., data validation, regression).

Experience in database skills for data migration testing and test data creation, using tools like SQL Server Management Studio and Oracle Developer.

Familiarity with automated testing tools such as Selenium and testing Web Service APIs is a plus.

Proficiency in Test management tools and methodologies, especially Azure DevOps/JIRA.

Experience with Advanced Data platforms like SNOWFLAKE.

Essential experience with ETL tools like Informatica PowerCenter and databases such as Microsoft SQL Server, Oracle, AWS Athena, and Redshift.

Hands-on experience in software testing, including API testing.

Expertise in Test Planning, Test Design, and Test Execution.

Familiarity with Defect Management Tools, preferably ADO.