Client is modernizing its technology environment to improve efficiency, integration, and reporting across critical systems. This position is responsible for designing, implementing, and supporting the enterprise platform environment, ensuring high-quality data integration, governance, and system performance.
Requirements
- Strong hands-on experience with Oracle Database (19 C) including PL/SQL and performance optimization.
- Proficiency in system integration and ETL/ELT frameworks such as SSIS, Oracle Data Integrator (ODI), or equivalent.
- Proficiency with Linux server environments
- Solid working experience in writing cron jobs.
- Solid working experience in Python scripts.
- Solid working experience in SQL Scripts
- Troubleshooting Linux-based file transfers and system processes.
Responsibilities
- Design and maintain integration pipelines to consolidate data and processes across multiple systems (Oracle database, SQL Server, and others).
- Re-platform and modernize existing workloads into a scalable enterprise environment.
- Implement reusable frameworks for automation (full, incremental, CDC).
- Build and maintain layered environments (staging, refined, curated) to support system reliability and consistency.
- Build and maintain cross-system and data integration for unified information access across AGE managed applications.
- Apply validation rules, quality checks, and access controls to ensure reliable outcomes.
- Support metadata management including dictionaries, glossaries, and lineage documentation.
Other
- Hybrid
- 3 Days a week onsite and rest remote
- Public sector or healthcare IT experience is preferred.
- Excellent communication and collaboration skills to work effectively with teams across all levels of the organization.
- Working knowledge of data warehousing and data modeling concepts.
