ETL Tester

Job Title: ETL Tester

Skills: Data Quality Assurance testing, ETL Testing, Manual & Automation Testing, Test Data Generation, DW, Test Scripts, Python, SQL, Cloud-native testing frameworks, CI/CD, Jenkins, Gitlab, Azure DevOps

Experience: 6+ years

Job Location: Atlanta, GA

FTE/ Hybrid

We at Coforge are hiring ETL Tester with the following skillset:

Data Validation and Testing:

• Develop and execute test plans, test cases, and scripts to validate data pipelines, BI reports, dashboards, ETL processes, schemas, tables, stored procedures, queries, jobs and ETL in support of all data lake, data warehouse feeds, functions, data layers and integrations for on-premises and cloud environments.
• Perform through data quality checks, including data completeness, accuracy, consistency, and timeliness.
• Identify, document, and track data defects, and work with data engineers (ETL developers) to resolve issues.
• 4 - 6 years of experience leading and executing Data Quality Assurance testing which includes hands-on experience in manual and automated testing and test data generation for Data Lakes; Data Warehouse models (Star Schemas); ETL; tables; views; cubes; reports; dashboards and inbound/outbound feeds and integrations; applications, and inter-connected systems.

Automation and Continuous Integration:

• Develop automated test scripts using tools like Python, SQL, or cloud-native testing frameworks.
• Integrate automated tests into CI/CD pipelines to ensure continuous testing and monitoring of data quality in real-time.
• Maintain and enhance the automation framework, ensuring it is scalable and adaptable to changing data requirements.

Reporting and Analytics:

• Generate reports on data quality metrics, test coverage, and defect rates, providing insights to drive continuous improvement.
• Develop dashboards and visualizations to track data quality trends over time.

Technical Skills:

• 5+ years proficiency in complex SQL, Python, or any other scripting languages used for data testing/data test automation.
• Direct experience with cloud-based data services such as Azure DevOps, Azure Blob Storage, Azure Data Factory, Cloud Power, etc.
• Familiarity with CI/CD tools (Jenkins, GitLab, etc.) and integrating testing into deployment pipelines.
• Knowledge of data quality frameworks and tools