IT Specialist

JSM Consulting Inc.; City of Albany (NY); In loco; USD 90.000 - 130.000; Tempo pieno

Descrizione del lavoro

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.

Competenze

• 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.

Conoscenze

Tech specs doc

SQL & Oracle

ODI 12c

Data warehouse lead

Criminal Justice

Descrizione del lavoro

• 72 months experience writing technical specifications including ETL source to target mapping documents, use cases, software architecture documents, ETL design documents and implementation documents. 11.25 15
• 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. 11.25 15
• 72 months experience working with Oracle Data Integrator 12c or later. 7.5 10
• 60 months experience as a technical team lead responsible for data warehouse and ETL platform architecture. 7.5 10
• 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. 7.5 10