Senior Denodo Developer Jobs (NOW HIRING)

Role: Lead/Senior Datastage with Design Experience
Location: Peoria, IL
Duration: 1+ Year
Consultant Deliverable
Comments
Proposal Templates
Templates will be inclusive of Proposal Estimate, Scope and Assumptions as applicable.
Project Risk Assessment
Information utilized to update or change tickets.
Project Requirements Documents
Requirements Documents will include the following details:
• Define as-is process (written/visual)
• Define to-be process (written/visual)
• New inputs/outputs
• Logic Change
• Source and Destination Connectivity Detail
• Communication Protocol
• Trading Partner Names
• Transaction Types
Data File Creation/Modification
Data File creation/manipulation that meet the requirements outlined in the Requirements Documents above.
1.1.1. Consultant Roles and Responsibilities
Should project scope need to be increased or re-calculated, the Consultant will provide a flexible and scalable team pursuant to the Change Control Process in Appendix A.
table 3: team members
Team Member
Team Member Qualifications
Data Designer
• 5 Years Datastage and Supply Chain EDI Experience
• Has extensive knowledge using DataStage ETL tools (Datastage v8.x or 11.x) and various database platforms
• Experience with Caterpillar EDI project design and development is highly desired
• Familiarity and/or experience in any Caterpillar Business Area that leverages EDI
• Familiarity with AIAG Supply Chain EDI model
• Familiarity of extracting data from various data sources and loading to Teradata, Oracle, and DB2 RDBMS
• Knowledge and Understanding of Caterpillar EDI Environment
• Understanding of Caterpillar SI mapping naming structure
• Deep knowledge of Caterpillar IDOC/APP structures
• Understanding and knowledge of Caterpillar EDI Design Patterns
• Excellent communication/interview skills to extract detailed EDI integration requirements from non-technical integration requesters, as well as ability to effectively collaborate with Caterpillar EDI Subject Matter Experts.
• Ability to read and understand Caterpillar EDI Guidelines based on X-12 and EDIFACT EDI Standards.
• Ability to determine the difference between X12 Standards Requirements and Caterpillar Implementation Requirements
• Ability to use SIMON and Sterling Integrator to research and determine current EDI capabilities of internal and external trading partners
• Ability to read, understand and document Mapping Requirements using Caterpillar Mapping Requirements Specifications (MRS) documents.
• Work closely with Caterpillar EDI Subject Matter Expert to make sure all designs adhere to approved design patterns as well as Caterpillar EDI Integration Patterns.
• Obtain Solution Design approval from Caterpillar EDI Subject Matter Experts before submitting any and all EDI solution designs.
Data Design Lead or Specialty Data Designer
• 5+ years of experience working with IBM Integration products
• Knowledge of the following products and how to apply them in various business scenarios:
o IBM BPM (both ESB side and Workflow side)
o IBM ODM (Business Rules)
o IBM DataPower
o IBM IIB
o IBM MQ
o Denodo
• Strong verbal and written communications to document detailed integration requirements from business partners, non-technical integration requesters, as well as ability to effectively collaborate with other Subject Matter Experts.
• Ability to lead and guide the development work to meet the designs and requirements
• Desire and ability to understand Caterpillar business
• General knowledge of the following IT concepts:
o SOA (Web Services)
o API Management
o Data Integration
o Data Virtualization
table 4: scope of support
Support Type
Description
Data Project Assessment, Design and Development Coordination Services
Data Design Team will be responsible for gathering internal client requirements and creating Project Requirements Documents for data projects and solutions, creating Project Risk Assessments, creating Design Documents including Visio or flow diagrams, updating Project Folders (LAN Drive) with all required deliverables and supporting documentation, obtain design review/approval from Architects/Functional leads, and deliver / present the designs to development team for execution. The same resources may be employed to execute development activity as required by Caterpillar.
table 5: implementation approach
Phase
Action Items/Activities
Engagement Kickoff
• Verify Scope of Service / Deliverables
• Identify quality requirements and develop quality plan
• Confirm engagement governance model
• Review and refine standard engagement status report
Deploy On-Site Support Team
• Consultant will be responsible for all HR functions for its personnel including onboarding, oversight, termination, and recruitment of replacement personnel, as necessary.
• Integrate Supplier resources with internal operating rhythms and processes
On-going Support Service Improvement
• Provide continual Service Improvement/Optimization approach for team members
• Monitor status of Continual Improvement metrics against benchmarks
• Provide Quarterly Business Reviews
• Provide Process Review