Architectural Services, Business Processes, Criminal Justice, Data Warehousing, Database Extract Transform and Load (ETL), Documentation, Enterprise Data Integration, Identify Issues, Information Technology & Information Systems, Leadership, Oracle, Oracle Data Integrator, Oracle Database, Oracle PL-SQL, Requirements Management, SQL (Structured Query Language), Software Architecture, Stored Procedures, System Integration (SI), Team Lead/Manager, Technical Writing, Use Cases
Job Title: ETL Developer (Oracle ODI) 8+ yrs Exp
Location: Albany, NY (Hybrid)
We are currently seeking candidates who meet the following qualification
Qualifications:
- Experience designing, developing, and maintaining ETL/ELT solutions using Oracle Data Integrator (ODI), including mappings, packages, scenarios, procedures, and related integration components.
- Experience preparing comprehensive technical documentation, including ETL source-to-target mapping specifications, use cases, software architecture documents, ETL design specifications, and implementation documentation.
- Experience developing, optimizing, and troubleshooting SQL and PL/SQL code, including tables, views, indexes, stored procedures, functions, triggers, and packages within Oracle Database 12c or later.
- Experience implementing and supporting Oracle Data Integrator (ODI) 12c or later in enterprise data integration and data warehousing environments.
- Experience serving as a technical team lead, providing architectural guidance, technical oversight, and leadership for data warehouse and ETL platform design, development, and implementation.
- Experience designing, developing, implementing, and integrating Criminal Justice information systems at the state or federal level, with knowledge of Criminal Justice business processes, terminology, data standards, and system integration requirements.
If you meet these qualifications, please submit your application via link provided in Linkedin
Kindly do not call the general line to submit your application.
A
ACS Consultancy Services