Freelancer-Profil von Juraj Ivanega aus Dortmund, Database architecture/design and development (Oracle), ETL (Informatica PowerCenter) (Deutschland)

Freelancer-Profil von Juraj Ivanega aus Dortmund, Database architecture/design and development (Oracle), ETL (Informatica PowerCenter) (Deutschland)

• 17+ years’ experience in Oracle (SQL, PL/SQL); working with large database (23TB)

• 12+ years’ experience in Informatica (Designer, Workflow Manager, Workflow Monitor) – development (mappings, worklets, workflows) and monitoring

• 5+ years’ experience in data and database architecture and design

• business requirements analysis, impact analysis, solution feasibility and solution design within an IT system

• understanding of corporate business goals and objectives (enterprise architecture)

• effective and clear communication with all target audiences (business, developers, support)

• 17+ years’ experience in database software development, testing and deployment (full understanding of systems development life-cycle)

• Agile development and thinking

• intercultural competence and leadership – 5+ years’ experience working as a lead developer coordinating work of offshore IT Support team (located in India and partly in Finland), virtual team of (Oracle) developers located in Germany (Dusseldorf), Finland (Espoo and Salo) and U.S.A (Dallas)

Industry experience: Telecommunication

IT area supporting after-sales services (customer care) in global consumer electronics industry /warranty and asset management, device register, repair network/

Expertise

• good understanding and interpretation of business needs

• database logical and physical design

• data architecture and modeling

• ETL (using Informatica PowerCenter)

• data quality analysis

• query performance tuning

• application performance tuning

• system documentation

• delivery and operations management

• end-to-end system integration

Skills, techniques + methods

• Oracle database ver. 8i - 11g

• Informatica PowerCenter ver. 5.0 – 9.1

• Oracle SQL

• Oracle PL/SQL (SQL Navigator, TOAD, SQL Developer)

• Oracle Designer

• Oracle Forms, Oracle Reports

• SQL Developer Data Modeler

• Magic Draw

• Accept 360