Law

Job Position : Informatica BO Consultant

Location :  Indianapolis, IN

Duration :  12+ months contract

Rate:: $40/hr on C2C

Roles & Responsibilities:-

·         Experience leading and developing medium to large scale Operational and Decision Support based Data Integration projects . Expert knowledge of Informatica based ETL solution.

·         Expert knowledge of SQL with Netezza database. Expert Knowledge of Unix shell scripting

·         Should have a good understanding about Data Warehousing Concepts (star and snowflake schema, OLTP, OLAP etc.) Should be comfortable writing SQL queries (good knowledge of SQL Joins) and have basic understanding about PL/SQL.

·         Should have a working knowledge on Business Object Designer and have knowledge about importing a universe, making changes, and then deploying the universe to the repository.

·         Should be able to Set up the universe parameters and connect to the data source, create aliases and contexts, create joins, create classes, subclasses and objects, Define dimensions, details and measures, define hierarchies, define lists of values, define filters and implement user security.

·         Should be able to move/migrate Universe from one environment to another environment and deploy it. Should be able to create Object, dimension, measures etc. for creating BO reports.

·         Should have basic idea about types of aggregation function used in BO. Knowledge of Master Data Management.

·         Getting sign-offs from the client for design and Requirements.

·         Evaluate data load performance test results  Preparation of Status Reports, TT/CR status reports and TT Trend Reports.

·         Experience in Ticketing Tool such as Remedy, TRAC tool will be added advantage