Data Integration Engineer / ETL Developer

About the role

Concept 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

• Designing, developing, enhancing, testing, and deploying ETL solutions
• Migrating existing Informatica workflows to ODI
• Tracing and maintaining ETL processes across Development, Test, and Production environments
• Administering the ETL platform while ensuring compliance with client cybersecurity, data governance, and operational standards

Requirements

• 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)
• 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

Qualifications

• US Citizen
• Able 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)

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)
• 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
• Average and Specific Years of Experience:
  • Agile Tooling Jira, Confluence, Bitbucket (or similar tools)

Benefits

Competitive pay, comprehensive health, dental, and vision insurance, paid life insurance, paid time off, 11 paid holidays, performance bonuses, tuition reimbursement, unlimited training, and the opportunity to thrive in a collaborative, flexible, and innovative environment.