Required Skills

SQL Data warehouse

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 30th Jan 2024

JOB DETAIL

Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from

•              various source systems (oracle, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.

•              Using Informatica PowerCenter created mappings and mapplets to transform the data according to

the business rules.

•              Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.

•              Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement

•              Nice to have: Python skills

•              Must Have: SQL, Data warehouse

Company Information