Data QA Automation Engineer

Farm Credit Services of America • Omaha, NE

4d

About The Position

We are seeking a Data QA Automation Engineer who will work within an agile business intelligence development environment, develop quality assurance and testing strategies, create, and maintain test cases using automated testing tools, and build automated regression test suites. You will be asked to verify test results utilizing testing tools and utilities and provide timely test result feedback to a project team. Providing first level support and configuration of the testing tools and testing environment while collaborating with project team members to improve overall product quality.

Requirements

• Bachelor's degree in Computer Science is preferred.
• 4 + years of experience, QA, or database development related role with extensive experience in developing and implementing test plans.
• Demonstrated knowledge of automated test tools.
• A working knowledge of data testing best practices including data profiling and modeling in relational, dimensional and data warehousing scenarios.
• Hands-on experience with software testing at all phases (unit, integration, regression, system/acceptance, load and performance, end-to-end) is required.
• Ability to learn and excel in the use of an automated testing framework and develop automated tests within the framework.
• Strong ability to develop and execute Structured Query Language (SQL) statements against data structures using modern/common query tools
• Proficient in Windows environment using previous and the latest Microsoft Office suite, Visual Studio, Team Foundation Server (or other centralized source control system ) and Microsoft SQL Server.
• Develop and execute data set test plans to validate transformations as part of the data validation process.

Nice To Haves

• Demonstrated knowledge of PowerShell scripting, C# and VB Script experience preferred.

Responsibilities

• Take the necessary steps to ensure our customers’ needs are met to the maximum extent possible in an accurate and timely manner.
• Communicate with technical and non-technical team members, leaders, and customers.
• Maintain a close and strong working relationship with project team members and leadership.
• Provide on-going support and maintenance of test automation tools, including the development of technical documentation.
• Collaborate with project teams to develop and promote quality assurance practices to improve overall data quality.
• Champion new processes, software and/or systems to improve organization’s data integrity and data governance effectiveness.
• Identify and communicate when QA processes are not being adhered to or when insufficient quality conditions exist in a project or process.
• Thoroughly test all business intelligence and data warehouse changes to ensure that the business requirements have been satisfied before approving the promotion of the changes to the production environment.
• Display a ‘test to break’ attitude, and a drive toward 100% test coverage.
• Demonstrate ability to take the point of view of the customer.
• Possess a strong desire for quality and attention to detail.
• Create test scripts and test plans to enable streamlined application testing practices.
• Mentor project team members on writing test scenarios and proper testing procedures.
• Prioritize testing based on relative risk to system. Analyze, recommend, implement, configure and administer automated testing tools targeted to enhance data integrity and quality assurance practices.
• Create testing strategies for manual and automated testing to meet specific project needs.
• Provide training and support in the use of testing automation products and strategies.
• Understand and test data warehouse ETL or other relevant data transformation processes.
• Understand data needs and define strategies to manage data in support of effective testing.

Benefits

• Health Benefits: Comprehensive medical, dental, and vision insurance
• Retirement Plans: 401(k) 
• Paid Time Off: Vacation, sick leave, paid holidays, and parental leave
• Additional Benefits: Life and disability insurance, Employee Assistance Program (EAP), wellness programs, tuition assistance, and short-term incentive pay

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees