Informatica Developer

Description

Top Three Skills 1. Stored procedure Development Exp. With Select, Update & Delete statements
2. Data warehouse, or data mart exp. 3. Informatica 9.5.1 Job Description Perform Analysis, Design, Development and Testing of existing SQL procedures and code, analyze data for errors and develop corrections. Assignment Responsibilities Under General Supervision, analyze documented defects from end users to determine root cause of issue and remediation required. Develop and test solution, support testing by end users in lower environment, and work with primary asset analyst to promote solutions to production. Need to have the ability and willingness to perform analysis and defect resolution with limited guidance. Provide detailed input on technical decisions regarding design, testing, and maintenance. Produce documentation of the processes and code developed to support the above efforts. Being able to read and modify stored procedures in Microsoft SQL Server is a primary requirement. Familiarity with database structure, design, and dimensional databases is required. Informatica v9.5.1 will be used to investigate and alter mappings for SQL Server sources. Target databases are SQL Server. Additional Information Required Informatica Exp. Create/Update mappings, sessions and workflows
Knowledge and experience using Router, Union transformation types
Knowledge and experience using Normalizer, Filter, Joiner, Lookup, Stored Procedure, Aggregator, HTTP and Sorter transformation types
Knowledge and experience in expression syntax
Knowledge and experience in using Source Qualifier transformations configured to use SQL Select statements as an override
Create/Update parameter files
Ability to debug and understand session error logs
Experience in integration test and system test of mappings
Experience in performance tuning
Experience in Pre SQL and Post SQL functionality
Familiar with reusable objects
Required SQL Exp. Experience in Microsoft SSAS Cube Development and Support
Stored Procedure Development
Experience in Select, Update and Delete statements