Data Warehouse Developer

Infojini Consulting is a full service IT consulting, services, and staffing firm with offices in Secaucus, NJ.

Infojini Consulting is recognized as one of the fastest growing IT services and software development Companies. With a partnership of all major technology vendors, Infojini Consulting has built a strong Government and commercial customer base including fortune 100 companies and most state and federal agencies such as State of North Carolina, State of South Carolina, State of Maryland, State of California, State of Pennsylvania, State of Virginia, State of Washington and many others.

Infojini Consulting is an equal opportunity employer and considers all qualified individuals for employment irrespective of their race, gender, age, color, sexual orientation. We offer an excellent compensation package.

Job Description

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

Job Description:

Position: Data Warehouse Developer

Location: St. Paul, MN

Duration: 6+ months

Client: Direct Client

Roles and Responsibilities:

1. Manage respective data warehouse to deployment including driving all related project tasks, objectives and milestones;
2. Direct and guide data warehouse functionality decisions as they relate to the client business processes;
3. Provide business process design, configuration and documentation for any data warehouse functionality;
4. Act as a liaison between the client functional and technical staff;
5. Report status to Project Management Office (PMO) team and help draft regular communication across the project;
6. Provide project estimates for changes in business process and/or additional new functionality;
7. Track, escalate and document project risks, issues, decisions and changes to scope;
8. Provide input and research into project recommendations and decisions;
9. Work with software vendor to submit defects in delivered functionality;
10. Provide other project related experience as necessary;
11. Perform configuration analysis and documentation, especially as it relates to data warehouse functionality;
12. Lead test preparation including test scenario and test script review and creation;
13. Lead interface review and analysis and create documentation on recommendations;
14. Take lead for testing execution for the various test cycles;
15. Create, document and track issues and resolution;
16. Create input for communication and change management;
17. Provide detailed analysis and input to training material;
18. Provide input and review of complex system modifications;
19. Complete functional specification documentation per standards;
20. Review and analyze data warehouse security roles and permissions and document any changes and/or recommendations;
21. 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:

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

Preferred Skills:

1. Experience with writing DataStage mappings
2. Experience with Oracle OBIEE
3. Experience with PeopleTools 8.55
4. 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.