Job Title: ETL Developer
Location: Albany NY(Hybrid)
We are currently seeking candidates who meet the following qualifications
Qualifications
- Developed ETL/E-LT objects, including interfaces, packages, scenarios, procedures, and load strategies for relational databases, utilizing Type 1, 2, and 3 slowly changing dimensions with Oracle Data Integrator.
- Authored technical specifications, such as ETL source-to-target mapping documents, use cases, software architecture documents, ETL design documents, and implementation guides.
- Created and optimized SQL scripts, including tables, views, indexes, and complex PL/SQL objects, such as procedures, functions, triggers, and packages in Oracle Database 12g and higher.
- Proficient in working with Oracle Data Integrator version 11g or later.
- Served as a technical team lead, overseeing the architecture of data warehouse and ETL platforms.
- Developed, implemented, and integrated systems related to criminal justice processing at both state and federal levels, employing relevant terminology and nomenclature.
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.