ETL Test Egineer

Incedo Inc.
Fort Mill, SC, United States
Full-time

Role Description :

We are looking for a detail-oriented QA Test Engineer with a strong background in ETL, batch job processes, and data warehousing.

This role is responsible for ensuring the quality, stability, and efficiency of batch job workflows, ETL pipelines, and related data management processes in a legacy environment.

The ideal candidate will have experience with QA methodologies for batch processes, Informatica, PL / SQL development, SQL Server, and data warehousing concepts.

The engineer will also be responsible for automating testing processes and ensuring data accuracy across various stages of the ETL pipeline.

Key Responsibilities :

Design, implement, and execute QA testing strategies for ETL processes and batch jobs, ensuring data accuracy and process reliability.

Develop and run test cases for PL / SQL scripts, SQL queries, and Informatica workflows, focusing on data integrity and performance.

Automate test cases for ETL jobs using relevant testing frameworks and tools.

Monitor and validate batch job performance, identifying issues or bottlenecks in legacy systems.

Collaborate with developers to troubleshoot and resolve issues related to ETL job failures, data inconsistencies, or batch process breakdowns.

Perform root cause analysis and regression testing for reported issues, applying corrective actions to ensure no recurrence.

Ensure proper documentation of test cases, results, and issue resolution processes.

Work closely with database administrators to ensure data workflows are maintained with optimal efficiency.

Required Skills and Experience :

At-least 5+ years of hands-on experience with ETL frameworks, specifically Informatica.

Proficiency in SQL Server and PL / SQL scripting.

Strong understanding of data warehousing concepts and ETL pipelines.

Experience in testing, monitoring, and debugging batch jobs in a legacy environment.

Familiarity with QA methodologies, including automation of test cases for ETL jobs and data pipelines.

Strong problem-solving and analytical skills for debugging and improving batch job workflows.

Preferred Qualifications :

Experience with performance tuning of batch jobs and ETL processes.

Knowledge of cloud platforms (e.g., AWS, Snowflake) for data management and testing.

Familiarity with testing tools and frameworks for automating batch job validations.

6 days ago
Related jobs
Promoted
Incedo Inc.
Fort Mill, South Carolina

Automate test cases for ETL jobs using relevant testing frameworks and tools. We are looking for a detail-oriented QA Test Engineer with a strong background in ETL, batch job processes, and data warehousing. The engineer will also be responsible for automating testing processes and ensuring data acc...

Promoted
Sunbelt Rentals
Fort Mill, South Carolina

Requires Bachelor's degree (or foreign equivalent) in computer science, software engineering, or related engineering field; plus 24 months of experience in job offered, or in a position involving web development. Senior Software Engineer based out of its location in Fort Mill, SC. Senior Software En...

Promoted
NTT DATA
Fort Mill, South Carolina

NTT Data seeks a full time, direct hire Data Analyst for our healthcare customer working remote, W-2, USA. As a Data Analyst for our valued end client, you will:. Oversee database transactions and reconcile discrepancies by validating and correcting data as needed. Maintain database accuracy through...

Promoted
Re:Build Manufacturing
Rock Hill, South Carolina

Practical experience in engineering topics, including design engineering, design for manufacturing, and process engineering. Over 5 years of software engineering experience in geometry-intensive domains such as CAD, CAM, or graphics required. Mechanically focused background in fields such as mechani...

Computer Software Innovations LLC
South Carolina, United States
Remote

Minimum of 3 years of software sales, support, or professional experience in a related industry. Experience in presenting and demonstrating software to users of all levels. Comfortable presenting software in front of executives, supervisors, and end users. Ability to set up the database and demonstr...

CDC Foundation
South Carolina

The Data Engineer will collaborate with data content experts, analysts, data scientists, data modelers, warehouse architects, IT staff and other organization staff to design and implement proposed solutions and architectures that meet the needs of the public health agency. The Data Engineer will app...

Midlands Technical College
Richland County, SC

Specifically, the data coordinator will: assist in generating daily reports pertaining to college enrollment; generate correspondence, mailings, and reports; assist with communications management processing; import application files from multiple sources; track and resolve record integration errors;...

N. Harris Computer Corporation - USA
South Carolina, United States
Remote

NET Software Developer, you will play a crucial role in designing, developing, and maintaining our cutting-edge suite of utility billing and CIS software solutions. NET Software Developer to join our vibrant and dynamic development team. Lead the design, development, and implementation of new featur...

Comporium
Rock Hill, South Carolina

We use IntelliJ, JetBrains, JEE, REST/JSON, ReactJS, Webservices, Hibernate, Apache, Tomcat, SQL. Serve as a Subject Matter Expert to other developers and our User Community as needed. Proficiency in using JAVA, JEE, JSON, JavaScript, SQL. ...

Volaris Group
South Carolina
Remote

Our IEP and Medicaid software, and customer care team help districts maximize participation in Medicaid reimbursement programs and provide exceptional experiences for all students. Bachelor's degree or equivalent experience in computer science, software development. Strong experience in all aspects ...