ETL Developer Resume

SUMMARY:

More than 2 years of overall experience in Development and Enhancement of business applications
Strong technical skills in Unix Shell Scripting, Informatica PC, Greenplum Database and Oracle
Experience in workload automation tools like BMC Control - M 8.0 and Control-M enterprise Manager 6.4.01
Experience in handling team, taking up responsibilities, interacting with clients and higher management, mentoring new team members
Having ability to analyse and diagnose failure in jobs; to do impact analysis of a data issue and trace it back to source system and to resolve data quality issues
Having experience in 24x7 production supports and working on different tool like Remedy as ticketing tool

TECHNICAL SKILLS:

Hardware / Platforms: Windows XP, Windows 7, Windows 8, Windows 10, Ubuntu

Database: Oracle, Greenplum, MySQL

Programming Languages: SQL, PL/SQL, Postgresql, UNIX Shell scripting

ETL Tools: Informatica Power Center 9.1.0, 9.5.0 & 9.6.0

Other Tools: SQL Developer 3.2.4, PG Admin, Putty

Other Platforms: Citrix Receiver and Citrix XenApp

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Technology: UNIX, Informatica 9.1.0, 9.5.0, & 9.6.0 Greenplum DB, Oracle DB.

Responsibilities:

Created and enhanced the Informatica mappings, sessions and workflows according to the requirement.
Testing of the new and changed system with proper documentation.
Handled source files - XML files, flat files, csv
Preparing migration document for moving the application to different environments.
Written SQL overrides in Source Qualifier according to business requirements.
Created Sessions and Workflow for designed mappings.
Used Workflow Manager for Creating, Validating, Testing and running the Sessions and scheduling them.
Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
Responsible for providing 24/7 production support for daily job and ETL loads.
Created an automated ETL summary report which consists of the summary information for all the loading activities done each day
Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
Creating UNIX scripts for file transfer and for automated reports.

Confidential

Developer

Technology: Informatica 9.1, Oracle DB

Responsibilities:

Developed Informatica objects and Oracle tables
Involved in ETL designing process
Implemented ETL processes using Informatica to load data from Flat Files to target Oracle Data Warehouse database.
Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.