Application Architect
Core
Design and maintain Oracle database applications connecting Manufacturing Execution Systems (MES) and financial systems, with a focus on business intelligence and data reporting.
Role type
Senior IC database developer/architect
Builds
Scalable database solutions, ETL processes, and BI dashboards
Domain
Manufacturing / Finance / Data Engineering
Required skills
Oracle PL/SQL, Oracle Data Integrator (ODI), ETL development, Excel macros, SQL query development, code debugging, system integration
Preferred skills
Oracle database administration, SQL performance tuning, Agile methodologies, additional ETL tools
Technologies
Oracle, ODI, Excel, Oracle Analytics Cloud, Power BI, Tableau, SQL
Responsibilities
Develop and optimize PL/SQL code for business applications; Design and implement ETL processes using ODI; Create and maintain Excel macros for data manipulation; Debug and troubleshoot code issues; Collaborate with stakeholders to translate business requirements into technical specs; Build scalable database solutions integrating MES and financial systems; Maintain data integrity, security, and performance; Participate in code reviews, testing, and documentation.
