ETL Data Tester Job at Car-Part.com, Fort Wright, KY

R3JOZ2xLd3lKZTNCZ2UzZGlEemJQRGdxTUE9PQ==
  • Car-Part.com
  • Fort Wright, KY

Job Description

Job Description

Job Description

Primary Purpose: We are seeking a detail-oriented ETL Tester to validate the process of extracting, transforming, and loading (ETL) data from flat files into MySQL databases. The ETL Tester will play a critical role in ensuring data accuracy, integrity, and consistency throughout the ETL pipeline by designing, executing, and maintaining test cases and scripts. The ideal candidate will have a strong understanding of data processing, database management, and QA principles.

Major Tasks and Responsibilities :

1) Test Planning & Strategy: Develop detailed test plans, scenarios, and scripts to validate ETL processes for loading data from flat files into MySQL databases. Write structured Test Plans from specifications conforming to established methodology and standards

2) Data Validation: Perform comprehensive data validation at each stage of the ETL process to ensure data is accurately extracted from flat files, correctly transformed according to business rules, and loaded into the MySQL database without discrepancies.

3) Test Execution: Execute manual and automated tests to validate ETL workflows, including boundary, performance, and load testing.

4) Data Quality Assurance: Identify and document data quality issues, inconsistencies, and anomalies. Validate data mapping, data integrity, and transformations according to business requirements.

5) Troubleshoot Large ETL Systems: Help operate, troubleshoot, and problem solve ETL problems in large systems. This sometimes includes off-hours troubleshooting and maintenance of critical processes.

6) SQL Query Development: Write and execute SQL queries to validate data accuracy and integrity in MySQL databases. Develop complex queries to cross-verify and validate large datasets.

7) Collaboration: Work closely with developers, DBAs, business analysts, and other stakeholders to understand data requirements and present test results.

8) Documentation: Maintain comprehensive documentation of test cases, test results, test scripts, and defect logs.

9) Attend team meetings

10) Take initiative to learn and expand role

11) Perform other tasks and have such other responsibilities as assigned by Car-Part from time to time

Qualifications:

Education: Bachelor’s degree in Computer Science, Information Technology, or a related field.

Proven experience: (2-5 years) as an ETL Tester or QA Engineer with a focus on data validation and database testing. Hands-on experience testing ETL processes involving flat file inputs and MySQL databases. Strong knowledge of SQL and relational databases, particularly MySQL.

Technical Skills: Familiarity with data warehousing concepts and ETL tools. Experience working with Linux/Unix environments. · Knowledge of scripting languages (e.g., Python, Perl) .

 

Company Description

"Best Places To Work In Kentucky" winner 2021, 2022 & 2023. Voted a 2023 "Top Workplace" by the Cincinnati Enquirer.

Car-Part.com is a Blue Ribbon Small Business Award Winning IT Company located in Ft. Wright, KY. We are a leading provider of software and web solutions for auto recyclers in areas such as inventory searching, web design and hosting, promotion, inventory management, and email services. Our products provide auto recyclers with a comprehensive product suite, which assists them in making their inventory available to all potential buyers including body shops, insurance adjusters, core buyers, and retail customers. Car-Part.com provides outstanding customer support while helping recyclers make it easy for their customers to find the best part based on condition, location, availability, brand, and price.

Car-Part.com employees enjoy a great culture, competitive salaries, performance-based bonuses, 401K matching, workplace flexibility, free parking and a casual dress code in a unique software development atmosphere. For full time employees, health care benefits are also available. If you are interested in being part of a high-energy, innovative company, we invite you to submit your resume and explore the opportunities that we have to offer. Be sure to include your salary requirements when applying for this position.

Company Description

"Best Places To Work In Kentucky" winner 2021, 2022 & 2023. Voted a 2023 "Top Workplace" by the Cincinnati Enquirer. \r\n\r\nCar-Part.com is a Blue Ribbon Small Business Award Winning IT Company located in Ft. Wright, KY. We are a leading provider of software and web solutions for auto recyclers in areas such as inventory searching, web design and hosting, promotion, inventory management, and email services. Our products provide auto recyclers with a comprehensive product suite, which assists them in making their inventory available to all potential buyers including body shops, insurance adjusters, core buyers, and retail customers. Car-Part.com provides outstanding customer support while helping recyclers make it easy for their customers to find the best part based on condition, location, availability, brand, and price.\r\n\r\nCar-Part.com employees enjoy a great culture, competitive salaries, performance-based bonuses, 401K matching, workplace flexibility, free parking and a casual dress code in a unique software development atmosphere. For full time employees, health care benefits are also available. If you are interested in being part of a high-energy, innovative company, we invite you to submit your resume and explore the opportunities that we have to offer. Be sure to include your salary requirements when applying for this position.

Job Tags

Full time, Part time, Casual work,

Similar Jobs

Jobot

Legal Assistant Job at Jobot

 ...Hybrid Remote Legal Assistant Position with Growing Firm! This Jobot Job is hosted by: Sharon Brown Are you a fit? Easy Apply now by clicking the "Apply" button and sending us your resume. Salary: $60,000 - $80,000 per year A bit about us: We are seeking... 

JPMorganChase

Lead Software Engineer - Infrastructure as Code Job at JPMorganChase

Job Description JOB DESCRIPTION Be an integral part of an agile team that's constantly pushing the envelope to enhance, build, and deliver top-notch technology products. As a Lead Software Engineer at JPMorgan Chase within theCorporate Sector in Kubernetes ...

NP Now

Hematologist / Oncologist- physician led group, large multispecialty, live in NYC! Job at NP Now

 ...Job Description Job Description A thriving healthcare system is seeking a Hematologist / Oncologist to work in the New York City area! Multiple openings within 45 minutes of New York City- towns in NJ, CT and NY Contact: Raymond Stiles (***) ***-**** raymond... 

Northern States Group - An IBG Partner

Business Development Associate Entry Level Job at Northern States Group - An IBG Partner

 ...Job Description Job Description We are seeking a new Business Development Associate to join our rapidly growing business, where...  ...Former branch manager/ag loan officer and Integrated Solutions Consultant/Manager. Joined IBG after a year-long search for the right career... 

Big D Pizza Llc

Delivery Driver Job at Big D Pizza Llc

 ...compared to most pizza delivery companies and most of the orders are in the immediate downtown area! We pay $5/hr on your check and $1/delivery + tips in cash paid daily. Our current drivers are averaging $50 - $100+ in cash take home. We do a lot of catering orders...