Hands-on experience with OIC or similar integration platforms like Boomi or MuleSoft.
Strong SQL and relational database skills, including data modeling and performance optimization.
Experience with REST, SOAP, JDBC/ODBC, and event-driven integrations.
Knowledge of high-volume ingestion and error handling techniques.
Understanding of API security practices, including OAuth and encryption.
Familiarity with SDLC, CI/CD, and production support processes.
Strong analytical and customer communication skills.
Bachelor's degree in a relevant field or equivalent experience.
U.S. Citizenship with the ability to obtain necessary security clearance.
Responsibilities
Review customer requirements and finalize integration designs and technical specifications.
Develop, test, deploy, and maintain ETL/ELT solutions using Oracle Integration Cloud or similar platforms.
Integrate various data sources including databases, SaaS platforms, and APIs.
Design solutions for high-volume processing and robust error handling.
Optimize SQL, PL/SQL, and data-quality rules for performance.
Implement secure data practices for data in transit and at rest.
Conduct comprehensive testing across defined use cases.
Troubleshoot production issues and implement durable solutions.
Package solutions for deployment and produce necessary documentation.
Mentor developers and contribute to reusable integration patterns.
Benefits
Opportunity to work with cutting-edge integration technologies.
Collaborative work environment with a focus on professional development.
Exposure to enterprise-level projects and high-volume data processing.
Potential for career advancement within a growing company.
Supportive culture that values innovation and problem-solving.
Full Job Description
Description
ECS is seeking a Database Developer focused on data ingestion, integration, and ETL/ELT delivery for enterprise customers. The developer will translate integration requirements and technical designs into secure, supportable, production-ready data flows across cloud applications, databases, APIs, and enterprise platforms.
The ideal candidate combines strong SQL and data-integration fundamentals with hands-on experience building high-volume integrations, resolving data-quality issues, and supporting customer deployments from design through operational handoff.
Responsibilities
Review customer requirements and finalize integration designs, data flows, mappings, and technical specifications.
Develop, test, deploy, and maintain ingestion and ETL/ELT solutions using Oracle Integration Cloud (OIC), Oracle Data Integrator (ODI), Oracle Data Transforms, or comparable iPaaS and data-integration platforms.
Integrate databases, SaaS platforms, REST and SOAP APIs, files, queues, and enterprise applications.
Design for high-volume processing, concurrency, restartability, error handling, monitoring, and reconciliation.
Develop and optimize SQL, PL/SQL, schemas, transformations, stored procedures, and data-quality rules.
Implement secure authentication, authorization, credential management, and encryption for data in transit and at rest.
Conduct unit, integration, regression, and performance testing across defined use cases.
Troubleshoot production issues, identify root causes, and implement durable remediation.
Package solutions for controlled deployment and produce design documents, mapping specifications, runbooks, and support materials.
Provide estimates, communicate delivery status and risks, mentor developers, and contribute reusable integration patterns and practice collateral.
Required Skills
Hands-on experience with OIC or a comparable integration platform such as Boomi, MuleSoft, Celigo, Workato, or SnapLogic.
Strong SQL and relational database skills, including data modeling, query tuning, transformation logic, and performance optimization.
Experience designing and implementing REST, SOAP, JDBC/ODBC, file-based, and event-driven integrations.
Experience with parallel processing, concurrency management, high-volume ingestion, error handling, reconciliation, and recovery.
Understanding of API security, OAuth, certificates, secrets, encryption, and secure integration practices.
Experience with SDLC, source control, CI/CD, testing, release management, and production support.
Strong analytical, documentation, estimation, and customer communication skills.
Ability to work independently, manage multiple priorities, and deliver with limited supervision.
Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent professional experience.
U.S. Citizenship and ability to obtain and maintain the clearance required by the customer; TS/SCI with Poly may be required for Intelligence Community assignments.
About ECS
ECS is a leading provider of digital solutions and services to the federal government. The company was founded in 2001 by Roy Kapani and has since grown to become a trusted partner to a wide range of government agencies. ECS offers a broad range of services, including cloud computing, cybersecurity, and artificial intelligence. The company has been recognized for its innovative solutions and has won numerous awards, including the AWS Public Sector Partner of the Year award.