Senior ETL Test Engineer

Company Description

Power Your Potential with BuzzClan

Since 2013, BuzzClan has run on the vision to empower organizations to reach their full potential through cloud-driven infrastructure and technology solutions. As a leading IT managed services provider and certified partner for industry giants like Oracle, Amazon, Google, Microsoft, and Saviynt, we are reimagining what organizations can achieve. With headquarters in Dallas and offices across the US, Canada, India, and Kenya, our global reach allows us to serve the diverse needs of 100+ public sector clients and 50+ commercial enterprises. Honored as the fastest-growing private company in Dallas by SMU Dallas100, we continue to expand rapidly, recognized on the Inc. 5000 list for the fastest-growing companies in Texas and across America.

Data Tester/ETL Tester with extensive experience in ETL processes and Python testing.

This role involves designing, implementing, and executing test cases to validate ETL processes, data transformations, and integrations. If you have a passion for data quality and a strong background in ETL, Informatica, Azure Data Lake and Python.

Key Responsibilities:

1. Test Planning and Design:

• Collaborate with data engineers, analysts, and other stakeholders to understand data requirements and workflows.
• Develop comprehensive test plans, test cases, and test scripts for ETL processes and data pipelines.

1. ETL Testing:

• Validate data extraction, transformation, and loading processes to ensure data integrity and accuracy.
• Perform data quality checks, data profiling, and data validation against source systems.
• Verify data transformations, aggregations, and business rules applied during ETL processes.

1. Python Testing:

• Write and execute automated tests using Python to validate data processing scripts and analytical models.
• Develop reusable test frameworks and scripts to streamline testing processes.
• Identify and report bugs, inconsistencies, and performance issues in Python-based data processing.
• Develop utilities for Data Recon.

1. Test Execution and Reporting:

• Execute test cases and log defects using test management tools.
• Document test results, generate test reports, and communicate findings to the development and data teams.
• Track and verify defect resolutions, ensuring they are addressed and retested appropriately.