Informatica ETL Consultant
Work Location Pawtucket, RI
Duration 1 Year
Mandatory Technical / Functional Skills • 7+ years of experience in the field of ETL in Informatica
• Sound understanding of Informatica PowerCenter:
- Designer
- Workflow Manager
- Workflow Monitor
- Repository Manager
- Administrator Console
• Sound understanding of SQL Server 2008 data modeling:
- Star Schema & Extended Star Schema
Roles and responsibility • Work closely with the various functional & BI teams to translate business requirements into optimal systems solutions
• Create and maintain blueprints of a data architecture models in accordance with Hasbro standards
• Convey technical methods and procedures to the BI team in support of the architecture designs
• Analyze, Design & development solutions with Informatica tools
• Provide technical support to the BI team during the BI development and onward including enhancements, defect resolution
• Ensure that data protection policies (i.e. data security) as defined and adhered to
• Create new data structures (i.e. DDL) and execute data scripts
• Enhance the performance of ETL layer or Presentation layer queries which includes the tuning of queries and index determination.
• Work with Onsite team in resolving any issues
• Communicate effectively with end users in a multinational environment
• Work with BI team in building solution and delivering mappings
• Adherence to client coding standards
• Work with Offshore/Near shore teams in resolving issues
• Good team player and willing to stretch to achieve goals
Desirable Technical / Functional Skills
Total experience in required skill (years) 7 Years
Work Location Pawtucket, RI
Duration 1 Year
Mandatory Technical / Functional Skills • 7+ years of experience in the field of ETL in Informatica
• Sound understanding of Informatica PowerCenter:
- Designer
- Workflow Manager
- Workflow Monitor
- Repository Manager
- Administrator Console
• Sound understanding of SQL Server 2008 data modeling:
- Star Schema & Extended Star Schema
Roles and responsibility • Work closely with the various functional & BI teams to translate business requirements into optimal systems solutions
• Create and maintain blueprints of a data architecture models in accordance with Hasbro standards
• Convey technical methods and procedures to the BI team in support of the architecture designs
• Analyze, Design & development solutions with Informatica tools
• Provide technical support to the BI team during the BI development and onward including enhancements, defect resolution
• Ensure that data protection policies (i.e. data security) as defined and adhered to
• Create new data structures (i.e. DDL) and execute data scripts
• Enhance the performance of ETL layer or Presentation layer queries which includes the tuning of queries and index determination.
• Work with Onsite team in resolving any issues
• Communicate effectively with end users in a multinational environment
• Work with BI team in building solution and delivering mappings
• Adherence to client coding standards
• Work with Offshore/Near shore teams in resolving issues
• Good team player and willing to stretch to achieve goals
Desirable Technical / Functional Skills
Total experience in required skill (years) 7 Years
--
The Most Active and Happening #1 ERP/SAP Jobs Listserve for SAP Jobs in the US.
LIKE our Facebook page : https://www.facebook.com/ERPJobs
https://groups.google.com/group/sapjobs-usa
Follow us on Twitter:
https://twitter.com/sapjobsusa
Post your Jobs at SAP JOBS USA Linkedin Group by clicking this link
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
Join our Professionals Networks in Linkedin
https://www.linkedin.com/groups/SAP-JobsUSA-4081187/about
https://www.linkedin.com/groups/Global-Network-SAP-Professionals-4081179/about
https://www.linkedin.com/groups/Network-SAP-Professionals-3874920/about
http://finance.groups.yahoo.com/group/SAPJobs-USA/
https://www.facebook.com/groups/mysapfico/
---
You received this message because you are subscribed to the Google Groups "SAP JOBS USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to SAPjobs-USA+unsubscribe@googlegroups.com.
To post to this group, send email to SAPjobs-USA@googlegroups.com.
Visit this group at http://groups.google.com/group/SAPjobs-USA.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment