Overview

1. Design, develop, deploy, and maintain enterprise integration processes between cloud and on-premise applications using iPaaS platforms including SQL Server, Oracle, MySQL, BigQuery, and Snowflake environments. 2.Monitor, sustain, troubleshoot, and support existing integration implementations across mission-critical client datasets, standardizing SQL definitions, improving date discoverability to ensure data quality, synchronization, and compliance with data governance standards. 3. Develop, manage, and support APIs and endpoint configurations using REST and SOAP web services, JSON, XML, and HTTP protocols, enabling seamless system-to-system integrations across SaaS platforms including NetSuite and Salesforce. 4. Apply transformation logic including data cleansing, validation, aggregation, and enrichment by engineering ETL pipelines using Python, SSIS, SQL Server, and BigQuery. 5.Document integration architecture, design, and maintenance processes for clients, including centralized enterprise data dictionary standards, SQL definitions, and data flow diagrams illustrating system-to-system connectivity across integration environments. 6. Engage with clients to understand system integration, automation, and reporting requirements, presenting Stakeholder reports including integration strategies and technical solutions. 7. Gather and document business requirements, design technical integration solutions, and present recommendations to internal teams and client stakeholders. 8. Establish and maintain strong working relationships with internal and external IT partners, coordinating integration deliverables through Agile and Scrum methodologies. 9. Manage production readiness, perform unit and integration testing, and handle business configurations across Oracle, MySQL, SQL Server, BigQuery, Snowflake, Workato, and Syncari environments. 10. Assist in allocating and coordinating resources across integration and automation workstreams, tracking milestones using project management tools including Jira, LucidChart and Technical Documentation to ensure timely delivery of client deliverables. 11. Standardize SQL definitions, improve data discoverability, and support enterprise integration initiatives across BigQuery, Snowflake, and SQL Server environments using SQL Server Management Studio and SQL Developer, ensuring tasks meet stakeholder expectations and timelines. 12. Assist in developing dashboards using reporting tools such as NetSuite Analytics and Warehouse, and presenting automation strategies using Tableau and Power BI. Education and Experience Requirements This position requires a Bachelor's (or foreign educ. equiv.) Degree in Information Systems, Computer Science, or a related field plus two (2) years' experience in the job offered or related occupation. Experience must include: a. Establishing centralized enterprise data dictionary. b. Standardizing SQL definitions, improving data discoverability and enforcing governance across mission-critical datasets using SQL Server and Oracle. c. Engineering ETL pipelines using SSIS and SQL Server. d. Presenting Automation strategies using Power BI and Tableau. e. Use of programing languages including T-SQL, Python, REST/SOAP APIs. f. Experience with various databases including Oracle, MySQL PL/SQL, SQL Developer, and SQL Server Management Studio. g. Working knowledge with Agile, Scrum, Jira, LucidChart, Technical Documentation and Stakeholder Reporting. Telecommuting/Remote Work is Permitted May Telecommute Salary $105,100 per annum. 40 hours per week; M-F Please copy and paste your resume in the email body (do not send attachments; we cannot open them) and email it to candidates at with job reference in the subject line. Thank you.