Oracle BI/ETL Architect | OBIEE Lead - C2C

Hello,

Urgently hiring for the below role with NYS.

Note: We are the direct prime vendors with the State Of New York - HBITS.

Position: Oracle BI/ETL Architect | OBIEE Lead

Job ID: HBITS-08-14906
Location: Riverview Center, 150 Broadway, suite 600, Menands, NY 12204 (Hybrid)
Duration: 30 Month

Client / Dept.: New York State Department of Health

Interview Mode: WebEx interview

Rate: $72/hr on C2C (All incl.)

Only 12+ Years candidate needed for submissions.

Required Documents:

• Stamped VISA Copy, Passport COPY, DL Copy/ State ID, Bachelor Degree copy & 3 Prof.

JOB DESCRIPTION:

• 84 Months Experience supporting OBIEE 11g/12c and Oracle Analytics Server (OAS), including development, enhancement, migrations, web catalog, RPD, and BI Publisher deployments across enterprise reporting environments.
• 72 Months Experience leading ETL teams and designing enterprise data integration architecture using Informatica, including data standards, governance, best practices, and mentoring for data warehouse initiatives.
• 72 Months Experience in Oracle database development, including advanced SQL/PL/SQL programming, performance tuning, optimization, and conversion of complex SQL, stored procedures, and SAS logic into Informatica mappings.
• 72 Months Experience administering OBIEE/OAS environments, including installation, configuration, upgrades, WebLogic administration, security setup, patching, migrations, and production support across DEV/QA/UAT/PROD
• 84 Months Experience in OBIEE performance tuning and troubleshooting, including query optimization, cache management, RPD tuning, aggregate navigation, and report/dashboard performance improvements.
• 48 Months Experience in data modeling and system analysis, including dimensional modeling, star/snowflake schema design, source-to-target mapping, and technical design documentation for enterprise data warehouses.
• 48 Months Experience in ETL and BI testing, including test strategy development, SIT, UAT, regression testing, data validation, reconciliation, and defect resolution across BI and data warehouse systems.
• 48 Months Experience in advanced data validation and troubleshooting using SQL/PL/SQL to ensure data integrity, accuracy, and consistency across enterprise data pipelines and reporting systems.
• 48 Months Experience in end-to-end BI implementation and data governance, including requirements gathering, ETL development, semantic layer design, dashboard/report development, deployment, and enterprise data governance, lineage, and quality frameworks.
• Bachelor's Degree in IT field.