Piotr Dziubinski, Full-stack Developer in Warsaw, Poland
Piotr Dziubinski

Full-stack Developer in Warsaw, Poland

Member since December 27, 2016
Piotr is a veteran full-stack developer with over 15 years of experience, mainly focusing on Oracle development. He ie experienced with SQL databases (Oracle, MS, MySQL, and more) as well as big data. He has worked on the front end and back end—developing with Java, Java EE, HTML, CSS, Angular, JavaScript, Oracle, ETL, DWH, Oracle BI, and many others.
Piotr is now available for hire


  • Roche
    Oracle, PL/SQL, Informatica PowerCenter, Java, Python, HTML, CSS, SAP...
  • Flo Technologies
    Elasticsearch, AWS (EC2, S3), Matillion, Snowflake, Java
  • AGB Nielsen
    Microsoft SQL, BI, MySQL, Tableau, Google Data Studio, Java 8, HTML, CSS...



Warsaw, Poland



Preferred Environment


The most amazing...

...things I've coded were the first radio-streaming service in Poland, a VOD IPTV platform, and my work with native ETL development.


  • Data Architect | Full-stack Developer

    2018 - PRESENT
    • Worked on ETL, ODS, and DWH marts.
    • Optimized the DWH performance with Informatica as well as PL/SQL procedures.
    • Standardized the architecture, e.g., naming conventions and so on.
    • Created the software architecture.
    • Developed an SAP Hybris data integration via SAP Data Hub using the ImpEx engine and Java SOAP/REST web services. Used SAP HANA for fast real-time reports.
    • Built an SAP Hybris Oracle DB data integration and an SAP Hybris flat file data integration.
    • Tuned the performance.
    • Prepared Power BI reports.
    • Worked as a Power BI and Tableau developer.
    • Created an API based on Java microservices.
    Technologies: Oracle, PL/SQL, Informatica PowerCenter, Java, Python, HTML, CSS, SAP, SAP ERP, Python ETL, PySpark, Spark
  • Data SaaS Architect

    2019 - 2019
    Flo Technologies
    • Created the solution's architecture.
    • Worked with software as a service technologies (SaaS).
    • Collected data.
    • Created an ETL process using Java, Elasticsearch, Matillion, and Snowflake.
    • Created am API based on Java microservices.
    Technologies: Elasticsearch, AWS (EC2, S3), Matillion, Snowflake, Java
  • Data Architect | Full-stack SaaS Developer

    2018 - 2018
    AGB Nielsen
    • Optimized the structure of the database this included partitions, indexes, normalization, and many others.
    • Improved the database procedures and SQL queries.
    • Built the back end (Java web services with SQL and NoSQL data sources).
    • Implemented a MongoDB along with the indexing—created structure according to business requirements (business and system analysis and design).
    • Created the MongoDB design and interface as well as API (a source for Tableau).
    • Deployed the product with Apache, PHP, and Tomcat.
    • Implemented Tableau server administration and dashboard development.
    • Created ODS and DWH marts.
    • Worked on ETL procedures.
    • Worked as a SQL DBA and implemented performance tuning.
    • Worked as a Tableau developer (primarily as a full-stack developer using Java, SQL, and DWH).
    • Created an API based on Java microservices.
    Technologies: Microsoft SQL, BI, MySQL, Tableau, Google Data Studio, Java 8, HTML, CSS, Angular, PHP, Tomcat, Apache
  • Senior Architect

    2016 - 2018
    • Worked with an Oracle, MS SQL, and Informatica Power Center data warehouse.
    • Reported to all bank departments via the intranet.
    • Implemented process analysis and development.
    • Analyzed performances.
    • Performed PL/SQL and Java code optimization.
    • Analyzed and optimized SQL code.
    • Developed intranet reporting tools.
    • Implemented a MS SQL data acquisition.
    • Worked on ETL procedures.
    • Created reports using Perl, Python, and SQL.
    • Implemented ESB.
    • Designed the SOA architecture.
    • Created an API based on Java microservices.
    Technologies: Oracle, PL/SQL, Informatica PowerCenter, Java, Perl, HTML, CSS, AngularJS, React
  • Freelance Technical Writer (Data-related Topics)

    2017 - 2017
    IOD (via Toptal)
    • Wrote technical advice about Redshift queues and queries optimization.
    • Optimized Redshift user parameters to achieve an optimal performance of big data queries.
    Technologies: Amazon Redshift
  • Analyst | Oracle Developer

    2014 - 2016
    • Built a billing system.
    • Developed a CRM system.
    • Created a rights management system.
    • Performed analysis, development, and optimization of PL/SQL, SQL, and Java code.
    • Designed and developed the Advice System (for a call center)  based on Java and MongoDB including contextual search based on a customer's history and preferences.
    • Developed an internal system (CRM, selling platform, and others) using PL/SQL, Java, AngularJS, CSS, HTML, JavaScript, and some PHP.
    • Built an access management system (Nagra).
    • Created an API based on Java microservices.
    • Developed CRM processes using Java and Elasticsearch.
    Technologies: Oracle, Java, AngularJS, JavaScript, HTML, CSS
  • Solution Architect | Business Analyst

    2013 - 2014
    Orange S.A. (a Telecom)
    • Built an ERP system (industrial and financing system).
    • Developed with Oracle DWH and Oracle OWB.
    • Created a storage and reporting system for whole telecom including a sell forecasting system.
    • Acted as a company's solution architect during a merger of a Polish telecommunication joint-stock company and Orange S.A.
    • Created an API based on Java microservices.
    Technologies: Oracle, Reporting, Java
  • Technical Adviser to the President

    2000 - 2013
    • Managed and developed a wide range of systems and applications for TV Polsat.
    Technologies: Oracle, Java, MS SQL, TV Streaming, ERP, SAP, CRM


  • WiMAX Project for the Whole Country (Development)

    This project of the WiMAX network covers the whole country area including financial and technical analysis.

  • DataWarehouse and BI Solution for AGB Nielsen (Development)

    I developed a data warehouse and BI solution for AGB Nielsen based on their own DWH architecture and reports; I also used BI.

  • Data Warehouse Design for a Bank (HypoBank) (Development)

    I created the data warehouse design for a bank acquiring data from all of the processing systems.


  • Languages

    JavaScript, Java, SQL, HTML/CSS, Python, Ruby, T-SQL, Snowflake, Python 3, HTML, CSS, Elixir, Perl, Excel VBA, XHTML, Objective-C, PHP 7, PHP, VB, Visual Basic for Applications (VBA)
  • Frameworks

    Bootstrap, Angular, Swagger, Ruby on Rails (RoR), Adobe Flex, Android Bootstrap, Bootstrap 2, Bootstrap 3, Bootstrap 4, JavaServer Faces, JavaServer Pages (JSP), Android SDK, JPA, iOS SDK, Spark, Apache Spark
  • Tools

    MySQL Workbench, Tableau Desktop Pro, Informatica PowerCenter, Informatica ETL, Flash, Matillion ETL for Redshift, Tableau, AWS SDK, Google Analytics, Oracle Application Express (APEX), Eclipse IDE, Oracle Business Process Management (BPM), Talend ETL, Microsoft Power BI, Adobe Flash, Flash Builder, Microsoft Access, SAP Hybris, GitHub, Subversion (SVN), Spark SQL, AWS Glue, Apache Airflow, SoapUI, WinSCP, Bower, Postman
  • Paradigms

    SOA, W3C, Database-driven Web App Development, Business Intelligence (BI), ETL, ETL Implementation & Design, Database Design, PRINCE2, REST, Agile Software Development, Continuous Integration (CI), Continuous Delivery (CD), Continuous Deployment, Oracle ODI
  • Platforms

    Oracle, Azure, Amazon Web Services (AWS), Java EE, Android, JSE, NetBeans, Linux, Azure IaaS, AWS EC2, AWS Cloud Computing Services, Windows, iOS, Salesforce
  • Storage

    AWS RDS, SQL Workbench, PostgreSQL, PL/SQL Developer, SQL Server 2012, Microsoft SQL Server, SQL Server 2008, PostgreSQL 10.1, SQL Server 2016, MySQL, SQLite, Oracle 12c, Oracle PL/SQL, JSON, Oracle 11g, PL/SQL, SQL Stored Procedures, Database Modeling, Database Triggers, Oracle Database Tuning, Elasticsearch, Redshift, Databases, Azure SQL, SQL Azure, Google Cloud, Google Cloud SQL, MariaDB, SQL Performance, JSON/XML Schemas, MongoDB, AWS S3, NoSQL, SQL Server Management Studio, Azure Queue, Azure SQL Databases, Data Pipelines, RDBMS, SQL Server DBA, Spring Data JPA
  • Other

    Excel, Google Data Studio, Data Warehousing, Data Warehouse Design, ETL Development, ITIL V3 Foundation Certified, Database Analytics, Informatica Data Quality, Data Analysis, Database Optimization, SaaS, Software as a Service (SaaS), Big Data, Performance Tuning, Enterprise Service Bus (ESB), Architecture, CTO, Data Warehouse, Back-end, AWS, Tableau Server, SOAP, DHTML, Reverse Engineering, Data Visualization, Angular Bootstrap, Financial Data Analytics, SAP, SAP ERP, Pipelines, Cloud, Front-end, Oracle RMAN
  • Libraries/APIs

    Spring REST, REST APIs, PySpark, RESTXQ, React, Node.js, iOS API, jQuery, ReactXP


  • Postgraduate work in Red Hat Administration
    2013 - 2014
    Technical University of Lodz - Łódź, Poland
  • Postgraduate work in Java EE Business Applications
    2012 - 2013
    Technical University of Lodz - Łódź, Poland
  • Postgraduate work in Mechatronics and Information Systems (Java, Oracle, Oracle Warehouse, JSP, PHP, MS-SQL, IBM DB2)
    2010 - 2011
    Technical University of Lodz - Łódź, Poland
  • Master of Business Administration (MBA) degree in Marketing and Management
    2003 - 2004
    Kozminski University - Warsaw, Poland
  • PhD degree in Technical Physics, Information Technology and Applied Mathematics
    1986 - 1988
    Technical University of Lodz - Łódź, Poland
  • Master of Science degree in Electronics (Digital and Analog Devices)
    1981 - 1986
    Technical University of Lodz - Łódź, Poland


  • ITIL in IT Management
    APMG International
  • Oracle BI Enterprise Edition
    JULY 2017 - PRESENT
  • Android Certified Application Developer
    JUNE 2015 - PRESENT
  • Oracle Certified Professional, Java SE Programmer
  • Oracle PL/SQL Advanced
  • RH124 - Red Hat System Administration
  • OMG UML Certified Professional
  • Oracle OCA Administration
  • Prince2
    JULY 2012 - PRESENT
    APMG International

To view more profiles

Join Toptal
Share it with others