Job Duties and Responsibilities: **** Must have experience with SmartConnect
Analyze and provide opinion on the rationality and practicality of clients’ current-state integrated landscape Weigh options for integration design, considering cost, performance, integrity, and complexity Estimate costs of investments in middleware, data storage, API development, and investments in automated triggers and ETL development, including up front and ongoing costs Create logical designs for overall integration and ETL middleware-based solutions to join data and functionality of multiple business applications such as: ERP, SCM, HCM, CRM, WMS, DW/ODS, Ecommerce, etc. Use ETL development skills in middleware platforms such as SSIS, Tibco cloud, Scribe, Kingsway Soft, Informatica, Microsoft Azure/Data factory, Microsoft Dataverse Use Agile principles to work independently and as part of a delivery team to design, develop, test, deploy and support integration development Mentor and lead development and testing resources, while being accountable to a project manager and a practice leader in traditional consulting practice Promote the use of technologies, best-practices, standards, and methodologies that can be leveraged across all engagements Act as a trusted advisor to client IT and business managers who seek reliable, affordable integrated applications: this includes support of presales efforts Maintain skills and certifications Support business decisions to partner with specific software solutions and providers Work according to the needs of the practice and client demands in alliance with project managers for optimal utilization of time
Qualifications
Understand the principals of data-oriented vs. service-oriented integration across several platforms and tool sets
Strong experience in the design and development of modern ETL and ESB engines for managing data interchange between on-prem and cloud solutions of different architectures and RDBMS
Practical experience in any of the following: Scribe, Tibco, SmartConnect
Experience with SAS integration/workflow applications such as Zapier, Power Automate/Flow, Integromat. Working knowledge of Web Services, REST, Enterprise Integration Patterns, SQL, SSIS, EML Writing pure SQL integration Strong comprehension of relational databases that support modern applications, primarily SQL, NOSQL databases Able to provide advice and rational for proper integrated application environment, including appropriate system-of-record for various business processes to help enforce master data management. Competency in Microsoft Dynamics GP, CRM/CE