ETL Tester with Ab Initio

KMM Technologies, Inc.; Chicago (IL); On-site; USD 85,000 - 120,000; Full time

Job summary

KMM Technologies, Inc. in Chicago, IL seeks an ETL Tester Ab Initio to design and execute formal test plans, write test cases and scripts, automate tests, and document defects. You will build test strategies for data warehousing, validate controls (Control-M/Control Center), and collaborate with business and operations to ensure on-time delivery.

Strong SQL, UNIX, Ab Initio, and TDM experience required; excellent communication and independent work habits are essential.

Qualifications

• Strong SQL and UNIX scripting skills.
• Experience with ETL testing and defect tracking.
• Ability to validate data warehousing solutions.

Responsibilities

• Define testing strategies and plans for ETL/data warehousing.
• Develop and execute functional, regression, and deployment tests for ETL jobs.
• Coordinate with business/ops to validate requirements and deployments.
• Track defects and report testing progress and results.
• Demonstrate Ab Initio, Control-M, and TDM knowledge to mock data for testing.

Skills

SQL

UNIX

ETL testing

Defect tracking

Tools

Ab Initio

Control-M

Control Center

Test Data Management (TDM)

Job description

Job Description

Responsible for developing and executing formal test plans to ensure the delivery of quality software applications. Involved in test planning, writing test cases and scripts, test case automation and test execution. Documents all problems.

Position: ETL Tester Ab Initio

Location: Chicago, IL

Long term Contract

Job Description

Responsible for developing and executing formal test plans to ensure the delivery of quality software applications. Involved in test planning, writing test cases and scripts, test case automation and test execution. Documents all problems.

Individuals in this role will be experienced in building test strategies, test plans, test scripts, test execution, and defect tracking and reporting for data warehousing and reporting capabilities. This role requires exceptional communication skills, attention to detail and the ability to work independently to meet all the target dates and expectations.

Qualified Candidates Will Be Able To

• Define approach to validating capabilities.
• Develop testing strategies and test plans, including functional testing, regression testing, negative testing, deployment testing , ETL job execution (Control-M/Control Center)testing, and error handling testing.
• Work with business to understand the requirements.
• Work with operations team to coordinate the build deployment and execution within the test environment.
• Track Defects and report on testing progress and results.
• Demonstrate advanced SQL, UNIX, Control-M, Control Center and ETL (Ab Initio) skills.
• Ability to understand the code base by looking at Ab-Initio Psets, graphs(.mp) & XFR's.
• Has required skills to mock-up and upload test data using Ab Initio's Test Data Management tool (TDM).

Additional Documentation

Test Strategy, Test Plan, Traceability Matrix, Test Cases, Test Data, Test Results, Test Defects, and Build Assessment documentation

Thanks & Regards,

Santhosh Gajjada

Talent Acquisition Specialist

KMM Technologies, Inc.

CMMI Level 2 | ISO 9001 | ISO 20000 | ISO 27000 Certified

WOSB, SBA 8(A), MDOT MBE & NMSDC MBE

Contract Vehicles: 8(a) STARS III & Schedule 70

Tel: [phone] | Fax: [phone]

E-MAIL: [e-mail]

http://www.kmmtechnologies.com