SysMind Tech
Full Time || Data Modeler || Morrisville NC
SysMind Tech, Morrisville, North Carolina, United States, 27560
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-897-9670 Ext 2244
Email: utkarshm@sysmind.com
LinkedIn: https://www.linkedin.com/in/utkarsh-mishra-6965b0230/
Website: sysmind.com
Address:
Sysmind LLC
400 Alexander Park Dr, Suite 103
Princeton, NJ 08540
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-897-9670 Ext 2244
Email: utkarshm@sysmind.com
LinkedIn: https://www.linkedin.com/in/utkarsh-mishra-6965b0230/
Website: sysmind.com
Address:
Sysmind LLC
400 Alexander Park Dr, Suite 103
Princeton, NJ 08540