Senior Oracle PL/SQL Developer - Credit Risk Reporting
ACP doIT GmbH
Contact person: Jolene Kappis
Bratislava, Slovakia
ITSql Data WarehouseBankingBusiness IntelligenceData GovernanceData IntegrationExtract Transform Load (ETL)Data MigrationData WarehousingDatabase DevelopmentOracle Data GuardOracle ExadataOracle Data Service IntegratorOracle DatabasesOracle ApplicationsOracle CRMOracle SQL DeveloperOracle Warehouse BuilderOracle AtgSqlprofilerPL-SQLSQL DatabasesSystems IntegrationOracle Integration SolutionsOracle Application ImplementationPL/SQL Server PagesDatabase Performance AnalyzerOracle ImplementationSQL OptimizationBi PublisherOracle SCMOracle SQL LoaderPlsqldeveloperOracle DesignerOracle Insurance Policy Administration (OIPA)Oracle AdfData LakeOracle ReportsOracle EbusinessOracle System ImplementationOracle ErpOracle IntegrationSql Database AdministrationSql Tuning
Description
We are looking for a Senior Oracle PL/SQL Developer to support and enhance a Credit Risk Reporting application through enterprise-scale Oracle database development, data warehousing, ETL, data integration, performance optimization, business intelligence, reporting, risk management, and regulatory reporting.
The project has particular relevance to the banking sector and involves close collaboration with business stakeholders, architects, analysts, development teams, and cross-functional Agile or project-based teams.
- Develop complex SQL and PL/SQL solutions, including packages, procedures, functions, triggers, and views, while optimizing queries and database performance.
- Design and implement ETL solutions, data integration workflows and pipelines, including data migration, transformation, cleansing, quality, consistency, and integrity.
- Develop and support enterprise data warehouses, data marts, dimensional models, reporting and analytical platforms, including metadata management and data governance.
- Contribute to technical designs, implementation plans, effort estimates, project planning, solution architecture, and technical decision-making.
- Handle database and ETL performance monitoring, SQL tuning, troubleshooting, root-cause analysis, testing, deployment, release and operational/on-call support.
- Participate in code reviews, technical documentation, knowledge transfer, knowledge sharing, mentoring, stakeholder communication, and Agile/project-based collaboration.
- Work within an Oracle, Data Warehouse and Business Intelligence environment, potentially including Hadoop or Data Lake platforms.
- At least 8 years of Oracle database development experience with advanced SQL and Oracle PL/SQL expertise.
- Strong experience with Oracle Data Integrator (ODI), ETL process design and implementation, relational database concepts, data modeling, data warehouse and business intelligence environments, and database performance tuning.
- Experience supporting data quality, consistency, integrity, data governance, risk management, and regulatory reporting requirements.
- Preferred domain experience in banking, financial services, insurance, or risk management.
- Bachelor’s or Master’s degree in Computer Science, Information Technology, Engineering, or a related field.
- Strong analytical thinking, problem solving, attention to detail, stakeholder management, team collaboration and communication skills, with the ability to work independently, share knowledge, and mentor others.
Technologies:
Oracle Databases | PL/SQL | SQL (Programming Language) | Extract Transform Load (ETL) | Data Governance | Data Modeling | Data Warehousing | Relational Model | Business Intelligence | Database Tuning | Oracle Warehouse Builder
Location: Vienna, Austria / Bratislava, Slovakia
Work mode: Hybrid | 1 day on-site per month
Capacity: 160 hours per month
Start: 1 January 2027
Duration: 11 months | Possible extension
Language: English
Seniority: Senior