09/14/2026 updated
100 % available
Data Engineer - Oracle native
Świecie, Poland
Only remote
Master of Science, Computer Software Engineering (ongoing)About me
Meticulous and detail-oriented, with a sense of ownership and a focus on delivering accurate solutions. Communicative, open-minded, and collaborative, with extensive experience working across technical and business teams. Maintains a positive, solution-oriented approach in demanding environments.
Sql Data WarehouseApache AirflowAnalytical ThinkingContinuous AvailabilityData ArchitectureData InfrastructureData IntegrationExtract Transform Load (ETL)Data MigrationData ModelingData WarehousingDatabase DevelopmentProblem SolvingITIL CertificationsPython (Programming Language)
ETL/ELT Pipeline Engineering
Design and maintenance of end-to-end ETL and ELT pipelines integrating heterogeneous source systems into enterprise data warehouse and data lake environments, including validation checks, reconciliation logic and exception handling.
Data Modeling & Governance
Logical and physical data modeling, ERDs, entity/attribute definitions, mapping specifications, data dictionaries, naming standards, reference/master data, metadata and traceability.
Cloud & Modern Data Stack
Hands-on delivery on AWS (S3, Glue, Lambda, Athena, Redshift), dbt, Snowflake (basic) and Apache Airflow for orchestration and scheduling.
Oracle & PL/SQL Development
Expertise in Oracle 10g/11g/19c with advanced PL/SQL skills including packages, stored procedures, functions, views, materialized views, indexes and sequences. SQL/PL-SQL performance tuning, execution plans and partitioning at scale.
Programming & Scripting
Proficiency in PL/SQL, SQL, Python and Shell scripting, with current focus on AI-native and agentic software engineering methods.
DevOps & CI/CD
Application of Git, GitLab CI/CD, Jenkins and AutoSys for version control, pipeline automation and controlled deployments across dev/QA/prod environments.
Database Objects & Tuning
Creation and optimization of tables, views, indexes, materialized views, sequences, stored procedures, functions and packages with focus on execution-plan analysis and performance improvement.
Operations & Incident Management
Pipeline monitoring, troubleshooting, root-cause analysis, incident management, SIT and UAT activities supporting stable production environments.
Scheduling & Workflow Automation
Experience with AutoSys, BMC Control-M and Apache Airflow for scheduling batch workflows and orchestrating ETL/ELT dependencies.
Experience
Professional experience10+ years
Freelancer since2018
Languages
GermanBasic knowledgeEnglishFluentPolishNative speakerSpanishGood
Project history
Supported the modernization of a global healthcare data platform for sales and medication-adoption analytics. Designed and maintained end-to-end ETL/ELT pipelines, migrated legacy Informatica PowerCenter workflows to AWS-based ELT using dbt, Amazon Redshift and Apache Airflow, developed and optimized Oracle/PL-SQL database objects, implemented validation and reconciliation logic, built reusable dbt models and applied GitLab CI/CD practices to data pipelines.
Supported a business-critical Anti-Money Laundering platform based on Oracle Mantas. Built, configured and maintained test, production and contingency Oracle environments, automated operational and reconciliation tasks with Shell scripting, managed deployments, supported SIT and UAT activities and monitored scheduled workflows with AutoSys.
Implemented complex financial business logic using object-oriented PL/SQL including packages, procedures and functions. Extended data-ingestion pipelines and Informatica PowerCenter workflows, optimized PL/SQL transformations, supported data-integrity validation and CI/CD processes for database and ETL deployments using Jenkins and Maven.
Certificates
PCAP - Certified Associate Python Programmer
Python Institute2021
ITIL v3 Foundation
PeopleCert / AXELOS2016