Data Warehouse Developer

About the role

We are looking for Data Warehouse Developer in St. Paul, MN for 6+ months contract position.

Please refer someone else if you are not available at this time or you are not right match for this job opportunity. We have great Referral Bonus up to $2500!!! Please don't miss to refer someone who are looking for projects.

Position

• Data Warehouse Developer
• Location: St. Paul, MN
• Duration: 6+ months
• Client: Direct Client

Roles and Responsibilities

• Manage respective data warehouse to deployment including driving all related project tasks, objectives and milestones;
• Direct and guide data warehouse functionality decisions as they related to the client business processes;
• Provide business process design, configuration and documentation for any data warehouse functionality;
• Act as a liaison between the client functional and technical staff;
• Report status to Project Management Office (PMO) team and help draft regular communication across the project;
• Provide project estimates for changes in business process and / or additional new functionality;
• Track, escalate and document project risks, issues, decisions and changes to scope;
• Provide input and research into project recommendations and decisions;
• Work with software vendor to submit defects in delivered functionality;
• Provide other project related experience as necessary;
• Perform configuration analysis and documentation, especially as it relates to data warehouse functionality;
• Lead test preparation including test scenario and test script review and creation;
• Lead interface review and analysis and create documentation on recommendations;
• Take lead for testing execution for the various test cycles;
• Create, document and track issues and resolution;
• Create input for communication and change management;
• Provide detailed analysis and input to training material;
• Provide input and review of complex system modifications;
• Complete functional specification documentation per standards;
• Review and analyze data warehouse security roles and permissions and document any changes and/or recommendations;
• Review and analyze data warehouse batch process schedule and dependencies using AppWorx or another batch scheduling tool and document any changes and/or recommendations;

Required Skills

• 8 years' combined experience in PeopleSoft Financial Management Solutions (FMS) or Supply Chain Management (SCM) applications
• 1 years' combined experience with PeopleSoft version 9.2 with Financial Management Solutions (FMS) or Supply Chain Management (SCM) applications
• 5 years' experience with Oracle's EPM (Enterprise Performance Management)
• 8 years' experience architecting multi-dimensional databases
• 8 years' experience writing SQL
• 8 years' experience with ETL (Extract, Transform & Load) processing
• 1 year experience with PeopleTools 8.54 or higher

Preferred Skills

• Experience with writing DataStage mappings
• Experience with Oracle OBIEE
• Experience with PeopleTools 8.55
• Experience with Web Content Accessibility Guidelines (WCAG) 2.0 (Level AA) and Section 508 (Subparts A-D) in a public sector environment(i.e., Federal, State, County, City, or Municipality government, or Higher Education)

Additional Information

All your information will be kept confidential according to EEO guidelines.