freiberufler Senior Oracle Database/Data Warehouse Developer auf freelance.de

Senior Oracle Database/Data Warehouse Developer

offline
  • auf Anfrage
  • 60329 Frankfurt am Main
  • Europa
  • en
  • 29.10.2018

Kurzvorstellung

 With more than 7 years of IT experience in various Software development applications like OLTP and OLAP by following the Development Life Cycle.
 Fully Gained Professional Knowledge on Oracle Database Architecture under versions 10g/11g/12c

Qualifikationen

  • Datenbankentwicklung
  • ETL
  • Informatica
  • Oracle Database
  • UNIX

Projekt‐ & Berufserfahrung

Senior Consultant (Festanstellung)
Capgemini, Bangalore
12/2013 – 12/2017 (4 Jahre, 1 Monat)
Dienstleistungsbranche
Tätigkeitszeitraum

12/2013 – 12/2017

Tätigkeitsbeschreibung

• Worked in various Domains like Telecom, Retail and Banking.
• Prepared detailed design document, Unit Test cases and Impact Analysis documents as well as doing Code and Peer review in various modules in a software development life cycle (SDLC).
• Experience Using Advance techniques like Ref cursor, Bulk collect, PL/SQL Collections, dynamic SQL, Packages, Procedures, Functions, Triggers, Views, Materialized Views, Inline View, Scalar/Co-related sub queries, Accessible by clause, Session/Global Sequence, Invisible Columns, Lateral Views, PL/SQL function in with clause, PRAGMA Antonymous/Exception/UDF, UTL_FILE, XML, DBMS Utility, Ref Cursor, Bulk collection/Binding.
• Experienced and knowledge in SQL loader by creating CTL file and executing the same from shell/perl/bash commands.
• Handled projects individually from front-end user interface design, to back-end relational database design and development involved various platforms running on AWS.
• Experience in SQL Query Tuning, and Performance tuning techniques (Explain Plan, Tkprof utility and running DBMS profiler, INMEMORY (12g)) with Partitions like Range/Hash/List/Interval/System/Reference.
• Worked as SCRUM master by scheduling SCRUM and Sprint Planning/Retrospective meetings with Product owners.
• Designing ETL process by using Informatica and PDI tools to model data structure in our Data Warehouse.
• Created Arithmetic/logical/Bitwise operators and Worked various data types like Immutable (Tuples) and Mutable (List/Dictionaries/Sets), Flow control statements and File handling methods under Python Programming.

Eingesetzte Qualifikationen

ETL

Ausbildung

Bachelors of Engineering
Ausbildung
2010
India

Über mich

• Worked in various Domains like Telecom, Retail and Banking.
• Prepared detailed design document, Unit Test cases and Impact Analysis documents as well as doing Code and Peer review in various modules in a software development life cycle (SDLC).
• Experience Using Advance techniques like Ref cursor, Bulk collect, PL/SQL Collections, dynamic SQL, Packages, Procedures, Functions, Triggers, Views, Materialized Views, Inline View, Scalar/Co-related sub queries, Accessible by clause, Session/Global Sequence, Invisible Columns, Lateral Views, PL/SQL function in with clause, PRAGMA Antonymous/Exception/UDF, UTL_FILE, XML, DBMS Utility, Ref Cursor, Bulk collection/Binding.
• Experienced and knowledge in SQL loader by creating CTL file and executing the same from shell/perl/bash commands.
• Handled projects individually from front-end user interface design, to back-end relational database design and development involved various platforms running on AWS.
• Experience in SQL Query Tuning, and Performance tuning techniques (Explain Plan, Tkprof utility and running DBMS profiler, INMEMORY (12g)) with Partitions like Range/Hash/List/Interval/System/Reference.
• Worked as SCRUM master by scheduling SCRUM and Sprint Planning/Retrospective meetings with Product owners.
• Designing ETL process by using Informatica and PDI tools to model data structure in our Data Warehouse.
• Created Arithmetic/logical/Bitwise operators and Worked various data types like Immutable (Tuples) and Mutable (List/Dictionaries/Sets), Flow control statements and File handling methods under Python Programming.

Weitere Kenntnisse

• Bachelors of Engineering from Anna University.
The above university is a prestigious university in India and is listed as H+, as on the Anabin.
 With more than 7 years of IT experience in various Software development applications like OLTP and OLAP by following the Development Life Cycle.
 Fully Gained Professional Knowledge on Oracle Database Architecture under versions 10g/11g/12c and worked with Scripting languages SQL, PL/SQL
 Worked under Unix/Linux Environment by creating Perl/Shell Scripting.
 Worked with Web-based application (HTML, JavaScript, CSS, .Net, Apex)
 Knowledge gained on Python Scripting by developed procedure-oriented programming as well as object-oriented programming.
 Developed ETL process by using Informatica and Pentaho Data Integration (PDI).
 Delivered all Project requirements within stipulated time by playing various roles like Change/Release Management lead and SCRUM Master by driving Agile Methodology.

Persönliche Daten

Sprache
  • Englisch (Muttersprache)
Reisebereitschaft
Europa
Profilaufrufe
952
Alter
37
Berufserfahrung
10 Jahre und 11 Monate (seit 04/2013)
Projektleitung
4 Jahre

Kontaktdaten

Nur registrierte PREMIUM-Mitglieder von freelance.de können Kontaktdaten einsehen.

Jetzt Mitglied werden