ETL Data Tester

2 months ago

Fort Wright, United States Car-Part.com Full time
Job DescriptionJob 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
\r
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.\r
\r
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.

  • ETL MANAGER

    6 months ago

    Fort Wayne, United States Kendall & Davis Full time

    ETL Manager - Data Integration FTE/PERM Job in Fort Wayne, IN Primary Responsibilities: Schedule and train ETL development resources including managing and coordinating the activities associated with the future development of the overall strategy of the application area. Manage, lead and validate work related to efforts profiling various information...

  • ETL Manager

    1 month ago

    Fort Wayne, Indiana, United States Kendall & Davis Full time

    ETL Manager Job DescriptionJob Summary:We are seeking an experienced ETL Manager to lead our data integration team. The successful candidate will have a strong background in SAP Data Services and experience managing project development teams.Key Responsibilities:Schedule and train ETL development resources to manage and coordinate the activities associated...

  • ETL Test Egineer

    2 weeks ago

    Fort Mill, SC, United States Incedo Inc. 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...

  • Software Tester

    2 days ago

    Fort Knox, United States Lawelawe Defense Inc Full time

    Who We Are Lawelawe is a Native Hawaiian Owned Small Disadvantaged Business (NHO SDB) that specializes in providing a range of services to federal government clients, including program management, digital solutions, human capital and training, and medical staffing. Lawelawe leverages our NHO status to secure federal contracts that not only drive business...

  • Data Scientist

    4 weeks ago

    Fort Worth, Texas, United States Mindlance Full time

    About the Role:We are seeking a highly skilled Databricks Engineer to join our team at Mindlance. As a Databricks Engineer, you will be responsible for designing, developing, and maintaining data pipelines using Databricks and other ETL tools.Key Responsibilities:Design and develop data pipelines using Databricks and other ETL toolsCollaborate with...

  • Data Strategist

    4 weeks ago

    Fort Lauderdale, Florida, United States Zimmerman Advertising Full time

    Job Summary:The Data Strategist at Zimmerman Advertising plays a pivotal role in driving the agency's data capabilities forward. Reporting to the SVP of Retail Technologies, this individual will be responsible for orchestrating and automating data analytics pipelines while maintaining the highest level of quality and reliability.This role requires a strong...

  • Tester with automation experience | SEB, Solna

    5 days ago

    Fort Washington, United States zeroG - AI in Aviation Full time

    Are you passionate about new technology and making a difference? Are you an open-minded Tester with previous experience in test automation? Are you thinking about taking the next step in your career and want to feel valued every day at work? Here we build the core systems that make securities handling possible whenever the stock exchange is open! SEB is more...

  • Tester with automation experience | SEB, Solna

    7 days ago

    Fort Washington, United States zeroG - AI in Aviation Full time

    Are you passionate about new technology and making a difference? Are you an open-minded Tester with previous experience in test automation? Are you thinking about taking the next step in your career and want to feel valued every day at work? Here we build the core systems that make securities handling possible whenever the stock exchange is open! SEB is more...

  • Data Architect

    1 month ago

    Fort Worth, Texas, United States Brushfire Full time

    Job Title: Data ArchitectWe are seeking a highly skilled Data Architect to join our team at Brushfire. As a Data Architect, you will be responsible for designing and implementing our data warehouse and pipelines that feed to/from that warehouse.The ideal candidate will have advanced knowledge of our systems, processes, data structures, and existing tooling....

  • Data Engineer

    4 weeks ago

    Fort Lauderdale, Florida, United States iBusiness Funding Full time

    Job DescriptioniBusiness Funding is a leader in providing innovative Software as a Service (SaaS) solutions for banks and lenders, with a specialization in SBA lending. Our team is driven by our core values of innovation, integrity, enjoyment, and family.We're seeking a skilled Data Engineer to scale our existing infrastructure, incorporate new data sources,...

  • Data Engineer

    3 weeks ago

    Fort Lauderdale, Florida, United States iBusiness Funding Full time

    About the RoleiBusiness Funding is a leader in providing innovative Software as a Service (SaaS) solutions for banks and lenders, with a specialization in SBA lending. We build scalable lending platforms that streamline the business lending process, allowing lenders to efficiently deliver capital to small and medium-sized businesses.Key...

  • Data Scientist

    2 weeks ago

    fort lauderdale, United States ICON International, Inc. Full time

    About the Company:ICON International provides clients with financial solutions built around the concept of corporate barter. We help businesses leverage their underperforming assets by trading those goods for high-value professional products/services. It's a complex and dynamic field, driven by strategy, integrity, and creativity.About the Role:We are...

  • Data Scientist

    2 weeks ago

    fort lauderdale, United States ICON International, Inc. Full time

    About the Company:ICON International provides clients with financial solutions built around the concept of corporate barter. We help businesses leverage their underperforming assets by trading those goods for high-value professional products/services. It's a complex and dynamic field, driven by strategy, integrity, and creativity.About the Role:We are...

  • Data Scientist

    2 weeks ago

    Fort Lauderdale, United States ICON International, Inc. Full time

    About the Company:ICON International provides clients with financial solutions built around the concept of corporate barter. We help businesses leverage their underperforming assets by trading those goods for high-value professional products/services. It's a complex and dynamic field, driven by strategy, integrity, and creativity.About the Role:We are...

  • Business Data Analyst

    1 month ago

    fort mill, United States Incedo Inc. Full time

    Role Description:We are seeking a skilled and detail-oriented Business Data Analyst to bridge the gap between business stakeholders and technical teams. The Business Data Analyst will be responsible for gathering and translating business requirements into data-driven insights and actionable recommendations. The ideal candidate will have a strong background...

  • Business Data Analyst

    1 month ago

    Fort Mill, United States Incedo Inc. Full time

    Role Description:We are seeking a skilled and detail-oriented Business Data Analyst to bridge the gap between business stakeholders and technical teams. The Business Data Analyst will be responsible for gathering and translating business requirements into data-driven insights and actionable recommendations. The ideal candidate will have a strong background...

  • Business Data Analyst

    1 month ago

    Fort Mill, United States Incedo Inc. Full time

    Role Description:We are seeking a skilled and detail-oriented Business Data Analyst to bridge the gap between business stakeholders and technical teams. The Business Data Analyst will be responsible for gathering and translating business requirements into data-driven insights and actionable recommendations. The ideal candidate will have a strong background...

  • Business Data Insights Specialist

    4 weeks ago

    Fort Mill, South Carolina, United States Incedo Inc. Full time

    Role Overview:Incedo Inc. is seeking a skilled Business Data Analyst to bridge the gap between business stakeholders and technical teams. The ideal candidate will have a strong background in data analysis, data modeling, and data management processes, along with the ability to work closely with cross-functional teams to drive data-centric business...

  • Elasticsearch Data Engineer Secret

    1 month ago

    Fort Meade, United States Federal Staffing Solutions Inc. Full time

    We connect our employees with some of the best opportunities around.Time and again our employees tell us that the most important thing we offer is respect. Federal Staffing Solutions puts people to work in all types of jobs. When you work with us you build a relationship with a team of employment professionals in your community who have in turn built...

  • Elasticsearch Data Engineer Secret

    4 weeks ago

    Fort Meade, United States Federal Staffing Solutions Inc. Full time

    We connect our employees with some of the best opportunities around.Time and again our employees tell us that the most important thing we offer is respect. Federal Staffing Solutions puts people to work in all types of jobs. When you work with us you build a relationship with a team of employment professionals in your community who have in turn built...