BI Analyst & DWH Developer

Die Kandidatin ist eine erfahrene Data-Warehouse-Spezialistin, die seit über 25 Jahren mit Datenbanken arbeitet. In ihrer letzten Position nahm sie Änderungen an der Datenbankprogrammierung vor, war für den Betrieb der Oracle-Datenbank und die Fehlerbehebung zuständig, erstellte neue Berichte und Exporte und unterstützte die Migration zu DataLak. Während ihrer Arbeit verwendete sie hauptsächlich: Oracle SQL, PL/SQL, PostgreSQL und PL/pgSQL, Amazon Redshift SQL, ETL, Confluece. Da sie in ihrer letzten Position in einem ausländischen Unternehmen arbeitete, in dem sie täglich Englisch benutzte, war die Kommunikation auf Englisch kein Problem für sie. Die Kandidatin koordinierte ein Team in Europa, das aus 3 Datenbankspezialisten bestand.

Jun. 2019 - May 2021 - Database Developer - Company A

• Developed databases for applications using Oracle SQL and PL/SQL, PostgreSQL and PL/PGSQL, and Amazon Redshift SQL.
• Created ETL processes for data warehouse and data lake using stored code, SQL, and shell scripting.
• Ensured data quality and consistency.
• Developed data lake reporting datamarts and data exports using Amazon Redshift, SQL, and Unix shell scripting.
• Scheduled export files generation using Airflow.
• Migrated Oracle database stored code to PostgreSQL and Oracle DWH to AWS Datalake.
• Deployed to production and pre-production environments using Liquibase, Jenkins, SQL Developer, and DBeaver.
• Supported Java development and testing teams and onboarded new team members.
• Coordinated and shared knowledge with the European part of the database team and created documentation using Confluence.

Sep. 2018 - Dec. 2018 - DWH Developer - Company B

• Exported data mappings from Power Designer and imported them into ODI for testing.
• Prepared and maintained operational and user documentation.

Feb. 2018 - Apr. 2018 - Database Developer - Company C

• Developed applications using T-SQL.

Sep. 2010 - June 2017 - DWH Developer - Company D

• Gathered user requirements, analyzed them, and prepared technical specifications.
• Designed and developed DWH solutions using Oracle SQL, PL/SQL, and AIX Unix shell scripts.
• Tested and deployed solutions into production environment.
• Improved data quality and performed data migration.
• Administered and maintained Oracle DWH databases, including performance tuning and security management.
• Operated and maintained ETL processes using ODI, configured workflows, and managed access rights.
• Provided technical advisory, prepared documentation, and trained employees.
• Led a team.

May 2008 - Sep. 2009 - Application Design Architect - Company E

• Implemented and provided post-implementation support for the new information system of the Social Insurance Agency in Slovakia (EZU).
• Integrated systems and gathered user requirements.
• Prepared technical documentation.