freiberufler ETL Developer / Data WareHouse Developer / Informatica Developer / Business Intelligence Developer auf freelance.de

ETL Developer / Data WareHouse Developer / Informatica Developer / Business Intelligence Developer

offline
  • 60€/Stunde
  • 01187 Dresden
  • Nähe des Wohnortes
  • hi  |  en  |  de
  • 18.09.2018

Kurzvorstellung

5 years of Professional work experience in supporting the Business Intelligence (BI) systems,processes and also responsible for the analysis, design, development, modeling and implementation of data warehouse.

Qualifikationen

  • Datawarehouse / DWH
  • ETL

Projekt‐ & Berufserfahrung

ETL Developer
Big Heart Pet Brand, Bengaluru
4/2014 – 4/2015 (1 Jahr, 1 Monat)
Großhandel
Tätigkeitszeitraum

4/2014 – 4/2015

Tätigkeitsbeschreibung

Roles – ETL/Business Intelligence Developer

 Involved in most of the phases of the project like Business requirement, Analysis,

Design, Discussion, Development and Documentation.

 Involved in technical design sessions with business and technical staff to develop

requirements and ETL specification documents.

 Documented the Project Architecture under the guidance of Scrum Master.

 Guided the new team members with the access related issues and providing the

overview of the project.

 Involved in both Historical Load and Incremental loading.

 Performed administration tasks like creating folders, users, groups and granting them

permissions to different repositories (Dev) using the Repository manager.

 Developed Informatica mappings using various transformations in the Power center

designer following the Standard Rules.

 Designed and developed workflows using tasks in the workflow manager.

 Created reports using Query Studio and Report Studio of Cognos BI.

 Collaborated all the sessions from individual team member into a complete workflow.

 Unit test is performed on all the sessions/tasks created by the individual team

members.

 Validating individual team member’s mappings, sessions and test cases.

 Prepared Mapping Documents and Unit Test Cases for ETL Mappings/Workflows.

 Participated in the Scrum calls with the Scrum master ,off shore and onsite teams.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Business Intelligence (BI), Informatica, ETL

ETL Developer and L3 Support Engineer
Union Bank of Switzerland (UBS), Bengaluru
8/2012 – 8/2014 (2 Jahre, 1 Monat)
Banken
Tätigkeitszeitraum

8/2012 – 8/2014

Tätigkeitsbeschreibung

 Participated in the discussions with the client and the users to explain why the

enhancement or change is needed.

 Developed or enhanced the code as per the changes from the source files/data or

Change Request Ticket.

 Involved in bug fixing to resolve it based on the priority of the ticket.

 Created shell scripts and Autosys jobs to automate some of the tedious tasks in order

to reduce the manual effort and effective utilization of time.

 Used Autosys to schedule the various workflows according to different regions and

time zones.

 Existing application’s code analysis and documentation.

 Performed administration tasks like creating folders, users, groups and granting them

permissions to different repositories (Dev/Test/Prod) using the Repository manager.

 Enhanced the workflows using tasks in the workflow manager as per the Change

Request.

 Prepared Release documents to provide it to the production support team if any

changes or bug fixes needs to take place in production

 Prepared Unit Test Cases for ETL Mappings/Workflows.

 Involved in CAB calls where we need to explain why the release is needed in

production and explaining the release documents.

 Involved in status meetings with the clients.

 Acted as a coordinate member between offshore and onsite team.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Informatica, ETL

ETL Developer
Deutsche Bank AG, Frankfurt
7/2011 – 8/2012 (1 Jahr, 2 Monate)
Banken
Tätigkeitszeitraum

7/2011 – 8/2012

Tätigkeitsbeschreibung

 Involved in requirement analysis, application’s code analysis and debugging.

 Resolving the issues based on the priority of the ticket.

 Resolving the client related requests by communicating with them effectively and

resolving them in time.

 Participating in the releases and coordinating with the production support team during

the releases.

 Involved in debugging the complex code and documenting it.

 Analyzing the Unix shell scripts if any modification is needed.

 Performing the Unit testing for the changes or enhancements which are to be

implemented in Productions.

Eingesetzte Qualifikationen

Datawarehouse / DWH, Informatica, ETL

Zertifikate

Basics of Informatica
2011

Ausbildung

Computer Science
Bachelor of Technology in Computer Science
2010
Bengaluru

Über mich

My Work Experience includes:

 Extensive experience in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center

 Designed , developed and maintained Fusion application, DBFeeds application for UBS Bank and Deutsche Bank respectively.

 Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.

 Good knowledge on SQL and PL/SQL.

 Created reports using Query Studio and Report Studio of Cognos BI.

 Good Knowledge of solutions for data analysis, reporting, and concepts and techniques of business intelligence.

 Extensive experience in writing UNIX shell scripts and Autosys jobs to automate some of the tedious tasks in order to reduce the manual effort and effective utilization of time.

 Experience in Agile methodology project and also participated in the Scrum and CAB calls.
 Experience in dimensional modeling and Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center.

 Experience in resolving on-going maintenance issues and bug fixes.

 Knowledge on Web development(HTML & JavaScript) and have basic knowledge on structured programming languages.

 Excellent interpersonal and communication skills, and experienced in working with senior level managers, business people and developers across multiple disciplines.

Weitere Kenntnisse

With 5 years of Professional work experience in supporting the Business Intelligence (BI) systems, processes and also responsible for the analysis, design, development, modeling and implementation of data warehouse. Good knowledge on different relational database technologies and development tools.
Experience with SQL and programming languages PL/SQL and Java. Knowledge on Web development (HTML & JavaScript).

Persönliche Daten

Sprache
  • Englisch (Fließend)
  • Hindi (Muttersprache)
  • Deutsch (Grundkenntnisse)
Reisebereitschaft
Nähe des Wohnortes
Arbeitserlaubnis
  • Europäische Union
Home-Office
bevorzugt
Profilaufrufe
1373
Alter
35
Berufserfahrung
13 Jahre und 6 Monate (seit 09/2010)

Kontaktdaten

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

Jetzt Mitglied werden