Senior OBIEE/OAS Architect - HBITS-08-14906

Job Title: ON-SITE - Senior OBIEE/OAS Architect - HBITS-08-14906 

Location:  Menands, NY 12204 

Duration: Long-term (30)  

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 

________________________________________________________________  

Agency: Department of Health 

Project: Special Supplemental Nutrition Program for Women, Infants, and Children (WIC) 

Detailed Job Description: The NYWIC (New York Women, Infants, and Children) system is a statewide application that supports the administration of New York’s WIC nutrition program, which provides nutritional assistance and health services to eligible women, infants, and children. The Division of Nutrition relies on custom applications to support the delivery of these programs. The NYWIC MIS-EBT project provides a .NET/Oracle-based platform that enables efficient program operations and ongoing enhancements to meet evolving business needs. Within this environment, the DataMart team is responsible for the design, development, and ongoing maintenance of the enterprise data warehouse and reporting layer supporting the NYWIC application. The team includes Business Analysts, Data Modelers, Informatica Developers, and OBIEE Developers who work collaboratively to deliver and sustain data solutions.The team continuously implements enhancements and updates to the DataMart as the core application evolves, ensuring accurate, reliable, and timely reporting for business users, program administrators, and regulatory stakeholders. 

Note: Sorry we do not Sponsor Visa  
Max: SEVEN 32.800.2838  

Aryan: - SEVEN 32.800.2373