Integration Engineer

Technical Skills Summary

C# | .NET | SQL Server | T-SQL | SSIS | ETL | REST APIs | SOAP APIs | Webhooks | JSON | XML | OAuth 2.0 | API Keys | JWT | Data Mapping and Transformation | Git | CI/CD | Logging and Monitoring | Production Support

Additional Advantage: Oracle Integration Cloud (OIC) | Event-Driven Architecture | Message Queues | Azure / AWS / GCP | iPaaS

NetWeb Software is looking for an Integration Engineer to design, develop, deploy, and maintain reliable, secure, and scalable integrations between internal applications, enterprise systems, products, and third-party platforms. The role has a strong hands-on focus on C#, .NET, SQL Server, and SQL Server Integration Services (SSIS), with responsibility for application-to-application connectivity, ETL workflows, data exchange, and production support.

The engineer will work with engineering, product, business, operations, and customer-facing teams to understand integration requirements, translate them into technical designs and implementation plans, and deliver solutions that maintain data accuracy, reliability, performance, and security throughout the integration lifecycle. Integrations may use REST/SOAP APIs, webhooks, messaging mechanisms, scheduled jobs, and file-based exchanges. Familiarity with Oracle Integration Cloud (OIC) is an advantage.

·       Design, develop, implement, and maintain application integrations using C#, .NET, APIs, webhooks, messaging mechanisms, and file-based data exchange.

·       Connect internal applications and services with third-party platforms and enterprise systems, including CRM, ERP, identity, and other business applications.

·       Translate business and functional requirements into technical integration designs, data flows, interface specifications, and implementation plans.

·       Select and implement appropriate integration patterns to support reliable and maintainable system-to-system communication.

·       Design, develop, configure, deploy, and maintain SQL Server Integration Services (SSIS) packages for data extraction, transformation, and loading (ETL).

·       Build and support ETL workflows that move data between databases, applications, files, and external systems.

·       Implement data mapping, cleansing, validation, transformation, and reconciliation rules to maintain data completeness and accuracy.

·       Configure package parameters, connection managers, control flows, data flows, and error-handling mechanisms as required by integration workflows.

·       Troubleshoot SSIS package execution issues and improve package reliability, performance, and maintainability.

·       Develop and consume REST and SOAP web services and integrate systems through APIs, webhooks, and file-based interfaces.

·       Work with JSON and XML payloads, including serialization, deserialization, schema validation, and transformation.

·       Implement and support API authentication and authorization mechanisms such as OAuth 2.0, API keys, and JSON Web Tokens (JWT).

·       Build robust data exchange processes with appropriate validation, exception handling, retries, and recovery mechanisms.

·       Write, maintain, and optimize SQL queries, views, and stored procedures that support integration and ETL workflows.

·       Apply sound relational database concepts and understand table relationships, keys, transactions, and data integrity.

·       Investigate data inconsistencies, missing or duplicate records, transformation errors, and reconciliation mismatches across connected systems.

·       Work with database teams and application owners to analyze data issues and implement corrective actions.

·       Build resilient integrations with appropriate error handling, retry and recovery logic, structured logging, and monitoring.

·       Monitor scheduled jobs, SSIS executions, interfaces, and integration services to identify failures and abnormal processing.

·       Troubleshoot integration failures, data inconsistencies, performance bottlenecks, and connectivity or authentication issues; identify root causes and implement fixes.

·       Support production deployments and ongoing operations, including incident investigation, resolution, and follow-up improvements.

·       Contribute to observability and support practices that improve visibility into integration health, execution status, and failure patterns.

·       Contribute to code reviews, unit and integration testing, automated testing, defect resolution, and release readiness.

·       Use version control and follow established branching, build, deployment, and CI/CD practices.

·       Support integration deployment, configuration management, environment validation, and post-deployment verification.

·       Identify opportunities to improve integration performance, reliability, maintainability, automation, and operational efficiency.

·       Collaborate with product, engineering, business, operations, and customer teams to clarify requirements, coordinate dependencies, and deliver integration projects.

·       Document integration architecture, interface specifications, configurations, data mappings, data flows, dependencies, and operational procedures.

·       Prepare and maintain support documentation, troubleshooting steps, deployment notes, and knowledge-transfer material.

·       Follow organizational security, privacy, data handling, and compliance requirements when designing and operating integrations.

·       Communicate technical concepts, delivery progress, risks, and production issues clearly to both technical and non-technical stakeholders.

·       Familiarity with Oracle Integration Cloud (OIC), including application adapters, integration flows, data mapping, orchestration, monitoring, and troubleshooting.

·       Exposure to event-driven architecture, message queues, asynchronous processing, or streaming platforms.

·       Familiarity with cloud platforms such as Microsoft Azure, Amazon Web Services (AWS), or Google Cloud Platform (GCP).

·       Exposure to other integration platforms or Integration Platform as a Service (iPaaS) tools.

·       Knowledge of API security practices, secure credential management, observability, and production support processes.

·       Experience working with enterprise systems such as CRM, ERP, identity management, or other SaaS and on-premises applications.

·       Exposure to automated integration testing, performance troubleshooting, and deployment automation.

The ideal candidate is a hands-on Integration Engineer with strong C#/.NET, SSIS, and SQL Server skills and practical experience supporting integrations in a production environment. The candidate should be comfortable working across application, API, and database layers; translating business needs into dependable technical solutions; and investigating issues through logs, monitoring, data validation, and root-cause analysis. A disciplined approach to secure development, testing, documentation, deployment, and collaboration is essential. Exposure to OIC, cloud services, or event-driven integration patterns will be an added advantage.

·       Reliable and accurate data exchange across integrated applications and third-party systems.

·       SSIS packages and integration workflows are developed, deployed, monitored, and supported effectively.

·       Integration failures and data issues are investigated and resolved within agreed support expectations, with root causes addressed.

·       Solutions follow established security, coding, testing, documentation, and deployment standards.

·       Integration changes are delivered with appropriate validation and minimal disruption to dependent systems.

·       Clear communication and effective coordination with engineering, business, operations, and customer-facing teams.