ETL Consultant Resume

PROFESSIONAL SUMMARY:

Nearly 6 years of experience in IT with specialization in Data warehousing applications.
Rich experience in all stages of SDLC which includes requirements gathering, designing & documenting architecture, application development, testing, implementation and post - implementation support.
Expertise in IBM Info Sphere Datastage 11.3/8.5 and 7.x parallel and server editions for Extraction, Transformation and Loading (ETL) of data from various sources into Data Warehouse.
Expertise in performance trouble-shooting and enhancement for large volumes of data and strong analytic skills in debugging existing Datastage applications.
Rich experience in upgrade and conversion projects (application upgrade, tool upgrade, server to parallel conversion and Mainframe (Legacy systems) to ETL conversion).
Good Knowledge in Data warehouse concepts, SQL and UNIX.
Good Knowledge in Hadoop Technologies (HDFS, HIVE, PIG, SQOOP etc.)
Excellent team player with problem-solving and trouble-shooting capabilities.
Proven ability to quickly learn and apply new technologies and have creativity, innovation, and ability to work in a paced environment.
Work effectively with diverse groups of people both as a team member and alone.

TECHNICAL SKILLS:

ETL Tools: IBM Web Sphere Datastage 11.3/8.5 and 7.5 Parallel and server

Operating System: Linux, Sun Solaris.

Database: Oracle 12c, 11g, 10g and 9i.

Hadoop Technologies: Spark / Hdfs, Hive, Pig, Sqoop etc

Tools: / Software: Rapid Sql, Toad, Oracle Developer, Filezilla, Winscp, Eclipse etc.

Scheduling Tool: Control-M.

Versioning Tool: Pvcs, Mks and Domdoc.

Domain: Banking and Finance.

PROFESSIONAL EXPERIENCE:

ETL Consultant

Confidential

Responsibilities:

Worked as Senior ETL developer role in the project.
Responsible for business analysis and requirements gathering.
Parsed high level design document to ETL Mapping standards and outlined dataflow from source to targets.
Created ETL’s using Datastage in order to extract data from varied sources.
Extensively used stages like Oracle Connector, Sequential File, Complex Flat File,
Transformer, Lookup, Join, Sort, Aggregator, Funnel, Pivot, Change capture etc.
Converted the existing slow performance server jobs to parallel jobs.
Converted existing legacy (Mainframe process) to ETL process using Datastage.
Prepared unit test cases, System test cases and Prepared unit test exit report and system Test exit report.
Monitoring and supporting the ETL FGL application and fixing the issues.
Code Enhancement and Maintenance by SharePoint Tasks.