Database/ETL Test Engineer

1 week ago

Boston, MA, United States My3Tech Inc Full time
Position Summary
CHIA is seeking a skilled Database/ETL Test Engineer to work alongside our other talented test engineers and developers within CHIA's Data Operations and Technology (DOT) group. The tester's duties will include performing key testing functions in the data product release process. In this role, the candidate will collaborate with colleagues in DOT to design and create manual and automated tests to validate data sources, extraction of data, the application of transformation logic, and loading data into target tables in an Azure cloud database.
Responsibilities
  • Create and execute test cases based on test strategy and test plans as defined by business requirement documents and ETL design documents.
  • Test ETL processes and Data Warehouse components
  • Execute backend data-driven tests
  • Create strategies and test cases for data applications
  • Provide guidance to other team members as needed
  • Identify issues pertaining to data submissions or ETL transactions during the creation of data warehouses. Be able to discuss these issues with DBA's, assist with remediation strategies, and help devise timelines for correction
  • Define and track quality assurance metrics such as defects, defect counts, test results and test status.
  • Document all problems using CHIA's bug tracking tool and assist in their resolution.
  • Test for continuity and integrity of data loaded from migrated ETL jobs and target DB System


Qualifications
The ideal candidate will have: - A Bachelor's degree in computer science, information technology, or related field.
- Senior SQL programmer with experience querying LARGE volumes (terabytes) of health data, medical claims, dental claims, pharmacy claims and / or eligibility data
- Experience working with SQL Server, PostGresSQL, Snowflake, Talend Data Fabric and IBM DataStage.
• Experience with Agile Software Development & Testing methods for deployment in cloud environments, preferably MS Azure.

Required Skills : - A Bachelor's degree in computer science, information technology, or related field. - Senior SQL programmer with experience querying LARGE volumes (terabytes) of health data, medical claims, dental claims, pharmacy claims and / or eligibility data - Experience working with SQL Server, PostGresSQL, Snowflake, Talend Data Fabric and IBM DataStage. • Experience with Agile Software Development & Testing methods for deployment in cloud environments, preferably MS Azure.
Background Check :Yes
Drug Screen :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :No
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :
Master Job Title :
Branch Code :

  • ETL testing

    3 days ago

    Boston, MA, United States CData Software Full time

    Requirement ID: 10203658 Posted On: Aug-06-2025 Role name: Lead Role Description: 1. ETL testing with technology that includes Oracle, Informatica,Snowflake.2.Skills in DBT tools, writing advanced SQL, macro creation.3.Reports testing skills in TIBCO, Power BI.4. Working in matrix organization with multivendor situations.5. Working experience with pharma...

  • ETL testing

    1 week ago

    Boston, MA, United States CData Software Full time

    Requirement ID: 10203658 Posted On: Aug-06-2025 Role name: Lead Role Description: 1. ETL testing with technology that includes Oracle, Informatica,Snowflake.2.Skills in DBT tools, writing advanced SQL, macro creation.3.Reports testing skills in TIBCO, Power BI.4. Working in matrix organization with multivendor situations.5. Working experience with pharma...

  • ETL Data Engineer

    5 days ago

    Boston, MA, United States Apolis Full time

    SQL Developer+ ETL data engineer Location: Boston, MA - Hybrid: 1 week onsite one week remote. Job Description Skills - SQL Developer , ETL data engineer 1. Data modelling 2. ETL jobs 3. Data Engineer with Python 4. Oracle

  • ETL Data Engineer

    2 weeks ago

    Boston, MA, United States Apolis Full time

    SQL Developer+ ETL data engineer Location: Boston, MA - Hybrid: 1 week onsite one week remote. Job Description Skills - SQL Developer , ETL data engineer 1. Data modelling 2. ETL jobs 3. Data Engineer with Python 4. Oracle

  • ETL Data Engineer

    1 week ago

    Boston, MA, United States Apolis Full time

    SQL Developer+ ETL data engineer Location: Boston, MA - Hybrid: 1 week onsite one week remote. Job Description Skills - SQL Developer , ETL data engineer 1. Data modelling 2. ETL jobs 3. Data Engineer with Python 4. Oracle

  • ETL/ODI Developer

    1 week ago

    Boston, MA, United States ShiftCode Analytics Full time

    ETL/ODI DEVELOPER 6+ MONTHS CONTRACT GREATER BOSTON, MA HYBRID (2-3 DAYS/WEEK) VISA- NO CPT/H1B CLIENT DOMAIN- IT Looking for OAS experience, and preference given to people with Oracle cloud experience Position Specifics 1. Experience with ODI 12C 2. Experience in Data warehousing 3. Strong Communication Skills 4. Work directly with users to...

  • ETL Test Lead

    6 days ago

    Boston, MA, United States Diverse Lynx Full time

    1. ETL testing with technology that includes Oracle, Informatica,Snowflake. 2.Skills in DBT tools, writing advanced SQL, macro creation. 3.Reports testing skills in TIBCO, Power BI. 4. Working in matrix organization with multivendor situations. 5. Working experience with pharma companies with good CSV experience executing both GxP and non GxP...

  • ETL Test Lead

    1 week ago

    Boston, MA, United States Diverse Lynx Full time

    1. ETL testing with technology that includes Oracle, Informatica,Snowflake. 2.Skills in DBT tools, writing advanced SQL, macro creation. 3.Reports testing skills in TIBCO, Power BI. 4. Working in matrix organization with multivendor situations. 5. Working experience with pharma companies with good CSV experience executing both GxP and non GxP...

  • Data engineer

    1 day ago

    Boston, MA, United States RIT Solutions, Inc. Full time

    Senior Data Engineer - Remote role Seeking an experienced Data Engineer - Need strong skills in Azure Data Factory & Databricks. Refactoring applications from AWS to Azure. (MySQL, EDI Protocols nice to have from a healthcare perspective) - Need to be able to create data pipelines using ADF. Python, Pyspark great to have. Transitioning/refactoring from PHP...

  • IICS Developer

    1 week ago

    Boston, MA, United States RIT Solutions, Inc. Full time

    Title- IICS Developer (ETL/Informatica) Location-IDEALLY HYBRID IN BOSTON Duration- 12 MONTHS Job Description Build application using IICS as ETL Experience in developing new using AWS services like S3, Lambda, SNS, Kafka etc Experience in building high performing and scalable data ingestion patterns to support multiple batch processing and...