NorfolkRecruiter Since 2001
the smart solution for Norfolk jobs

Data Modeling with informatica

Company: Diverse Lynx
Location: Norfolk
Posted on: November 25, 2022

Job Description:

Job Title: Data Modeling with informatica

Location: Norfolk VA (Remote)

Job Type: Contract



Job Summary:

Roles & Responsibilities

Resolve and provide solutions to any issues that may arrive Create proper technical documentation outlining the entire process

Troubleshoot and debug any issues while integrating Ensure that the requirements for all the processes have been met

Conduct quality checks on the stored data on a regular basis Informatica Tidal SQL Oracle Facets(preferred)

Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical.

Strong experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Metadata Manger).

Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets

Strong understanding of OLAP and OLTP Concepts.

Extensively worked on Informatica Designer Components Source Analyzer, Warehouse Designer, Transformation Developer, Mapping Designer and Mapplet Designer.

Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier. Expertise in developing Slowly Changing Dimensions mappings(Type1, Type2) and Change Data capture Extensively involved in creating Oracle PL/SQL Stored Procedures, Functions, Packages, Triggers, cursors, and Indexes with Query optimizations as part of ETL Development process.

Expertise in different Informatica Performance Tuning issues like Source, Target, Mapping, Transformation, session to make them more efficient in terms of session performance.

Used Workflow manager to create and configure workflow and session task to load data

Experience 8to10Yrs 4.

Required Skills ,Facets, MS SQL Server 5.Nice to have skills ,PL/SQL, Oracle, Informatica, SQL 6.

Keywords: Diverse Lynx, Norfolk , Data Modeling with informatica, Other , Norfolk, Virginia

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Log In or Create An Account

Get the latest Virginia jobs by following @recnetVA on Twitter!

Norfolk RSS job feeds