About the roleConcept Plus is seeking a Data Integration Engineer and ETL Developer to support client enterprise ETL environment by leading and assisting with the transition from Informatica to Oracle Data Integrator (ODI). Responsibilities include designing, developing, enhancing, testing, and deploying ETL solutions; migrating existing Informatica workflows to ODI; troubleshooting and maintaining ETL processes across Development, Test, and Production environments; and administering the ETL platform while ensuring compliance with client cybersecurity, data governance, and operational standards.
What you'll do- ETL/Data Integration: 3+ years with Oracle Data Integrator (ODI) or equivalent ETL tool (e.g., Informatica, Talend, SSIS).
- Database Development: 3+ years with Oracle (SQL, PL/SQL, performance tuning).
- Knowledge/Experience with Oracle Data integrator (ODI) or Equivalent ETL Tool (Informatica Powercenter 10.5.x)
- Reporting & Analytics: Experience with SAP BusinessObjects or equivalent BI/analytics tool (e.g., Tableau, Power BI, Qlik).
- Budgeting & Planning: Experience with IBM Planning Analytics (TM1) or similar enterprise budgeting tools.
- Oracle ODI and/or Informatica experience required.
- 3+ Years experience in Oracle, PL/SQL.
- SAP BusinessObjects (SAP BO) experience preferred.
- Agile development experience (Scrum ceremonies, backlog management).
- Strong communication and problem-solving skills.
Required Qualifications- US Citizen
- Ability to obtain and/or maintain a government clearance.
- Bachelor's degree in Computer Science, Information Systems, or related field
- CompTIA Security+ or equivalent (required) Overall and Specific Years of Experience
- 3+ years with Oracle Data Integrator (ODI) or equivalent ETL tool (e.g., Informatica, Talend, SSIS)
- 3+ years with Oracle (SQL, PL/SQL, performance tuning).
- Experience with IBM Planning Analytics (TM1) or similar enterprise budgeting tools
- 3+ years of experience in Decision Support System applications and their architecture
- 2+ years' experience with Defense Architectural Framework (DoWAF) Guidance
Preferred Qualifications- Experience with SAP BusinessObjects (SAP BO) or equivalent BI/analytics tool (e.g., Tableau, Power BI, Qlik).
- Experience with Oracle APEX or similar low-code platforms for UI/data maintenance.
- Familiarity with Oracle WebLogic Server and HTTP Server (install, configure, patch).
- Ability to review Interface Control Documents (ICDs) and implement changes.
- Experience resolving STIG findings and applying DoW security hardening.
- Familiarity with DoWAF and Decision Support System architectures.
- Scripting for automation (Python, Bash, PowerShell).
- AWS GovCloud / Cloud One experience or similar secure cloud environments.
- Exposure to CI/CD pipelines and DevSecOps practices.
- Tuning ETL workflows, database queries, and reporting dashboards.
- Implementing monitoring and alerting data pipelines and application services.
- Agile Tooling Jira, Confluence, Bitbucket (or similar tools).
