The key function of the API Integration Specialist is to use APIs, for client implementations for Smartvm API and apexportal Solutions software applications. We are seeking an experienced individual with knowledge of data driven APIs and business knowledge. This person will possess implementations with software-as-a-service and on-premises solutions. This position is in our apexportal Solutions department, which implements and consulting services for apexportal to our clients. The candidate should work to become an expert on apexportal Solutions functionality and implementation procedures.
The Work:
Assist clients in designing and configuring interfaces between their ERP systems and smartvm,
apexportal and lead the testing of ERP integrations which includes reconciling data between
client s ERP system(s) and apexportal.
Lead integration and onboarding efforts with internal teams and customers.
Assist clients in designing and developing interfaces between their ERP systems, apexportal and
lead the testing of ERP integrations which includes reconciling data between client s ERP
system(s) and apexportal.
Support existing internal/client facing APIs specific to the client s requirements which include
design/re-design and developing microservices, API proxies, SSIS packages, setting up nightly
batch jobs using SQL Server Management Studio and C#.
Lead working sessions with developers from the client end to help in the integration process
which requires expertise in business knowledge.
Develop various stored procedures, triggers, reusable functions using Microsoft SQL server.
Designing interactive graphs to track multiple APIs usage and analysis using Azure, PowerBI.
Responsible for the overall security of systems they will be administering including protecting
client data and reporting situations which may provide unintentional elevated access. The
employee will regularly review corporate policies and will enforce the policies documented in
the Apex Corporate Security Standards.
Present functional overview and functional requirements to clients when planning
implementations and upgrades.
Setup of technical environment and serve as the technical expert for hosted clients.
Solve complex business and application problems independently and serve as a primary contact
for our SmartVM application.
Develop, Implement, and enhance high impact business process improvement projects.
Continuous delivery and quality check of data via the APIs or application interface 24x7.
Troubleshoot network, database, and software problems for our client implementations.
Conduct training for designated clients.
Work with Infrastructure personnel to resolve client integration issues.
Communicate/coordinate with Client Value Team as well as Audit team to support clients.
Involve in other in-house Research & Development project of apexportal Solutions
The Must-Haves:
Hands on experience in SQL Server.
Strong database fundamentals and expertise.
Strong knowledge in REST, SOAP APIs, interfaces and data delivery via APIs.
Hands on experience in Postman, Debugging Tools, for developing SOAP or REST Integrations
Knowledge of standard API/Web Service authentication/authorization practices (OAuth)
Knowledge of CSV, XML, and JSON file formats.
Knowledge of data related applications and best practices for review of data quality.
Strong SQL skills - ability to create complex Stored Procedures, indexes, views and jobs.
Data definition, data manipulation, data control, and transactional control
Administration, including creating and restoring SQL backups
Good knowledge on SSIS - Developing and deploying SSIS using various sources like Oracle/SQL
Server/Flat Files/SAP systems.
Ability to create and maintain Mockups, BRD, FRD and Wireframes using various applications
like Visio, Excel, Microsoft Project, Adobe.
Windows networking, including IIS and Windows security admin.
Working knowledge of API management tools such as Apigee, Azure or other industry standard
tools.
Experience in version control tools like TFS, CVS, SVN, GIT to manage and control software
development.
Working knowledge of HTTP, FTP, secure FTP, and PGP.
Good working knowledge of Microsoft Office (Excel and Outlook).
Ability to juggle multiple projects and adapt according to the changes in projects.
Experience working with Agile Development methodologies.
Required Experience:
Bachelor s degree in Computer Science or related discipline with 2 years related experience or
Master s Degree in Computer Science, Information Sciences or related discipline with 1 year of
related experience preferred.
2+ years of experience as an implementation specialist, data analyst, or in a similar role with
exposure to Data Warehousing concepts and exposure to multi system APIs.
1+ years IT background including multiple API (REST/SOAP) Development and Integration with
both software-as-a-service and on-premise solutions.
2+ years of SQL.
1+ years SSIS.
Excellent written, verbal, and presentation skills.
Customer-facing experience with large customers preferred.
Experience working with cross functional teams and business units to define application and