Job Details

ID #40793461
State Texas
City Plano
Job type Contract
Salary USD Depends on Experience Depends on Experience
Source Softpath System, LLC.
Showed 2022-05-13
Date 2022-05-05
Deadline 2022-07-04
Category Et cetera
Create resume

ETL Consultant- Job

Texas, Plano, 75023 Plano USA

Vacancy expired!

Job Description:

Role: ETL/Pentaho Consultant

Location:

Plano, TX

Type: Contract

DESIRED SKILLS AND EXPERIENCE:
  • Minimum of 9-10 years of Hands-On Software experience with 5+ on Data Warehousing
  • 3+ years of Informatica
  • Pentaho for ETL: 6/10 skill level
  • 3 + years of experience working on ETL, Hive, Impala, Informatica

Mandatory Technical Skills
  • Sound Knowledge of Data warehousing concepts, terminology and Architecture.
  • Excellent ETL (Including XML) Design and development Experience
  • Good understanding of the commonly used transformations like Source qualifier, joiners, union, aggregator, sorter, expressions, transaction control, xml transformation, lookups etc.
  • Ability to understand mapping document and translate the same to Informatica Mapping
  • Ability to create CDC, SCD, Fact load and complex mappings with Informatica
  • Sound concepts of RDBMS with hands on with performance tuning of ETL / DB / SQL Queries
  • Good knowledge of UNIX with ability to create Unix/Linux shell scripts to run ETL jobs and trap any failures.
  • Skill in gathering and documenting user requirements and writing technical specifications
  • Good knowledge of SDLC for projects using DW concepts and Client/Server technologies.
  • Create detail mapping documents, module spec and unit test cases
  • Hand on with informatica development, Configuration and Performance tuning
  • Good experience of working on Pentaho environments.

Interpersonal Skills:
  • Well-developed analytical & problem-solving skills
  • Strong oral and written communication skills
  • Excellent team player, able to work with virtual teams
  • Ability to learn quickly in a dynamic start-up environment
  • Able to talk to client directly and report to client/onsite
  • Flexibility to work on different Shifts and Stretch
  • Flexible to travel and relocate in India and Abroad

Vacancy expired!

Subscribe Report job