Required Skills

Data Warehousing ETL Informatica Oracle PL/SQL

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 :- 13th Nov 2020

JOB DETAIL

Informatica Developer with Oracle

Charlotte, NC

 

 

 • 10+ years’ experience of Data Warehousing and ETL
o Deep understanding of Data warehousing concepts.
• 5+ years’ experience on Informatica PowerCenter platform (specifically version 10.x), as well as process and workflow tuning and optimization.
• 3+ years’ experience in working with Oracle PL/SQL procedures
• Strong debugging, problem solving and investigative skills. Ability to assimilate disparate information (log files, error messages etc.) and pursue leads to find root cause problems.
• Expertise in using partitioning, transformations, incremental caching in Informatica toolset
• Expert understanding of slowly changing dimensions (SCD's) in Informatica.
• Expert understanding of join logic and query optimization in Informatica
• Experience with stored procedures, Triggers, PL/SQL in Oracle.
• Expert in writing efficient Analytic and windowing functions in Oracle.
• Extensive Business and/or technical background in the areas of Data modeling, EDW, Data Mart, Master Data Management, Metadata management, Data Quality, Data Governance, Data integration (ETL)

Company Information