Lead Data Warehouse & ETL Architect (Oracle/ODI)

JSM Consulting Inc.

City of Albany (NY)

On-site

USD 90,000 - 130,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

JSM Consulting Inc. is seeking a senior ETL/Data Warehouse Engineer to design and implement complex data integration solutions. You will craft technical specifications, write and tune SQL for Oracle databases, and lead an analytics/ETL team on large-scale projects.

Knowledge of ODI 12c and CJ processing is essential. Ideal candidates have 6+ years in data warehousing, strong architecture sense, and proven ability to translate business requirements into robust data pipelines.

Qualifications

72 months experience writing technical specifications including ETL source to target mapping documents, use cases, software architecture documents, ETL design documents and implementation documents.
72 months experience in writing and tuning SQL scripts including: tables, views, indexes, and complex PL/SQL objects including: procedures, functions, triggers, and packages in Oracle database 12c or higher.
72 months experience working with Oracle Data Integrator 12c or later.
60 months experience as a technical team lead responsible for data warehouse and ETL platform architecture.
24 months experience developing, implementing, and integrating systems related to Criminal Justice processing at the state or federal level using Criminal Justice terminology and nomenclatures.