Informatica Developer Resume Sample

1. Business purpose: Creating analytical tables for data scientists over core data lake
Team: 9
Responsibilities: Building ETL scripts over core data lake to prepare data for data scientist’s analysis (analytical base table on sales data), validating extracts, spark optimization
Technologies: Spark (Azure Databricks), Python (spark data frames, little of pandas) – jupyter notebook & py modules , SQL, DBFS
2. Business purpose: ETL on media data
Team: 7
Responsibilities: Building ETL over media data to cover reporting needs
Technologies: Cloudera EDH on AWS, Hue (Hive/Impala), Python, SQL

Business purpose: Banking data warehouse development and maintenance
Team: 9 people
Responsibilities:
Building various layers of data warehouse – DSA – EDW (Data Vault) and data marts, unit testing, solving incidents, working according to agile (SAFe)
Technologies: Informatica Powercenter 9.5 & 10.2, Netezza, MSSQL, DB2, Tivoli Scheduler, Jenkins, Mercurial, SVN, Remedy, HP ALM, Informatica DVO

Business purpose: 1.Data virtualization 2. Building data staging area
Team: 12 people
Responsibilities:
Project 1: Data virtualization
Integrating data and building layers over huge amount of data from data warehouse among other sources for global FMCG client.
Technologies: Vertica, Cisco Integration Server – Studio, control-m, dBeaver, SQL, Unix
Project 2: Building corporate data warehouse
Analysis of source data, building of data staging area, unit testing, leading and educating technically team members, verifying supplier solutions, optimizing processes, Kimball methodology
Technologies: Oracle 12g, Informatica Powercenter 9.6, Unix, Custom scheduling tool, SQL, PL/SQL

Business purpose: Creating enterprise data warehouse platform
Team: 8 people
Responsibilities:
Designing and Creating ETL processes to move new data sources into ODS, OWB experts creating for various purposes including ETL and dimensional model (type1, type2 dimensions, fact – Kimball model), performing analysis of source data in order to create/clarify requirements and design flows and dma schemas, unit testing, assisting testing team in their tests, documentation creation, technical leading of younger team members in they every day work, 3rd level support, incidents solving, processes optimization
Technologies: Oracle 11g (SQL, PL/SQL), Oracle Warehouse Builder 11g, Erwin, Control-M, Business Objects

Several projects for global pharma corporation
Business purpose: Data migration and development of reporting database
Team: 11 people
Responsibilities:
Verifying of migration processes, development of new reporting and migration procedures, unit test conduction, technical documentation writing, tuning of PL/SQL database procedures, dividing and monitoring of tasks within system dedicated subteam, assisting team colleagues in the design, development and solving technical issues, designing and implementing various ETL processes (Informatica Powercenter 8.6)
Technologies: Oracle 9i, 10g, 11g (SQL, PL/SQL), TOAD, Informatica Powercenter 8.6,Unix , Test Director and Quality Center, Oracle Forms & Reports, SVN

Business purpose: Premium simulation analysis and staging data preparation
Team: 7-10 people
Responsibilities:
Analysis of financial premium simulation process, designing solutions of new staging modules and creating adequate procedures.
Technologies: Oracle 9i (SQL, PL/SQL), SQL Developer, Oracle Discoverer, Business Objects

Business purpose: Process reengineering
Team: 5 people
Responsibilities:
Analysis and verification of existing documentation, proposing new solution alternatives, creating System Delivery Specification including detailed process documentation including UML diagrams.
Technologies: System Architect (UML), Test Director

Business purpose: Enable Internet sales of the books – B2C and B2B e-Shop
Team: 3 people
Responsibilities: Implmenting B2C and B2B e-commerce solutions to enable Internet sales of books, utilizing Java/J2EE, JSP, WebSphere Commerce, and Oracle technologies to develop robust online shopping platforms.
Technologies: Java/J2EE JSP, WebSphere Commerce, Oracle

Business purpose: Backend and data model changes to ETL process
Team: 7-10 people
Responsibilities:
System maintenance & administration, new functions development, creation and rewriting of extraction triggers, SQL code optimization, defining various parts of ETL process according to company’s standards and methodologies (Kimbal’s approach to
Data warehouse), understanding and usage of basic terms used in telecommunications industry (GSM industry), analysis of aggregates and their optimization (and re-design), writing of migration scripts, knowledge handover and co-workers education.
Technologies: Oracle 9i (SQL and PL/SQL), 10g, SVN, Microstrategy

Business purpose: Development and maintenance of new modules in eBS
Team: 7 people
Responsibilities:
Creating various customizations to general ledger, payables and receivables modules including new reports, inspection of error sources upon user complaints.
Technologies: Oracle 9i, Oracle Forms & Reports 6i, PL/SQL, SQL, Oracle eBS

Business purpose: Development of new parts of agent’s information system with interfaces
Team: 7 people
Responsibilities:
Migration of data from one database system to another, re-writing of Access ’97 application (agents information system) in Oracle Forms 6i, database design for new application modules within the agents information system, reading of payment files into the Oracle Financials database, preparation of Oracle Forms 6i migration to Oracle Forms 10g and UNIX shell scripts for various functions.
Technologies: Oracle 8i, Oracle 9i, Oracle Forms & Reports 6i, PL/SQL, SQL, Access, VSS, JDeveloper, XSLT

Business purpose: Data warehouse implementation
Team: 1 person
Responsibilities:
Recognition of warehousing tools possibilities, data warehouse design and implementation and creation of reports using Alphablox (JSP).
Technologies: Data warehousing tools, DB2, JSP, Alphablox, Websphere, Linux Red-Hat (RHEL 4)

Business purpose: Deploying custom e-shop
Team: 4 people
Responsibilities:
Custom modifications of existing JSP pages and implementation of new views in e-shop.
Technologies: Oracle 10g, WebSphere Application Server v.6, IBM WebSphere Commerce, JSP

Business purpose: Jotter and Calendar Emulation
Responsibilities:
Design and implementation of EJB (Session and entity Beans) to cover the necessary functionality of meeting the appointment and reminder functions plus among others jotter browser and development of JSP’s and Servlet’s in order to create user interface
for the application.
Technologies: Cloudscape database, JSPs, Servlets, HTML, XSLT, EJB

Business purpose: Creation of CRM Application
Responsibilities:
Database design for CRM application, creation of web application with various user groups, admin functions to be later administered by an application admin.
Technologies: Postgres, PG PL/SQL, SQL, HTML, PHP, JavaScript, CSS

Business purpose: Oracle Applications implementation
Team: 15-25 people
Responsibilities:
Preparation of Oracle forms modules – embedded into the Oracle eBS structure for later migration upon the complete implementation of Oracle eBS, customizations of production and WMS forms in the core of the Oracle eBS and remodeling of business logic to satisfy the production and warehouse users – identification of API’s used, creation of additional
API’s.
Technologies: Oracle 9i, Oracle Forms & Reports 6i, PL/SQL, SQL, Oracle e-Business Suite Production & Warehouse Management (WMS) modules

Responsibilities:
Fully object-oriented programming of main portal modules and re-make of the presentation layer, custom creation of estate agents portals based on a template and Remake of various search engines.
Technologies: PHP, Javascript, MySQL, CVS, Linux

Business purpose: Development of Equipment life-cycle management application
Team: 7 people
Responsibilities:
The application managed full life-cycle of the equipment spread all over Poland. The major functional areas were: equipment description, amortization, accounting, invoicing and other customer-specific functions. The application was accessible both from the fatclient as well as through intranet. My personal responsibilities included: database structure design for specified modules
and reports using Oracle Designer, implementation of modules and reports using Oracle tools, web modules creation for the intranet portal of the Office of Technical Inspection and remote installation of Oracle modules and reports for the different offices in Poland.
Technologies: Oracle 8i, Oracle Forms & Reports 4.5 & 6i, PL/SQL,SQL, HTML, PHP, Javascript, Oracle Designer