Database Test Engineer

2 months ago


Boston, United States Equiliem Full time

Our client has an opening for a Database Test Engineer to join their Data Operations and Technology group in Boston, MA


This position is hybrid, candidates must be local to the Boston area and able to work onsite Tuesdays and Wednesdays.

Position Summary

Our client is seeking a skilled Database/ETL Test Engineer to work alongside our other talented test engineers and developers within theirData 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.
  • Seasoned SQL programmer with experience querying LARGE volumes (terabytes) of health data, preferably medical claims, dental claims, pharmacy claims and eligibility data.
  • Experience working with large scale Database Systems like SQL Server, PostGresSQL, Snowflake, etc., and ETL tools like Talend Data Fabric and IBM DataStage.
  • Experience with Agile Software Development & Testing methods for deployment in cloud environments, preferably MS Azure.
  • Five or more years of relevant experience testing backend applications, focusing on complex SQL queries.
  • Experience analyzing ETL mapping documents to design test plans for validating ETL code.
  • Ability to create SQL scripts based on ETL mapping documents.
  • Ability to create and execute strategies and test cases for applications that use ETL components.
  • Expertise in Database testing with excellent SQL skills.
  • Data warehouse testing experience.
  • Hands on experience in relational databases and database architecture.
  • Hands on experience interpreting and understanding data model and ER diagrams.

Familiarity with data visualization and business intelligence tools such as Tableau and Power BI will be an advantage but is not required



  • Boston, United States Dice Full time

    Dice is the leading career destination for tech experts at every stage of their careers. Our client, Apex Systems, is seeking the following. Apply via Dice today! Job#: 2038904 Job Description: Apex Systems is a world class technology services business that incorporates industry insights and experience to deliver solutions that fulfill our clients' digital...


  • Boston, United States JobRialto Full time

    Position Summary CHIA is seeking a skilled Database/ETL Test Engineer to work alongside our other talented test engineers and developers within Client's Data Operations and Technology 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...


  • Boston, United States Saviance Full time

    Informatica Database EngineerRemote--from India- work until 10pmAbout BigRio: BigRio is a remote-based, technology consulting firm with headquarters in Boston, MA. We deliver software solutions ranging from: custom development, software implementation, data analytics, and machine learning/AI integrations. We are a one-stop shop that attracts clients from a...


  • Boston, United States Optomi Full time

    JOB DESCRIPTION:The Database Engineering team is responsible for managing the company's public and private cloud databases and responsible for the design, build, and operational aspects of the database.The Director Database Engineering is responsible for leading the database team and will be responsible for the strategy, design, implementation, and...

  • Test Engineer

    2 weeks ago


    Boston, United States Apex Systems Full time

    Position Title: Test Support EngineerLocation: North Reading, MAShift: 2nd Shift - 3PM to 11:30PM (Monday - Friday)The Manufacturing Test Support Engineer addresses a wide array of different problems that the work will never feel stale or routine. You are going to be the first responder to issues that impact the test systems for the drive unit production...


  • Boston, United States Motion Recruitment Full time

    A leading provider of investment and financial services software is seeking an experienced Lead Database Platform Engineer to join their team. In this role, you will be responsible for designing, implementing, and optimizing cloud-based Database-as-a-Service solutions. Your expertise in Golang and scripting languages will be essential as you develop...


  • Boston, United States NavitsPartners Full time

    Job DescriptionJob DescriptionDatabase Systems Support EngineerResponsibilities:Manage database installations, upgrades, and administration.Ensure operational continuity for databases and related services.Monitor system performance to diagnose and address issues.Implement and manage data backup and recovery strategies.Secure databases from unauthorized...


  • Boston, Massachusetts, United States SS&C Technologies Holdings Full time

    Job Overview Position Title: Senior Software QA EngineerLocation: Hybrid RoleAbout the Team:Join a pioneering team at SS&C Technologies Holdings, a leader in property management technology, providing comprehensive solutions for commercial, office, retail, and residential properties. Our platform seamlessly integrates lease administration, property...


  • Boston, United States SRI Tech Solutions Inc. Full time

    Job Description: Primary Skillset = Web and API PentestSecondary = Splunk, B2B security architectureProven expertise as an Application Security Engineer or similar roleExperience in conducting web application penetration testing and API PentestingExperience with security assessment techniques such as SCA, static code analysis(SAST) , dynamic application...


  • Boston, United States SRI Tech Solutions Inc. Full time

    Job Description: Primary Skillset = Web and API PentestSecondary = Splunk, B2B security architectureProven expertise as an Application Security Engineer or similar roleExperience in conducting web application penetration testing and API PentestingExperience with security assessment techniques such as SCA, static code analysis(SAST) , dynamic application...


  • Boston, United States The Cervantes Group Full time

    Role DescriptionThe Jr. Database Administrator is responsible for the creation and maintenance of Oracle and DB2 databases for test, development and production environments. This person will be helping to manage, support and administrate databases and ensure data recovery and integrity. The ideal person can conduct performance assessments and database tuning...


  • Boston, United States The Cervantes Group Full time

    Role DescriptionThe Jr. Database Administrator is responsible for the creation and maintenance of Oracle and DB2 databases for test, development and production environments. This person will be helping to manage, support and administrate databases and ensure data recovery and integrity. The ideal person can conduct performance assessments and database tuning...


  • Boston, United States Actalent Full time

    Job Title: Electrical Test EngineerJob Description We are seeking an Electrical Test Engineer to develop and maintain test set software for electronic components of Radar systems. You will develop instrumentation device drivers for new test equipment and update existing software to correct deficiencies or incorporate new test techniques. You will interface...


  • Boston, United States Actalent Full time

    Job Title: Electrical Test EngineerJob DescriptionWe are seeking an Electrical Test Engineer to develop and maintain test set software for electronic components of Radar systems. You will develop instrumentation device drivers for new test equipment and update existing software to correct deficiencies or incorporate new test techniques. You will interface...

  • Database Architect

    1 week ago


    Boston, Massachusetts, United States Booz Allen Hamilton Full time

    About the RoleWe are seeking a highly skilled Database Architect to join our team at Booz Allen Hamilton. As a key member of our database development team, you will be responsible for designing, developing, and implementing database architectures that meet the needs of our clients.Key ResponsibilitiesDesign and Develop Database Architectures: Lead the design...

  • Database Architect

    3 weeks ago


    Boston, United States Blue Ocean Ventures Full time

    Years of experience needed – · 8-12+ years overall work-experience required· 5+ years in data architect level roles across engineering / solutioning / consulting / designTechnical Skills: · Hands-on expertise to come up with Enterprise-level Data Strategy, Design Databases to support enterprise applications and physical data modelling according to...

  • Database Architect

    2 weeks ago


    Boston, United States Blue Ocean Ventures Full time

    Years of experience needed – · 8-12+ years overall work-experience required· 5+ years in data architect level roles across engineering / solutioning / consulting / designTechnical Skills: · Hands-on expertise to come up with Enterprise-level Data Strategy, Design Databases to support enterprise applications and physical data modelling according to...


  • Boston, United States Platform Recruitment Full time

    My client is an established MedTech company that's starting a greenfield project developing a computer vision-powered surgical assistance solution.They are looking for two Principle Test Engineers to join their engineering team.Key Responsibilities:Automated Testing: Develop and maintain automated test frameworks for robotic systems, with a strong emphasis...


  • Boston, United States Platform Recruitment Full time

    My client is an established MedTech company that's starting a greenfield project developing a computer vision-powered surgical assistance solution.They are looking for two Principle Test Engineers to join their engineering team.Key Responsibilities:Automated Testing: Develop and maintain automated test frameworks for robotic systems, with a strong emphasis...


  • Boston, United States Judi by AG Mednet, Inc. Full time

    About the Company: AG Mednet's mission is to speed medical innovation from testing to patients. Our software platform, Judi, manages collaboration between all clinical trial constituencies by automating the complex processes needed to ensure they are fast, effective, predictable, reproducible, and compliant.Overview : You will work design, maintain, and...