Mihai A. - Senior ETL Developer | Team Lead

Go to Website

Măgurele, Romania

Experience

Mar 2022 - Jul 2024

2 years 5 months

Bucharest, Romania

Senior ETL Developer | Team Lead

Unicredit Bank Austria

Handling and managing Data warehousing system with emphasis on Business Requirements Analysis, Application Design, Development, coding, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems.
Developed complex Teradata SQL code in BTEQ script using OLAP and aggregate functions, analitical functions and recursive CTE’s.
Extensive knowledge with Teradata SQL Assistant and Teradata Viewpoint.
Building recursive and iterative algorithms using teradata store procedures and python.
Unix for file handling on server side.
Host on Demand for scheduling and run processes.
Datastage - used as wrapper for scripts triggering.
ALM QC.
SVN and GIT.
Basic skills also on cloud computing:
ADF (Azure Data Factory)
ADLS
Python
Databricks (SparkSQL and PySpark)
Azure Synapse Analitycs.

Nov 2020 - Dec 2023

3 years 2 months

Bucharest, Romania

Data Warehouse Engineer

Deutsche Bank

Design, develop, test and support new capabilities and ongoing changes within the various application data marts using Informatica Power Center and Oracle Sql & PL/SQL (packages & procedures).
Design and develop:
Workflows
Worklets
Mappings
Mapplets
Sessions
Tasks
Transformations
Jira, SVN, ALM QC, GitHub, TeamCity/Jenkins.
Unix, Unix Shell.
Perform & implement tuning processes.
Use ControlM for simplifing application and data workflow orchestration on premises or as a service.
Agile, Scrum methodology.
Cognos for business reporting.
Extracting data from Oracle, DB2, csv, flat files, JSON, etc.
TOAD, Sql Developer.
Assisted in the design and development of SCD type1 and type2 mappings improving the efficiency of ETL Jobs.

Oct 2019 - Nov 2020

1 year 2 months

Bucharest, Romania

Senior ETL Developer

Raiffeisen Bank

Works closely with the business and IT application owners to understand, document and design ETL processes and needs.
Participates in the defining, development and implementation of data warehouse and data mart databases and their content.
Develops and maintains mapping logic to move data content from varied sources systems to the data warehouse / data marts.
ETL and data conversion design / implementation for other data integration scenarios.
Design, Develop, Test, Optimize and Deploy ODI packages and Oracle stored procedures / packages to perform all ETL related functions.
Plan and coordinate ETL and database roll-outs with project team members, development and database engineers.
Provide support, maintenance and issue investigation and resolution for ETL processes.
Design and implement BI technical and operational architecture / frameworks.
End-user report development, from requirement gathering to design, build, test, deploy.

Apr 2018 - Aug 2018

5 months

Vienna, Austria

Senior ETL Developer

Erste Bank

Contribute the design and development of an overall data exchange solution, including the review of existing processes to confirm technical feasibility of ODI integration.
Ensure standards and best practices for all current and new frameworks are followed.
Create technical documentation and build instructions to onsite and/or offsite global teams.
Assist with code reviews, deploying, and validating the technical solution when needed.
Develop and maintain SQL, PL/SQL code as needed for Oracle database, maintain, monitor, and support ETL/ELT integrations using ODI.
Working with Power Designer.
Creating Groovy Scripts.
Data Vault Methodology:
Hub
Links
Satelitte
Event
History (SCD, Snapshot, Bitemporal).

Nov 2016 - Apr 2018

1 year 6 months

Bucharest, Romania

Senior DWH/BI Developer

Unicredit Business Integrated Solutions

Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
Created BTEQ scripts to extract data from warehouse for downstream applications.
Develop ETL programs with an enterprise-grade tool (Datastage).
Contributes substantially to the DataWarehouse ETL development lifecycle, including developing and testing ETL programs.
Hands-on database development with SQL and stored procedures, such as Teradata procedures or similar ones.
Developing data transformations involving SQL, data-type conversions, joins, filters, translations, aggregation, de-/normalization and custom database stored procedures.
Working with Teradata Services, Teradata SQL Developer, Teradata Viewpoint.
Involvement in database optimization.
Implemented AGILE methodology for deliveries.
Generated Ad-Hoc reports for the users.

Aug 2015 - Nov 2016

1 year 4 months

PL / SQL Developer

Experience database programming and analysis, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Forms, Oracle Supplied Packages, Collections, Partitioned Tables, Objects, Records, Views, etc.
Experience in Complex SQL Queries, Dynamic SQL, Analytical function, various Oracle Objects.
Troubleshoot and provide both system and user support.
Analyze, design, code, test, and implement complex applications based on elicit specifications.
PL / SQL language specific exception handling.
SQL Optimization.

May 2013 - Aug 2015

2 years 4 months

Bucharest, Romania

Senior QA Warehouse/Reporting (Business Inteligence)

Romanian Commercial Bank (member of Erste Group) & Play Solutions

Preparation of Test Cases based on ETL Specification Document, Use Cases, Low Level Design document.
Extensively used SQL/PL SQL queries for data validation and backend testing.
Validating the data files from source to make sure correct data has been captured to be loaded to target tables.
Develop test plans and scripts, prepare test data, reconcile data sources and execute functional tests.
Supporting multiple code branches, building and delivering releases.
Acting as lead of testing activities.
Managing time and tasks to provide visibility.
Experience working with IBM Cognos (Reporting).
Experience working with ETL systems (Oracle Warehouse Builder, Oracle Workflow).
Experience working with Databases (Oracle Database).
Experience working with BugTracking systems (QualityCenter & Application Lifecycle Management).
Multiple tasks test database administration.
SQL tuning (working with hints).
RDBMS Concepts.
ETL Concepts.
Working with database objects: Packages, Functions, Procedures, Anonymous Blocks, etc.
Interviewing potential candidates in terms of technical database knowledge.
Making planning and estimating various projects.
Knowledge transfer to juniors.
Perform ETL and data manipulation techniques.
Able to properly document (functional & technical) source to target mappings, process flows, data flows, technical specification and unit test document.
Support provided in running processes on closing banking day on test environments.

Jul 2012 - May 2013

11 months

Bucharest, Romania

QA Warehouse/Reporting (Business Intelligence)

Vodafone Romania

Experience with ETL systems (Informatica PowerCenter).
Datawarehouse systems analysis experience.
Knowledge of performance measurement methodology.
Experience working with Business Objects (Reporting).
Strong knowledge / advanced SQL, PL / SQL and Unix (Experience with Oracle database).
Solid knowledge of Web Services (Simple Object Access Protocol using Eclipse tools).
Analyze impact between various patches / releases applied on the same test environments.
Knowledge with Billing systems.
Experience with Customer Relationship Management systems.
Working with BI technical team to support both the operational area and the development of BI (the entire development cycle from requirements definition, ETL and creating / delivering user reports).
Test ETL datawarehouse components (Evaluating and testing new or modified functionalities from multiple modules to verify that the application functions according to user requirements and conforms to established standards.).
Create, design and execute test plans.
Identify, troubleshoot and provide solutions for potential issues.
Approve requirements and design specifications.
Test flat file data transfers.

May 2010 - Jul 2012

2 years 3 months

Bucharest, Romania

Testing Programmer

Romanian Commercial Bank (member of Erste Group)

Develop, improve and extend automated test frameworks and test scripts (creation numerous tasks of scripting / programming (SQL / PL SQL) via QTP Automation).
Maintaining and managing testing environments.
Oracle Forms.
Tracking and managing database sessions.
Checks regarding the successful deployment of patches / releases.
Start / Stop the SQL environments engines.
Maintaining automatic jobs (dbms_jobs.submit).
Maintaining automatic execution processes (Operational Core Banking) on test environments.
Analysis on tables, schemas and indexessss.
Develop scripts for bringing data from production to test environment (database links).
Populating database with test data or real data after environment rewriting.

Oct 2009 - May 2010

8 months

Freelancer

5 – 10 Independent Projects

Design and / or develop custom web applications or websites.
MySql Databases.
Oracle Databases.
PHP (Framework - Symfony).
HTML, CSS, XML.
Visual Studio.
ASP.NET.
CSharp.
JavaScript.

May 2008 - Oct 2009

1 year 6 months

Bucharest, Romania

Accounting Developer

S.C. Pagini Aurii S.A. (Golden Pages)

Creating C# application to improve following requirements: Oracle Data Transfer - Wizcount.
Export revenues to Oracle and treat computing error.
Import customer contracts and related rates from Oracle into accounting and management program, error correction.
Transfer promissory notes and checks to Oracle application.
Analysis and correction of double payments, the penalties, increases or cancellations of invoiced contracts.
Support for applications based on bank cashing statements of Banc Post, RBS Bank, Credit Europe Bank, Transylvania.
Issuing reports (Report Viewer) such as:
Revenues in the period ' - '
Cashing for major clients in Oracle
Analysis and invoicing uncollected after the publication of books, issuing invoices discounts.
Contribution to the construction of the site redesign (CSS, XML, HTML).