02/12/2024 updated

**** ******** ****
100 % available

ETL DWH Senior Consultant

Częstochowa, Poland
Only remote
MSC. Information Technology
Częstochowa, Poland
Only remote
MSC. Information Technology

Profile attachments

CV - Mariusz Sil

Atlassian JiraExtract Transform Load (ETL)Data TransformationData ModelingData WarehousingIBM InfoSphere DataStagePython (Programming Language)Microsoft SQL ServersOracle DatabasesPL-SQLSQL Server Integration ServicesTransact-SQLInformatica Powercenter
Bash, business logic, C#, Cloud, configuration management, CorelDraw, customer data, data discovery, Data import/export, Data import, data extract, data flow, Datawarehouse, EDW, Database model, database, ETL, ETL development, ETL tools, ETL process, user interaction, DB2, DataStage, Computer Science, J2EE, Microstrategy, SQL Server, SQL Server 2016, SQL Server 2014, SQL Server 2012, MS Visio, MySQL, MySQL database, router, Oracle, Oracle 11g, 12c, Oracle Database, PL-SQL, PL SQL, Pentaho, Performance tuning, PowerBI, Programming languages, RSA, reference data, Remote Access, SQL, sql script, SSIS, bugs, system analysis, System Architect, Teradata, T-SQL, PowerShell, Workday

Languages

GermanGoodEnglishFluentPolishNative speaker

Project history

ETL Datastage Developer

Diageo
DESCRIPTION: In Diageo I'm working as ETL datastage developer, and adivisng on dwh model. My
activities were focused on early stages of data extract from sources thrugh running extraction jobs
scheduled automatically. I also designed staging area tables and build target tables from business
report requirements. Some activities also includes detailed documentation.
INDUSTRY TYPE: Alcoholic Beverages, Retail
* ETL: Designer, Director, Quality Stage
* DataStage: Building jobs and workflows
* Analysis of dwh model

ETL SQL Server and PowerBI Developer

Tesla
DESCRIPTION: In Tesla I'm working as an ETL developer for Finance reporting processes. My activities
are analysis, data discovery/preparation, and PowerBI reports/dashboards development.
INDUSTRY TYPE: Finance Reporting
* ETL modules: SQL Server 2016 T-SQL development
* Development PowerBI dashb
* Deployment and scheduling for datasets

ETL SSIS Developer

ABB
DESCRIPTION: In ABB I'm working as a SSIS ETL developer for Workday HR reporting. My activities are
converting and implementing business logic for PROD system, deploying and testing data quality.
INDUSTRY TYPE: HR and Staff Reporting
* ETL modules: SSIS data flow, control flows
* Development data jobs and workflows
* Data import/export to inhouse reporting Workday
* SQL Server 2016 T-SQL and analysis

ETL Informatica Developer

FOX
DESCRIPTION: In FOX Broadcasting Corporation I'm working as an Informatica 9.x Developer. Main ETL
activities was to maintain and develop new mappings in Informatica for NAT GEO channel for daily
data load, Data quality and customer support. I also optimized exsiting SQL Server scripts to meet
performance requirements through using Indexes and incremental load methodologies.
INDUSTRY TYPE: TV Broadcasting
* Informatica ETL development
* Fixing ETL mappings, sessions, and workflows bugs
* Analysis of DQ issues for TV, VOD, HULU, Foxnow data

ETL SSIS Developer

Shoppers Drug Mart
DESCRIPTION: In Shoppers Drug Mart I'm working as an SSIS Developer, and Database Administrator,
integrating 8 sources into MicroStrategy reporting system using SSIS ETL. Often searching for ETL
bugs/workflow optimization and fixing technical issues. I proposed solution for Upsert strategy in
SSIS, Sort transformation optimization and executed DEV, UAT,PRD SSIS environment migrations
INDUSTRY TYPE: Retail/PharmaceuticalSSIS ETL development
* SQL Server 2012 database admin,sql
* Analysing data quality issues
* Fixing ETL mapping, sessions, and workflows bugs

ETL Datastage Developer

Lloyds Pharmacy
DESCRIPTION: In Lloyds Pharmacy I'm working as an DataStage ETL data extract solution proposal and
POC for building PDC algorithm within MicroStrategy tool Database developer/MicroStrategy Architect.
I analysed and imported 3rd party data internally, and. I also did some ETL import to inhouse dwh
* INDUSTRY TYPE: Retail/Pharmaceutical
*
* ETL: Designer, Director, Quality Stage
* DataStage: Building jobs and workflows
* Data import to inhouse reporting
* SQL Server 2012/Oracle dwh model development

ETL Informatica Developer

Dallas Airport
DESCRIPTION: In DFW Dallas Airport I'm working as an Informatia Developer, and Database
Administrator, integrating several universes into MicroStrategy EDW system. Apart from regular ETL
I'm also involved in designing and running sql script for Source, Staging, and Terget tables. Often
searching for ETL bugs and fixing reporting/dat issues.
INDUSTRY TYPE: Airport Services
* Informatica 9.0 ETL development
* Oracle Database Administrator
* Analysing data quality issues
* Fixing ETL mapping, sessions, and workflows bugs

ETL Developer / System Architect/ BI Technical Analyst

DHL
DESCRIPTION: Business Area Review system, for reporting purposes, directly used by management. I was
responsible for system analysis, PL-SQL, ETL like transformations in Oracle DWH, source systems ETLs
preparations, first line of user support, J2EE reporting applications maintenance and administration
INDUSTRY TYPE: Asset Management
* Supporting Oracle aviation DWH system
* QA, reference data issues resolving
* Participating in analysis changes DWH model
* Developing ETL logic (JDATA, Pentaho)
* J2EE application (report tool for users) development, troubleshooting
* On-demand modifications, configuration management
* First Line technical user support
* Serving as liaison between database admin, developers and end users
* Creating system schemas, data-flows, references
* Database model (Power Designer, CorelDraw, MS Visio), documentation creating

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in