BI ETL Test Engineer

Capgemini
Irving, United States of America
13 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 162K

Job location

Irving, United States of America

Tech stack

Databases
Data Validation
Data Hub
ETL
Data Mapping
Data Warehousing
Systems Development Life Cycle
Cloud Services
Software Engineering
SQL Databases
SQL Server Integration Services
Strategies of Testing
Data Lineage

Job description

As a BI ETL Test Engineer, you take care of the testing of BI systems. This includes validation of the business data flow , ETL components, data lineage, ETL architecture and you are able to analyze defects during data validation. This includes setting up testing strategy, recommend tools, perform technical feasibility and risk assessments.

Requirements

ETL Tester with experience in Informatica and Data mapping. Collaborate with QA Engineers(client & teams from other vendors).

Yor role

Primary Skills :ETL Tester with good knowledge into Informatica PC & IICS ETL/DWH Tester.

Strong knowledge into Informatica PC (Power Center) and IICS (Informatica Intelligent Cloud Service) Testing.

Identifying data sources and requirements.

Define test cases and test planning for Database and project requirements.

Exact data and Run the Test cases according to the project requirements.

Good understanding and experience in informatica mappings and SSIS packages.

Able to write complex Sql quires to test required output as per project need.

Knowledge in Data hub for tickets handling.

Collaborate with QA Engineers(client & teams from other vendors) to develop effective strategies and test plans.

Conduct post-release/ post-implementation testing.

Work with cross-functional teams to ensure quality throughout the software development lifecycle.

Good Experience in STLC and SDLC

Your skills and experience

4+ Years of experience into ETL / DWH Testing.

Strong knowledge into Informatica PC (Power Center) and IICS (Informatica Intelligent Cloud Service) Testing.

Exact data and Run the Test cases according to the project requirements.

Good understanding and experience in informatica mappings and SSIS packages. Able to write complex Sql quires to test required output as per project need.

Should have knowledge in Data hub for tickets handling.

Basic Knowledge on ALM. Ability to analyze and understand an application/product/system quickly.

Collaborate with QA Engineers(client & teams from other vendors) to develop effective strategies and test plans.

Conduct post-release/ post-implementation testing.

Good in analytical skills - Logical thinking and gap analysis

Benefits & conditions

The base compensation range for this role in the posted location is $68,911 - $161,544

Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law.

The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction.

These may include, but are not limited to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity.

It is not typical for candidates to be hired at or near the top of the posted compensation range.

In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws.

Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include:

  • Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave

  • Medical, dental, and vision coverage (or provincial healthcare coordination in Canada)

  • Retirement savings plans (e.g., 401(k) in the U.S., RRSP in Canada)

About the company

Capgemini ist einer der weltweit führenden Anbieter von Management- und IT-Beratung, Technologie-Services und Digitaler Transformation. Als ein Wegbereiter für Innovation unterstützt das Unternehmen seine Kunden bei deren komplexen Herausforderungen rund um Cloud, Digital und Plattformen.

Apply for this position