Full Time || Data Modeler || Morrisville NC

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 :

Utkarsh Mishra | SYSMIND, LLC

Utkarsh Mishra

Direct : 609-897-9670 Ext 2244

Email : utkarshm@sysmind.com

LinkedIn :

Website : sysmind.com

Address : Sysmind LLC

400 Alexander Park Dr, Suite 103

Princeton, NJ 08540