Martin Zálepa

About

Highly skilled in the design and development of Data Warehouses (DWH) with a deep understanding of complex DWH architectures. Proficient in Agile methodologies, adeptly contributing across multiple squads. Offers comprehensive expertise in delivering end-to-end solutions, from problem analysis and data modeling to implementing ETL solutions. Proactive and organized, with excellent communication abilities. Demonstrates leadership in driving and facilitating discussions, synthesizing information, and providing valuable recommendations. Possesses a holistic perspective to address challenges effectively.

Experience

• Senior Business Intelligence Developer · CSOB Insurance09-01-2020

  Developed and implemented ETL scripts in Teradata, leveraging comprehensive models and detailed business documentation. Enhanced ETL performance by optimizing scripts to resolve high skew, reduce CPU usage, and shorten processing times. Executed advanced data modeling in third normal form utilizing Teradata's Financial Services Logical Data Model (FSLDM) and PowerDesigner. Spearheaded DWH automation initiatives using Python, encompassing development, rigorous unit testing, and meticulous data lineage control.

• Data Engineer · Organon11-01-2023 – 02-01-2024

  Migration of an end-to-end data solution from AWS to Snowflake, ensuring seamless transition and optimization. Proposed a new architecture for the migration to Snowflake, focusing on efficiency and scalability. Designed and developed the new solution, converting PySpark scripts and Lambda functions into Snowflake stored procedures, tasks, and materialized views, external tables.

• Business Intelligence Developer · O2 Telecommunication09-01-2017 – 10-01-2020

  Implementation of Oracle GoldenGate technology into DWH Responsibility for the creation of real-time data stream solution into DWH from source databases (Oracle to Teradata) Model-driven development using BI tools such as PowerDesigner, Impact Analyser, UDI Development of a templated framework for code generation. (Using UDI and Groovy) Responsible for initial loadings, error handling, and performance optimization

• Business Intelligence Developer · Commercial Bank09-01-2016 – 06-01-2017

  Designed and developed Data Warehouses (DWH) on the Teradata platform for various African countries. Implemented, tested, and documented code to ensure high-quality and reliable solutions. Developed and optimized ETL processes using Informatica PowerCenter to streamline data integration and transformation.

• Data Analyst · Actum Digital09-01-2015 – 09-01-2016

  Collaborated closely with clients to develop optimal recipient lists for targeted customer outreach with current offers. Generated and delivered monthly and ad hoc reports tailored to the needs of final clients. Ensured accuracy and relevance of reports to support client decision-making and marketing strategies. Maintained effective communication with clients to understand their requirements and provide data-driven insights.

Education

• University of Economics PragueMaster of science, Information Systems And Technologies
• University of Economics PragueBachelor of Science, Applied Informatics

Similar talent on Pangea

AAmy W.Data Expert Specializing in Analysis, Engineering, and Integration | Analytics Engineer & Data Platform Builder4905 Geraz do Lima, PortugalRoyden C.Transformation | Business Operations | Business Analysis | Data Analysis | AnalyticsMeghana G.Senior Data Engineer | Analytics Engineering & ELT Pipelines (dbt, Snowflake, AWS)Boston, MAJulian R.Business Intelligence (BI) Analyst | Power BI, SQL & KPI/Analytics (7+ Years)Bogotá, Bogota