ETL dataware house teater

SmartRecruiters, Inc.; Northbrook (IL); On-site; USD 69,000 - 110,000; Full time

Job summary

Blackapple Solutions Ltd (BSL) in Northbrook, Chicago, is seeking a seasoned ETL/Data Warehouse Tester for a 3-6 month engagement in the Chicago area. The candidate should bring 5-6 years of hands-on experience with ETL testing, data warehouse validation, and strong SQL skills.

Responsibilities include coordinating with onsite and offshore teams, leveraging Informatica and Ab Initio tools, and maintaining quality through the SDLC/testing processes while ensuring clear client communication.

Qualifications

• Expert in ETL/Data Warehouse testing with 5–6 years of experience.
• Proficient in SQL and data validation techniques.
• Experience with Informatica ETL tool.
• Experience with Ab Initio ETL tool.
• Excellent analytical, communication, and client-facing skills.

Skills

ETL Testing

Data Warehouse Testing

SQL

Analytical Skills

Unix Commands

Communication

Decision Making

Onsite-Offshore Coordination

SDLC & Testing Processes

Tools

Informatica ETL

Ab Initio ETL

HP Quality Center

Job description

Blackapple Solutions Ltd (BSL) was founded in 2004 with the mission to provide best-in-class IT consultancy services across the globe. We are a specialist IT consultancy offering services through our consultants/experts on a contingency basis in the UK, Europe, USA and Asia Pacific. We work with a portfolio of high profile multinational clients across all sectors.

Job Description

Experience : 6+ Yrs

Skill : DW testing

Duration : 3-6 months

Location : NorthBrook, Chicago

Extension possible : Yes

JD:

• 1. Expert in ETL/Data warehouse testing - Minimum of 5-6 years of exp.
• 2. Expert in SQL’s
• 3. Has experience in Informatica ETL tool
• 4. Has experience in Abinitio ETL tool
• 5. Expert Analytical skills
• 6. Good in UNIX commands
• 7. Good in Communication and client facing skills
• 8. Quick decision making ability
• 9. Has exposure to HP-Quality center
• 10. Expert in SDLC process and testing process
• 11. Has experience in onsite-offshore co-ordination