> Markdown version of [/jobs/ext/1973905-oracle-bi-etl-architect](https://www.wearedevelopers.com/jobs/ext/1973905-oracle-bi-etl-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Oracle BI/ETL Architect

- **Company:** EDGE SYSTEMS, LLC
- **Location:** New York, NY, United States
- **Experience:** Expert
- **Salary:** $149,760.0
- **Contract:** Temporary contract
- **Skills:** Application Integration Architecture, Oracle WebLogic Server, Data Validation, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Warehousing, Software Design Documents, Dimensional Modeling, Systems Analysis, Oracle Business Intelligence Enterprise Edition, Oracle Databases, Performance Tuning, Query Optimization, Regression Testing, SAS (Software), SQL Stored Procedures, PL-SQL, SQL Databases, Strategies of Testing, Sql Optimization, Bi Publisher, Oracle Service Cloud
- **Published:** August 7, 2026
- **Apply:** https://www.dice.com/job-detail/18f6e91c-e395-44a0-9ce1-bbe67cc7c5f7

## About the Role

* Stamped VISA Copy, Passport COPY, DL Copy/ State ID, Bachelor Degree copy & 3 Prof., * 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.

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


## Related Videos

- [Micro-frontends anti-patterns](https://www.wearedevelopers.com/videos/420-micro-frontends-anti-patterns)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)
- [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again)
- [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know)
- [Why Event-Driven Architecture Isn’t About Speed (and When You Actually Need It)](https://www.wearedevelopers.com/magazine/745-why-event-driven-architecture-isn-t-about-speed-and-when-you-actually-need-it)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Science & more: The Lopez dilemma](https://www.wearedevelopers.com/magazine/10-data-science-more-the-lopez-dilemma)