Informatica Developer

Informatica, ETL, DB2
Full Time
Depends on Experience

Job Description

Sr. Level Informatica Developer to help maintain existing Data Warehouse ETL as well as design, build and enhance existing Data Warehouse

Overall IT Experience requirements:
• A minimum 7+ years of strong hands on work experience in a Data Warehousing Environment using Informatica in an AIX / Linux and UDB DB2 environment
• Possess excellent oral and written communication skills
• Capable of working with minimal supervision
• Knowledge of all phases of Software Development Life Cycle SDLC (Requirement Analysis, Design, Development, Testing and Documentation

Data Warehousing Requirements:
• Good working and hands on knowledge of:
o Data Warehouse Concepts, Database design/architecture
o Star Schema / Snow Flake Design practical experience
o Dimensional and Fact Table Design practical experience
o ODBC Connectivity
o UDB DB2, DB2 Scripts

Informatica Requirements:
• Must have strong hands on Informatica knowledge and experience from design to installation
• Must have strong working and hands on knowledge and experience with PowerCenter Designer, Workflow Manager, Workflow Monitor, Repository Manager, Deployment Groups, and related tools
• Must have strong working and hands on knowledge of Administrator Console functions
• Full Implementation experience of both Server and Client software components as well as converting existing prior versions to latest version
• Setting up of Disaster Recovery Server and Procedures
• Setting up of LDAP and AD Groups
• Setting up Security Groups and assignments
• Ability to work with Informatica Support to resolve issues

Data Base Requirements:
• Strong UDB DB2 / SQL knowledge and experience
o Ability to put DB2 Scripts together
Create tables, add columns, indexes, etc
• Knowledge of other databases such as Oracle, SQL Server, etc

Overall Technical Requirements:
• Databases: UDB DB2, Oracle, MS SQL Server
• Data Warehousing: Star-Schema, Snowflakes, FACT, Dimensions.
• Operating Systems: Aix, Linux, Windows, DOS
• Windows: MS-Word, MS-Excel and MS-PowerPoint, MS-Project, Visio
• Programming Languages : Knowledge of JAVA
• Query Tools : TOAD, IBM Data Studio


Data Resource Technologies Inc. is an Information Technology Staffing Firm serving the markets of the United States of America; the greatest country in the world. We work with Direct Clients Only and do not participate in multi layer contracts. Earn The Most Possible and put over 60 years of Information Technology Industry experience to work for you today, Call or Apply NOW!!!

Dice Id : 10124769
Position Id : 7150027
Originally Posted : 3 weeks ago
Have a Job? Post it