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: http://www.capgemini.com/resources/equal-employment-opportunity-is-the-lawApply now