Full Time || Data Modeler || Morrisville NC - SysMind Tech : Job Details

Title: Data Modeler Location: Morrisville, NC Type/Duration: FULL TIME Experience: 8+ years JOB DESCRIPTION: Skill: MS Visio, IBM RSA, Erwin, Informatica Power Center 8.x/7.x,MS SSIS, SSAS. •Hands-on exp with Informatica 9.6 and above. Well versed with all Informatica Client Components (Power Center Designer, Workflow Manager, Workflow Monitor, Repository Manager). •Well versed with concepts such as Merge files and partitioning of Source query to run workflow as multiple instance. •Have exposure to all facets of Extract, Transform and Load (ETL) processes. •Be able to create the complex mappings in order to extract the data from source to target using informatica cloud(IDMC). •Working with different db., Flat files, Fixed width files as source/target. •Working with XML as a Source/Target, Webservice consumer transformation using wsdl files and API calls. •Experience in Design, develop, test and support from SQL stored procedures, views, Informatica workflows. •Develop and optimize UNIX Shell scripts and file transmissions. •Working knowledge of ESP scheduling tool to create/modify jobs. •Develop, unit test and system test integration components. •Work with Business Analysts and external teams to understand the scope of work, priorities and requirements for the data solution. Preferred Skills: •Designing, implementing, and maintaining data integrations for batch ETL using Informatica Cloud (IDMC/IICS). •Experience in IICS Data Integration Components like Task flow, Mappings and all tasks etc. •Migrating Informatica Power center to Informatica Cloud, hence migration experience will be ideal. •Experience with the IICS command line utility. •Experience with Stone branch Scheduling tool. Utkarsh Mishra | SYSMIND, LLC Utkarsh Mishra Direct: 609-###-#### Ext 2244 Email: [email protected] LinkedIn: Website: sysmind.com Address: Sysmind LLC 400 Alexander Park Dr, Suite 103 Princeton, NJ 08540