Roman Reiter
Data Engineer at Joyful Craftsmen- Claim this Profile
Click to upgrade to our gold package
for the full feature experience.
Topline Score
Bio
Credentials
-
1Z0-061: Oracle Database 12c: SQL Fundamentals
OracleMay, 2019- Nov, 2024 -
Academy Accreditation - Databricks Lakehouse Fundamentals
DatabricksMay, 2023- Nov, 2024
Experience
-
Joyful Craftsmen
-
Czechia
-
IT Services and IT Consulting
-
1 - 100 Employee
-
Data Engineer
-
May 2023 - Present
-
-
-
Solitea, a.s.
-
Czechia
-
IT Services and IT Consulting
-
400 - 500 Employee
-
BI/DWH Consultant
-
Jun 2022 - Mar 2023
Development of the data warehouse based on the requirements specified by the business, preparation of dynamic scripts for the maintenance of the existing solution. Development of the data warehouse based on the requirements specified by the business, preparation of dynamic scripts for the maintenance of the existing solution.
-
-
-
Neit Consulting
-
Czechia
-
IT Services and IT Consulting
-
1 - 100 Employee
-
BI/DWH consultant
-
May 2019 - May 2022
Collaborating on a project to deliver a new DWH / BI solution for consolidating data from various source systems from architecture development, creating a single data dictionary, developing ETLs and processes via T-SQL. Creating an L1 layer that implements Data Vault 2.0 methodology. The project is managed by agile methodology. • Agile driven development • Development of mapping in T-SQL for transmission to L1 (Core) layer, L2 layer (Mart) • Development of tables in the L1 (Core) layer according to the Data Vault 2.0 standard • Mapping testing, T-SQL procedures • Performance tuning and mapping optimization in T-SQL • Analysis and consultation with business analysis in development Show less
-
-
-
Česká spořitelna
-
Czechia
-
Banking
-
700 & Above Employee
-
BI Developer/Analyst
-
Jul 2017 - Apr 2019
My main responsibility is loading the Data from Source Systems into an Analytical Repository as the Background data for Reporting.Partial Tasks are:- ETL Development in Oracle Data Integrator. - Preparing and designing the ETL processes - Creating migration Load Plans in Operational Console.- Creating and editing Models in PowerDesigner- Analyzing Incidents on ETL / ETL processes
-
-
BI Specialist
-
Oct 2015 - Jun 2017
An Operative work with a BI portal on Attlassian Confluence. Export/Import of metadata from Data Warehouse and then visualitaion of metada at BI portal. Managing rights for users in JIRA and correctly assigning requirements to the supplier team. Developing a Data Quality Checks based on Business Rules.
-
-
Software tester
-
Sep 2015 - Oct 2015
-
-
Education
-
Česká zemědělská univerzita v Praze
Informatika, 3 -
Free Code Camp
Full Stack Web Development Certification, Computer Software Engeneering