Client seeks a highly technical resources to serve as a Data Integration, API and ETL developer for creating real-time, on-demand, batch and scheduled data interfaces and processing between systems and applications, both internal and external.
This Integration/Interface engineer position must be very well organized and able to manage multiple technical, business and testing efforts. Duties include requirements gathering, designing, and implementing solution, and supporting go-live and post-implementation.
The Integration/Interface position has responsibility for providing hands-on development, design, implementation, and support of business solutions based on IIB/ACE technology and/or MuleSoft. Must have experience in latest version of IIB, i.e. App Connect Enterprise (ACE v11/12) and MuleSoft in architecture principles, system integration, technical sizing, high availability aspects, integration best practices.
In addition to IIB/ACE experience, preference would be for candidates with experience in designing and developing integration solutions using MuleSoft.
Skills
| Skill | Required | Required Experience | Candidate Experience | Last Used |
| Experience in data modeling, OLAP design, and implementation of APIs and ETL processes, procedures, and execution for data cleansing, and refreshes. | Required | 7 | Years | |
| Experience with integration via web-services, API and ETL management. | Required | 5 | Years | |
| Hands on design, development and implementation experience with IBM IIB/ACE | Required | 5 | Years | |
| Strong technical experience, knowledge and understanding of micro-services architecture. | Required | 5 | Years | |
| Hands-on experience building integration patterns; processes; managing, deploying and supporting API's. | Required | 7 | Years | |
| Experience with Oracle and PL/SQL. | Required | 7 | Years | |
| Experience leveraging common frameworks such as message queuing, caching, complex mapping, branching, and parallel processing. | Required | 7 | Years | |
| Strong understanding and knowledge of data formats JSON, XML, Flat Files (CSV, Fixed-Width). | Required | 7 | Years | |
| Experience with troubleshooting & debugging. | Required | 7 | Years | |
| Hands on technical experience in developing and supporting solutions using MuleSoft | Highly desired | 2 | Years | |
| Hands-on experience with Anypoint Platform, Anypoint Studio | Highly desired | 2 | Years | |
| Experience in building integration flows, APIs, and connectors using MuleSoft technologies such as Mule Runtime, DataWeave, API Manager | Highly desired | 2 | Years | |
| Experience with AWS cloud platform | Highly desired | 2 | Years | |
| Proficiency in scripting languages e.g., Groovy, JavaScript, Python, Perl, Bash, JSON, etc. | Desired | 2 | Years |
| Questions | Questions | Answers |
| Question 1 | Absences greater than two weeks MUST be approved by CAI management in advance, and contact information must be provided to CAI so that the resource can be reached during his or her absence. The Client has the right to dismiss the resource if he or she does not return to work by the agreed upon date. Do you accept this requirement? | |
| Question 2 | All work must be completed on state premises once Covid is contained. Do you accept this requirement? | |
| Question 3 | Please list candidate's email address HERE that will be used when submitting E-RTR. | |
| Question 4 | Looking for immediate hire. Please indicate how soon this candidate is available to start work. Vendors are encouraged to submit candidates that are available for the duration of the assignment. | |
| Question 8 | The client is requesting that candidates are able to provide 2 references prior to final selection. The references must be recent from a Sr Manager/Director overseeing the candidate's work. Do you accept this requirement? | |
| Question 9 | Please confirm this candidate is not intending to work multiple jobs simultaneously. Do you accept this requirement? | |
| Question 10 | Please list AWS based tools and technologies on which the candidate has hands-on experience. | |
| Question 11 | Please list MuleSoft tools and technologies on which the candidate has hands-on experience. | |
| Question 12 | Please list MuleSoft certifications. | |
| Question 13 | Please provide candidate's current location (City and state), NOT a Yes or No response. |