Job Title: ETL Test Lead
Location: Hartford, CT
Position Type: Permanent/Fulltime

Roles & Responsibilities:

Strong knowledge in writing complex queries for validation of ETL process.
Good Knowledge in validating files created in UNIX env using UNIX shell commands.
Experience in Data Analysis, Data Validation.
Experience in Data warehouse testing  either using SAP BW, Oracle PL/SQL jobs run through Control M.
Experience in BI report testing using Business Objects, BI Publisher
Expert in web services testing of SOAP services using SOAP UI.
Proficient in SQL queries– Oracle, My SQL, MS SQL, MS Access
Solid Back End Testing experience by writing complex SQL Queries.
Excellent working knowledge in Test Plan, Test Strategy, Test Estimates, Test Requirements and Test Case .
Experience in creating traceability matrix mapping Test Scenarios / Test Cases with requirements.
Experience in waterfall and agile testing methodologies
Experience in working with diverse team : Onsite – offshore model


Role Specific Skills:

ETL/Datawarehouse Testing, Functional Testing

Experience & Exposure Required:

8-10 years of overall hardcore functional testing experience.
Minimum of 5+ year of experience in Insurance Domain ( P & C)
Minimum 5 years of managing  ETL Projects.
Good communication and leadership skills.
Strong knowledge on STLC ( Software Testing Life Cycle )
Experience working with the business and IT team diligently to execute the activities in a timely manner
Experience in effort estimations using industry standard methods
Experience in defect life cycle management – logging, replication, triaging, verification, closing, metrics reporting, etc.



Capgemini Financial Services and its U.S. affiliates are EEO/AA employers. Capgemini conducts all employment-related activities without regard to race, religion, color, national origin, age, sex, marital status, sexual orientation, gender identity/expression, disability, citizenship status, genetics, or status as a Vietnam-era, special disabled and other covered veteran status.

Click the following link for more information on your rights as an Applicant:

Apply now