Data Analyst (Informatica v8.6.1)

Description

Assignment Description (Analyst/Developer/DBA . etc.) Perform Analysis, Design, Development and Testing of new and existing Informatica mappings. Assignment Responsibilities Under General Supervision, assume primary responsibility for creating Informatica mapping technical design specifications based on functional designs and business requirements as well as development and unit testing of these Informatica mappings. This will include working with IT Data Analysts in a team environment to design, develop and unit test the required mappings.The mappings will be developed using Informatica v8.6.1. The Sources are SQL Server databases and XML. Target Databases are all SQL Server. Being able to create stored procedures in Microsoft SQL Server is a plus.Skills by Priority Version Required or Desired LightMediumHeavyWritten Communication Skills NA Required MediumOral Communication Skills NA Required MediumCreate/Update mappings, sessions and workflows Informatica 8.6.1 Required MediumCreate/Update parameter files Informatica 8.6.1 Required LightKnowledge and experience using Router, Union and XML Parser transformation types Informatica 8.6.1 Required MediumKnowledge and experience using Normalizer, Filter, Joiner, Lookup, Stored Procedure, Aggregator, HTTP and Sorter transformation types Informatica 8.6.1 Required LightKnowledge and experience in expression syntax Informatica 8.6.1 Required HeavyKnowledge and experience in using Source Qualifier transformations configured to use SQL Select statements as an override Informatica 8.6.1 Required HeavyExperience in Select, Update and Delete statements Microsoft SQL Server 2018 Required MediumTechnical Design Specification Creation NA Required MediumReading of Data Models NA Required MediumReading of XML files NA Required MediumStored Procedure Development Microsoft SQL Server 2018 Required MediumExperience in Pre SQL and Post SQL functionality Informatica 8.6.1 Desired MediumAbility to debug and understand session error logs Informatica 8.6.1 Desired MediumFamiliar with reusable objects Informatica 8.6.1 Desired LightTrigger Development Microsoft SQL Server 2018 Desired LightExperience working with an Operational Data Store NA Desired MediumInsurance/Financial Industry Experience NA Desired Medium