What are the responsibilities and job description for the Data Modeler / Data Engineer (Informatica Exp. position at Centraprise?
Data Modeler / Data Engineer (Informatica Exp.)
Morrisville, NC (Onsite)
Fulltime (Permanent)
Mandatory Skill : MS Visio, IBM RSA, Erwin, Informatica Power Center 8.x / 7.x,MS SSIS, SSAS.
Job Description :
- 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 :
