Required Skills

ETL Informatica DBAs Data Architects

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 24th Nov 2020

JOB DETAIL

Skill  informatica

 

Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications

Creates ETL Mappings Mapplets Workflows Worklets using Informatica PowerCenter 10x and prepare corresponding documentation

 

Designs and builds integrations supporting standard data warehousing objects type2 dimensions aggregations star schema etc

 

Performs source system analysis as required Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse Implements versioning of the ETL repository and supporting code as necessary

 

Develops stored procedures database triggers and SQL queries where needed Implements best practices and tunes SQL code for optimization Loads data from SF Power Exchange to Relational database using Informatica

 

Strong knowledge in DWH and Integration concepts

 

Strong analytical skills

 

Participation in quality processes and impleme

Company Information