Recommended expert

Mihai (Daniel) Anghel

Senior ETL Developer | Team Lead

Mihai Anghel
Măgurele, Romania

Experience

Mar 2022 - Present
4 years
Vienna, Austria

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, analytical functions and recursive CTEs
  • Extensive knowledge with Teradata SQL Assistant and Teradata Viewpoint
  • Building recursive and iterative algorithms using Teradata stored procedures and Python
  • Unix for file handling on server side
  • Host On Demand for scheduling and running processes
  • Datastage used as wrapper for scripts triggering
  • ALM QC, SVN and GIT
  • Basic skills in cloud computing: ADF (Azure Data Factory), ADLS, Python, Databricks (SparkSQL and PySpark), Azure Synapse Analytics
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 various application data marts using Informatica PowerCenter and Oracle SQL & PL/SQL (packages and procedures)
  • Design and develop workflows, worklets, mappings, mapplets, sessions, tasks and transformations
  • Use Jira, SVN, ALM QC, GitHub and TeamCity/Jenkins
  • Unix and Unix Shell scripting
  • Perform and implement tuning processes
  • Use ControlM for simplifying application and data workflow orchestration on premises or as a service
  • Agile and Scrum methodology
  • Cognos for business reporting
  • Extract data from Oracle, DB2, CSV, flat files and JSON
  • TOAD and SQL Developer
  • Assisted in the design and development of SCD type 1 and type 2 mappings improving the efficiency of ETL jobs
Oct 2019 - Nov 2020
1 year 2 months
Bucharest, Romania

Senior ETL Developer

Raiffeisen Bank

  • Work closely with the business and IT application owners to understand, document and design ETL processes and needs
  • Participate in defining, developing and implementing data warehouse and data mart databases and their content
  • Develop and maintain mapping logic to move data content from varied source systems to the data warehouse and data marts
  • ETL and data conversion design and implementation for other data integration scenarios
  • Design, develop, test, optimize and deploy ODI packages and Oracle stored procedures 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 and frameworks
  • End-user report development, from requirement gathering to design, build, test and deploy
Apr 2018 - Aug 2018
5 months
Vienna, Austria

Senior ETL Developer

Erste Bank

  • Contribute to the design and development of an overall data exchange solution, including 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 for onsite and offsite global teams
  • Assist with code reviews, deployment and validation of the technical solution
  • Develop and maintain SQL and PL/SQL code as needed for Oracle database
  • Maintain, monitor and support ETL/ELT integrations using ODI
  • Work with PowerDesigner and create Groovy scripts
  • Data Vault methodology: Hub, Links, Satellite, 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)
  • Contribute 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
  • Develop data transformations involving SQL, data-type conversions, joins, filters, translations, aggregation, de-/normalization and custom database stored procedures
  • Work with Teradata Services, Teradata SQL Developer and Teradata Viewpoint
  • Involvement in database optimization
  • Implemented Agile methodology for deliveries
  • Generated ad-hoc reports for users
Aug 2015 - Nov 2016
1 year 4 months
Bucharest, Romania

PL/SQL Developer

Unicredit Business Integrated Solutions

  • Database programming and analysis, including cursors, ref-cursors, procedures, functions and packages, Oracle Forms, Oracle supplied packages, collections, partitioned tables, objects, records and views
  • Complex SQL queries, dynamic SQL, analytical functions and various Oracle objects
  • Troubleshoot and provide system and user support
  • Analyze, design, code, test and implement complex applications based on elicited specifications
  • PL/SQL language specific exception handling
  • SQL optimization
May 2013 - Aug 2015
2 years 4 months
Bucharest, Romania

Senior QA Warehouse/Reporting (Business Intelligence)

Romanian Commercial Bank; Play Solutions

  • Prepare test cases based on ETL specification document, use cases and low level design document
  • Extensively use SQL and PL/SQL queries for data validation and backend testing
  • Validate data files from source to ensure correct data capture to target tables
  • Develop test plans and scripts, prepare test data, reconcile data sources and execute functional tests
  • Support multiple code branches, build and deliver releases
  • Act as lead of testing activities and manage time and tasks to provide visibility
  • Experience working with IBM Cognos for reporting and ETL systems (Oracle Warehouse Builder, Oracle Workflow)
  • Work with Oracle database and bug-tracking systems (QualityCenter and ALM)
  • Perform multiple tasks in test database administration
  • SQL tuning using hints and RDBMS concepts
  • ETL concepts and working with database objects: packages, functions, procedures and anonymous blocks
  • Interview potential candidates on technical database knowledge
  • Plan and estimate various projects and transfer knowledge to juniors
  • Perform ETL and data manipulation techniques
  • Document source to target mappings, process flows, data flows, technical specifications and unit test documents
  • Support running processes on closing banking day in test environments
Jul 2012 - May 2013
11 months
Bucharest, Romania

QA Warehouse/Reporting (Business Intelligence)

Vodafone Romania

  • Work with ETL systems (Informatica PowerCenter) and perform data warehouse systems analysis
  • Knowledge of performance measurement methodology and experience with Business Objects reporting
  • Strong SQL, PL/SQL and Unix skills (Oracle database)
  • Solid knowledge of web services (SOAP using Eclipse tools)
  • Analyze impact of patches and releases applied on test environments
  • Experience with billing and customer relationship management systems
  • Support operational area and development of BI through entire development cycle from requirements definition, ETL and delivering user reports
  • Test ETL data warehouse components to verify functionality and standards conformance
  • Create, design and execute test plans
  • Identify, troubleshoot and resolve 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

  • Develop, improve and extend automated test frameworks and test scripts using QTP automation and SQL/PL SQL scripting
  • Maintain and manage testing environments and Oracle Forms
  • Track and manage database sessions and check deployment of patches and releases
  • Start and stop SQL environment engines
  • Maintain automatic jobs using DBMS_JOBS.SUBMIT and automatic execution processes for operational core banking on test environments
  • Analyze tables, schemas and indexes
  • Develop scripts to bring data from production to test environment via database links
  • Populate database with test or real data after environment rewriting
Oct 2009 - May 2010
8 months

Freelancer

Independent Projects

  • Design and develop custom web applications and websites
  • Work with MySQL and Oracle databases
  • PHP (Symfony framework), HTML, CSS and XML
  • Visual Studio, ASP.NET, C# and JavaScript
May 2008 - Oct 2009
1 year 6 months
Bucharest, Romania

Accounting Developer

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

  • Created C# application for Oracle data transfer (Wizcount)
  • Exported revenues to Oracle and handled computing errors
  • Imported customer contracts and related rates from Oracle into accounting and management program and corrected errors
  • Transferred promissory notes and checks to Oracle application
  • Analyzed and corrected double payments, penalties, increases or cancellations of invoiced contracts
  • Supported applications based on bank cashing statements from BancPost, RBS Bank, Credit Europe Bank and Transylvania
  • Issued reports (Report Viewer) such as revenues in the period, cashing for major clients in Oracle, uncollected invoicing after publication of books and issuing discount invoices
  • Contributed to site redesign (CSS, XML and HTML)

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Banking and Finance (14 years), Media and Entertainment (1.5 years), Telecommunication (1 year), and Information Technology (0.5 years).

Banking and Finance
Media and Entertainment
Telecommunication
Information Technology

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Information Technology (14.5 years), Business Intelligence (11 years), Quality Assurance (5.5 years), Project Management (2.5 years), and Accounting (1.5 years).

Information Technology
Business Intelligence
Quality Assurance
Project Management
Accounting

Skills

  • Team Spirit

  • Good Ability To Adapt To Multicultural Environments

  • Good Communication Skills

  • Trainer Skills

  • Adaptability And Flexibility

  • Attention To Details

  • Multi Tasking Skills

  • Communications Skills

  • Decision Making Skills

  • It

  • Banking

  • Telecommunications

  • E-commerce

  • Rdbms

  • Scripting

  • Oop

  • Query Language

  • Procedural Language

  • Driving Licence B

Languages

Romanian
Native
English
Advanced

Education

Sep 2005 - Jul 2008

Faculty of Cybernetics Statistics and Economic Informatics (Bucharest Academy of Economic Studies)

Graduate Degree · Economical Informatics · Bucharest, Romania

Profile

Created
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Mihai based?

Mihai is based in Măgurele, Romania and can operate in on-site, hybrid, and remote work models.

What languages does Mihai speak?

Mihai speaks the following languages: Romanian (Native), English (Advanced).

How many years of experience does Mihai have?

Mihai has at least 17 years of experience. During this time, Mihai has worked in at least 10 different roles and for 10 different companies. The average length of individual experience is 2 years and 6 months. Note that Mihai may not have shared all experience and actually has more experience.

What roles would Mihai be best suited for?

Based on recent experience, Mihai would be well-suited for roles such as: Senior ETL Developer | Team Lead, Data Warehouse Engineer, Senior ETL Developer.

What is Mihai's latest experience?

Mihai's most recent position is Senior ETL Developer | Team Lead at Unicredit Bank Austria.

What companies has Mihai worked for in recent years?

In recent years, Mihai has worked for Unicredit Bank Austria and Deutsche Bank.

Which industries is Mihai most experienced in?

Mihai is most experienced in industries like Banking and Finance, Media, Entertainment and Publishing, and Telecommunication. Mihai also has some experience in Information Technology (IT).

Which business areas is Mihai most experienced in?

Mihai is most experienced in business areas like Information Technology (IT), Business Intelligence, and Quality Assurance (QA). Mihai also has some experience in Project Management and Accounting.

Which industries has Mihai worked in recently?

Mihai has recently worked in industries like Banking and Finance.

Which business areas has Mihai worked in recently?

Mihai has recently worked in business areas like Business Intelligence and Information Technology (IT).

What is Mihai's education?

Mihai attended Faculty of Cybernetics Statistics and Economic Informatics (Bucharest Academy of Economic Studies) for Economical Informatics.

What is the availability of Mihai?

Mihai is immediately available full-time for suitable projects.

What is the rate of Mihai?

Mihai's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Mihai?

To hire Mihai, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

600
450
300
150
Market avg: 380-540 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.