fb-pixel

Location

Poland

Rate

$36  / per hour

Years of experience

20+

About

A seasoned IT professional with a robust background in database systems and data warehousing. The candidate has demonstrated extensive expertise in building and maintaining data architectures that integrate both relational and unstructured data sources. The work spans from hands-on technical development to high-level system design and project management. Notably, the professional has contributed to significant projects in data virtualization, ETL processes, and data warehouse development for high-profile clients across various industries including banking, media, and pharmaceuticals. The skills are underpinned by advanced certifications such as Data Vault 2.0, ITIL Foundation, and SAP Certified Development Associate, alongside a deep theoretical and practical understanding of data management technologies. Over the years, the candidate has taken on roles that required the creation and optimization of data processes, demonstrating a particular strength in using technologies like Informatica Powercenter, Oracle, and Spark within complex data environments. They have engaged in comprehensive training and self-study, staying current with industry trends through courses like "The Ultimate Hands-On Hadoop" and Azure fundamentals. This continual learning trajectory highlights their commitment to professional growth and adaptability in the evolving IT landscape. The project experience reveals a capability to manage teams, design scalable data solutions, and deliver results that align with strategic business objectives, making them a valuable asset for roles that require both technical prowess and strategic insight.

Tech Stack

Informatica, AWS, Azure, Jenkins, Python, Spark, SQL

Experience

  • Led the building of various layers of data warehouses, including Data Staging Area (DSA), Enterprise Data Warehouse (EDW), and data marts using Informatica Powercenter and integrating technologies like Netezza and MSSQL.
  • Designed and implemented ETL processes, optimizing data flow from various source systems into data warehouses. This involved complex SQL coding, performance tuning, and ensuring data integrity during transfers.
  • Managed projects focused on data virtualization, integrating large datasets from disparate data warehouses and other sources for a global FMCG client using technologies like Cisco Integration Server and Vertica.
  • Led technical teams, overseeing project delivery, scheduling, and resource allocation. Responsible for educating team members technically and verifying solutions provided by suppliers.
  • Performed deep analysis of source data to create or clarify requirements, designed data flows and dimensional models, and provided third-level support and incident resolution.
  • Conducted knowledge transfer sessions and educated co-workers on new functionalities, promoting best practices in database management and data warehousing.
  • Responsible for continuous improvement of system processes, including the redesign of data aggregates, optimization of ETL components, and enhancement of overall system performance to meet business needs.

Employment history

Data Engineer, Ework April 2020 - June 2020 1. Business purpose: Creating analytical tables for data scientists over core data lake
Team: 9
Responsibilities: Building ETL scripts over core data lake to prepare data for data scientist’s analysis (analytical base table on sales data), validating extracts, spark optimization
Technologies: Spark (Azure Databricks), Python (spark data frames, little of pandas) - jupyter notebook & py modules , SQL, DBFS
2. Business purpose: ETL on media data
Team: 7
Responsibilities: Building ETL over media data to cover reporting needs
Technologies: Cloudera EDH on AWS, Hue (Hive/Impala), Python, SQL
Senior Informatica Developer - Expert, Ework (contract) May 2018 – up to date Business purpose: Banking data warehouse development and maintenance
Team: 9 people
Responsibilities:
Building various layers of data warehouse – DSA – EDW (Data Vault) and data marts, unit testing, solving incidents, working according to agile (SAFe)
Technologies: Informatica Powercenter 9.5 & 10.2, Netezza, MSSQL, DB2, Tivoli Scheduler, Jenkins, Mercurial, SVN, Remedy, HP ALM, Informatica DVO
ETL Developer (Expert/Senior), Relyon (contract) September 2016 – April 2018 Business purpose: 1.Data virtualization 2. Building data staging area
Team: 12 people
Responsibilities:
Project 1: Data virtualization
Integrating data and building layers over huge amount of data from data warehouse among other sources for global FMCG client.
Technologies: Vertica, Cisco Integration Server – Studio, control-m, dBeaver, SQL, Unix
Project 2: Building corporate data warehouse
Analysis of source data, building of data staging area, unit testing, leading and educating technically team members, verifying supplier solutions, optimizing processes, Kimball methodology
Technologies: Oracle 12g, Informatica Powercenter 9.6, Unix, Custom scheduling tool, SQL, PL/SQL
Senior IM Consultant, Data Warehouse Developer, Dong Energy March 2012 – August 2016 Business purpose: Creating enterprise data warehouse platform
Team: 8 people
Responsibilities:
Designing and Creating ETL processes to move new data sources into ODS, OWB experts creating for various purposes including ETL and dimensional model (type1, type2 dimensions, fact – Kimball model), performing analysis of source data in order to create/clarify requirements and design flows and dma schemas, unit testing, assisting testing team in their tests, documentation creation, technical leading of younger team members in they every day work, 3rd level support, incidents solving, processes optimization
Technologies: Oracle 11g (SQL, PL/SQL), Oracle Warehouse Builder 11g, Erwin, Control-M, Business Objects
Senior Oracle Consultant, Econsulting/Roche Senior DW Developer (contract) June 2008 – February 2012 Several projects for global pharma corporation
Business purpose: Data migration and development of reporting database
Team: 11 people
Responsibilities:
Verifying of migration processes, development of new reporting and migration procedures, unit test conduction, technical documentation writing, tuning of PL/SQL database procedures, dividing and monitoring of tasks within system dedicated subteam, assisting team colleagues in the design, development and solving technical issues, designing and implementing various ETL processes (Informatica Powercenter 8.6)
Technologies: Oracle 9i, 10g, 11g (SQL, PL/SQL), TOAD, Informatica Powercenter 8.6,Unix , Test Director and Quality Center, Oracle Forms & Reports, SVN
Data Warehousing/Oracle Consultant, IT Kontrakt/Warta (contract) September 2007 – May 2008 Business purpose: Premium simulation analysis and staging data preparation
Team: 7-10 people
Responsibilities:
Analysis of financial premium simulation process, designing solutions of new staging modules and creating adequate procedures.
Technologies: Oracle 9i (SQL, PL/SQL), SQL Developer, Oracle Discoverer, Business Objects
Analyst, Roche – process re-engineering project May 2007 – September 2007 Business purpose: Process reengineering
Team: 5 people
Responsibilities:
Analysis and verification of existing documentation, proposing new solution alternatives, creating System Delivery Specification including detailed process documentation including UML diagrams.
Technologies: System Architect (UML), Test Director
WebSphere Commerce Developer, e-Shop for Econsulting WebSphere Commerce implementation project June 2006 – August 2006 Business purpose: Enable Internet sales of the books – B2C and B2B e-Shop
Team: 3 people
Responsibilities: Implmenting B2C and B2B e-commerce solutions to enable Internet sales of books, utilizing Java/J2EE, JSP, WebSphere Commerce, and Oracle technologies to develop robust online shopping platforms.
Technologies: Java/J2EE JSP, WebSphere Commerce, Oracle
Data Warehousing Specialist, ETL project for Mach Business purpose: Backend and data model changes to ETL process
Team: 7-10 people
Responsibilities:
System maintenance & administration, new functions development, creation and rewriting of extraction triggers, SQL code optimization, defining various parts of ETL process according to company’s standards and methodologies (Kimbal’s approach to
Data warehouse), understanding and usage of basic terms used in telecommunications industry (GSM industry), analysis of aggregates and their optimization (and re-design), writing of migration scripts, knowledge handover and co-workers education.
Technologies: Oracle 9i (SQL and PL/SQL), 10g, SVN, Microstrategy
Oracle Developer, eBusiness Suite project for Allianz March 2005 – March 2006 Business purpose: Development and maintenance of new modules in eBS
Team: 7 people
Responsibilities:
Creating various customizations to general ledger, payables and receivables modules including new reports, inspection of error sources upon user complaints.
Technologies: Oracle 9i, Oracle Forms & Reports 6i, PL/SQL, SQL, Oracle eBS
Oracle Developer, Agent information system for Allianz March 2004 – March 2005 Business purpose: Development of new parts of agent’s information system with interfaces
Team: 7 people
Responsibilities:
Migration of data from one database system to another, re-writing of Access ’97 application (agents information system) in Oracle Forms 6i, database design for new application modules within the agents information system, reading of payment files into the Oracle Financials database, preparation of Oracle Forms 6i migration to Oracle Forms 10g and UNIX shell scripts for various functions.
Technologies: Oracle 8i, Oracle 9i, Oracle Forms & Reports 6i, PL/SQL, SQL, Access, VSS, JDeveloper, XSLT
DWH Developer, Data Warehouse project for water treatment measurements –project for Polish IBM Business Partner April 2005 – August 2005 Business purpose: Data warehouse implementation
Team: 1 person
Responsibilities:
Recognition of warehousing tools possibilities, data warehouse design and implementation and creation of reports using Alphablox (JSP).
Technologies: Data warehousing tools, DB2, JSP, Alphablox, Websphere, Linux Red-Hat (RHEL 4)
J2EE Developer, Customer e-Shop for a Polish IBM Business Partner February 2005 – March 2005 Business purpose: Deploying custom e-shop
Team: 4 people
Responsibilities:
Custom modifications of existing JSP pages and implementation of new views in e-shop.
Technologies: Oracle 10g, WebSphere Application Server v.6, IBM WebSphere Commerce, JSP
Developer, University project November 2004 – January 2005 Business purpose: Jotter and Calendar Emulation
Responsibilities:
Design and implementation of EJB (Session and entity Beans) to cover the necessary functionality of meeting the appointment and reminder functions plus among others jotter browser and development of JSP’s and Servlet’s in order to create user interface
for the application.
Technologies: Cloudscape database, JSPs, Servlets, HTML, XSLT, EJB
Developer, Jac August 2003 – August 2004 Business purpose: Creation of CRM Application
Responsibilities:
Database design for CRM application, creation of web application with various user groups, admin functions to be later administered by an application admin.
Technologies: Postgres, PG PL/SQL, SQL, HTML, PHP, JavaScript, CSS
Oracle Developer, Polpharma September 2003 – February 2004 Business purpose: Oracle Applications implementation
Team: 15-25 people
Responsibilities:
Preparation of Oracle forms modules – embedded into the Oracle eBS structure for later migration upon the complete implementation of Oracle eBS, customizations of production and WMS forms in the core of the Oracle eBS and remodeling of business logic to satisfy the production and warehouse users – identification of API’s used, creation of additional
API’s.
Technologies: Oracle 9i, Oracle Forms & Reports 6i, PL/SQL, SQL, Oracle e-Business Suite Production & Warehouse Management (WMS) modules
Developer, Melog July 2003 – September 2003 Responsibilities:
Fully object-oriented programming of main portal modules and re-make of the presentation layer, custom creation of estate agents portals based on a template and Remake of various search engines.
Technologies: PHP, Javascript, MySQL, CVS, Linux
Developer, Maxsoft June 2002 – April 2003 Business purpose: Development of Equipment life-cycle management application
Team: 7 people
Responsibilities:
The application managed full life-cycle of the equipment spread all over Poland. The major functional areas were: equipment description, amortization, accounting, invoicing and other customer-specific functions. The application was accessible both from the fatclient as well as through intranet. My personal responsibilities included: database structure design for specified modules
and reports using Oracle Designer, implementation of modules and reports using Oracle tools, web modules creation for the intranet portal of the Office of Technical Inspection and remote installation of Oracle modules and reports for the different offices in Poland.
Technologies: Oracle 8i, Oracle Forms & Reports 4.5 & 6i, PL/SQL,SQL, HTML, PHP, Javascript, Oracle Designer

Education history

Polish-Japanese Institute of Information Technology, Warsaw, Poland 1996 - 2002 University education, degrees
Polish-Japanese Institute of Information Technology, Warsaw, Poland
Bachelor of Science, graduated with honours
Focus: Database systems

Polish-Japanese Institute of Information Technology, Warsaw, Poland
Master of Science – studies completed, diploma not defended
Focus: Database systems
Download profile as PDF

We’ve helped 83 clients with IT recruitment and software development.

Read about a few of them below...

DevsData LLC Reviews 5.0 stars 37 reviews
Powered byClutch logo
Powered byClutch logo
See more testimonials
Similar blind CVs/resumes
Poland

SQL Server Developer Resume Sample

Senior Data Engineer with extensive experience in developing and optimizing ETL processes..
SQL-icon
SQL
Azure-icon
Azure
ETL
PostgreSQL-icon
PostgreSQL
Python-icon
Python
Rate $37  /  per hour
Poland

Sr Java Developer Resume Sample

An experienced developer with a diverse background in multiple programming languages, including Java, Go, and NodeJS.
Java-icon
Java
Angular-icon
Angular
AWS-icon
AWS
MySQL-icon
MySQL
Spring Framework
Rate $40  /  per hour
Poland

Python Full Stack Developer Resume Sample

A skilled Python developer with a strong background in web development, data processing, and automation.
Python-icon
Python
AWS-icon
AWS
Azure-icon
Azure
Azure DevOps
Django-icon
Django
Git-icon
Git
JavaScript-icon
JavaScript
REST APIs
Rate $18  /  per hour
Poland

Freelance Developer Resume Sample

A full-stack software engineer with extensive experience in web development, data processing, and scalable systems.
Freelance
CSS-icon
CSS
Frontend
Git-icon
Git
HTML-icon
HTML
JavaScript-icon
JavaScript
Python-icon
Python
SQL-icon
SQL
Rate 35$  /  per hour
Poland

Oracle SQL Developer Resume Sample

An analytical software engineer with over eight years of experience as a Solution Architect
Oracle
JavaScript-icon
JavaScript
PL/SQL
SQL-icon
SQL
XML-icon
XML
Rate $55  /  per hour
Poland

ABAP Developer Resume Sample

With an academic background and extensive professional experience specializing in SAP ABAP development.
SAP
C#-icon
C#
Java-icon
Java
JavaScript-icon
JavaScript
Python-icon
Python
Rate $43  /  per hour
Poland

Engineering Manager Resume Sample

An experienced Senior Engineering Manager with a robust background in software development and team leadership.
Microsoft Teams
Asana
Jira
Slack
Trello
Rate $15  /  per hour
Poland

Business Analyst Sample Resume

Business-System Analyst with extensive experience in requirements gathering, process automation, and system integration.
Business Analyst (BA)
BPMN
Microsoft 365
UML
Rate $22  /  per hour
Poland

Vue js Developer Resume Sample

A software engineer specializing in JavaScript with a strong passion for building (UI) and (UX) for web applications.
Vue-icon
Vue
CSS-icon
CSS
GraphQL-icon
GraphQL
HTML-icon
HTML
JavaScript-icon
JavaScript
REST APIs
Rate $54  /  per hour

I agree to and accept that DevsData LLC will provide better user experience by collecting, analyzing and cataloging information about Internet electronic addresses that I have connected with my devices and about the type of my devices (such as the type and version of software) as well as by making automatic decisions (not involving sensitive data). The agreement applies for the legally binding period, or until either the user or DevsData LLC withdraws from the agreement. Withdrawing from the agreement will result in removing the user's data. Please see our privacy policy.

We use cookies to provide the best experience for you. >More about cookie policyarrow

Book a call with our team

For software development projects, minimum engagement is $15,000.

whatsapp
Prefer email?
Quote mark

Best back-end engineers I've ever worked with...​

“I interviewed about a dozen different firms. DevsData LLC is truly exceptional – their backend developers are some of the best I’ve ever worked with. I’ve worked with a lot of very well-qualified developers, locally in San Francisco, and remotely, so that is not a compliment I offer lightly. I appreciate their depth of knowledge and their ability to get things done quickly. “

Avatar

Nicholas Johnson

CEO OF ORANGE CHARGER LLC;

MENTOR AT YCOMBINATOR

Success

Thank you


We'll get back to you within 1 business day.