Full-Time ETL Tester
Bluefish Technologies is hiring a remote Full-Time ETL Tester. The career level for this job opening is Expert and is accepting USA based applicants remotely. Read complete job description before applying.
Bluefish Technologies
Job Title
Posted
Career Level
Career Level
Locations Accepted
Share
Job Details
100% REMOTE
Snowflake/Informatica experience gets bonus points.
We seek a detail-oriented and experienced ETL (Extract, Transform, Load) Testing Contractor to join our team. The ETL Testing Contractor will validate data sources, extract data, apply transformation logic, and load the data into the target systems. The ideal candidate will have a strong understanding of database structures, theories, principles, and practices and hands-on experience with ETL processes and testing methodologies.
Key Responsibilities:
Collaborate with business analysts, data architects, and ETL developers to understand data requirements and design test cases.
Develop and execute test plans, test cases, and test scripts for ETL processes.
Validate source data and ensure data quality and integrity during the extraction, transformation, and loading.
Identify, analyze, and document defects, questionable functions, errors, and inconsistencies in data outputs.
Perform data reconciliation to verify that data is accurately processed and loaded into the target systems.
Work with large datasets and complex models to understand data lineage and transformations.
Execute backend data-driven tests to ensure the accuracy of ETL processes.
Utilize SQL queries and other tools to perform data analysis and validation.
Report test results, track and manage defects, and work with the development team to resolve issues.
Ensure compliance with HIPAA, PHI, PII, data governance, and security requirements.
Maintain documentation of test results to assist in debugging and modifying software.
Qualifications:
Bachelor's degree in Computer Science, Information Technology, or a related field experience.
Minimum of 3 years of experience in ETL testing or a similar role.
1+ years' experience with ETL tools such as Informatica, Talend, DataStage, or similar.
Strong knowledge of SQL and experience with relational databases (e.g., SQL Server, Oracle, MySQL).
3+ years' experience in writing complex SQL queries for data validation and testing.
Excellent analytical, problem-solving, and communication skills.
Understanding of data warehousing concepts and methodologies.
Ability to work independently as well as collaboratively within a cross-functional team.
Nice to have:
Cloud testing experience or understanding of cloud computing services like Azure.
Experience with Snowflake.
Experience working on healthcare data.
Knowledge of scripting languages (e.g., Python, Shell).