What are the responsibilities and job description for the Senior OBIEE/OAS Lead with Informatica position at Maagsoft Inc.?
Job Title: Senior OBIEE/OAS Lead with Informatica - HBITS-08-14906
Duration: 30 Months
Location: Menands, NY 12204
Client: State of New York
Experience: 14 Years
Requested Qualifications:
- 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 modelling and system analysis, including dimensional modelling, 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/PLSQL 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
Required Documentation:
- Resume
- Copy of Candidate Identification (i.e., Driver’s License//Visa and Passport if applicable)
- Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)
Thanks & Regards.
Pavan || Lead – Talent Acquisition Specialist
Email:
Linked In:
Company Linked In:
Maagsoft Inc
NYS MBE Certified
Port Authority of NY and NJ MBE Certified