Description
We're looking for an Integration Engineer to design, build, and maintain integrations between our systems and external clients.
You'll work across the database and application layers , writing PL/SQL for data logic and Python for services and APIs , to deliver reliable, well-documented integration solutions.
Responsibilities and Duties
- Design and develop REST APIs for client integrations, following industry best practices (versioning, auth, error handling, rate limiting, documentation).
- Build and maintain PL/SQL packages, procedures, and functions to support integration logic and data transformations.
- Extend and maintain existing Python listener services that consume messages from queues for ad-hoc report requests.
- Develop custom reports in Excel and PDF formats based on client/business requirements, generated via the listener services.
- Write clean, tested, maintainable code with proper logging, monitoring, and error handling.
- Collaborate with client-facing teams to gather integration requirements and translate them into technical specs.
- Troubleshoot and resolve integration issues in production environments.
- Document APIs, data flows, and integration processes for internal and client use.
Knowledge, Skills and Experience
- Strong proficiency in PL/SQL (packages, procedures, functions, performance tuning).
- Strong proficiency in Python (API development, message queue consumers/listeners).
- Experience with REST API design and standards (OpenAPI/Swagger, authentication methods like OAuth2/API keys).
- Experience with message queues (e.g., Kafka, RabbitMQ, or similar).
- Experience generating reports programmatically in Excel (openpyxl, pandas) and PDF (reportlab, or similar).
- Solid understanding of relational databases (Oracle preferred, given PL/SQL).
- Familiarity with version control (Git) and CI/CD practices.
Nice-to-Have
- Experience with API gateways or integration platforms (e.g., Kong/MuleSoft/Apache Camel).
- Experience with containerization (Docker) and cloud environments.
- Exposure to client onboarding/integration project lifecycles.