We provide IT Staff Augmentation Services!

Etl Developer Resume

2.00/5 (Submit Your Rating)

TECHNICAL SKILLS

  • RS/6000 SP2
  • SUN/OS
  • HP9000
  • DEC ALPHA
  • IBM RS/6000
  • NCR
  • Unisys 2200
  • IBM PC/AT and compatibles UNIX (AIX
  • HPUX
  • SCO
  • SOLARIS)
  • DB2
  • ORACLE V.9.2.1
  • SQL
  • PL - SQL
  • ORACLE SQL-FORMS
  • REPORTWRITER
  • SQL-PLUS
  • Toad
  • Informatica
  • MS Visio
  • Autosys
  • Syswatch
  • Dazel

PROFESSIONAL EXPERIENCE

ETL Developer

Confidential

Responsibilities:

  • Designed and implement ETL process flows
  • Ensure ETL team adhered to the NJM ETL standards
  • Unit testing
  • Developed complex ETL processes that would be executed by bat scripts
  • Provide after hours production support

SUPERVISOR

Confidential

Responsibilities:

  • Mentoring employees
  • Annual Reviews
  • Ensure the stability of day to day operations
  • Ensure system environment has most recent version of Informatica tools
  • Report project statistics to Department Manager
  • Organize and attend project meetings
  • Oversee group activities and projects

ETL DEVELOPER

Confidential

Responsibilities:

  • Integrated PL/SQL with UNIX scripts
  • Combined several PL/SQL procedures into a single Unix script batch flow
  • Work with PERL scripts

INFORMATICA DEVELOPER

Confidential

Responsibilities:

  • Lead developer while working on the Long Term Care
  • Data Mart project Worked extensively on developing Informatica mappings and workflows (sessions)
  • Developed complex ETL processes with Informatica integrated with shell scripting
  • Worked extensively with Mapplets, Update Strategy, Routers, Joiners and Memory cache
  • Developed UNIX scripts to execute Informatica workflows
  • Monitor and maintain production UNIX scripts for loading data into data warehouse/mart
  • Code inspections with Analyst to ensure code met business and system requirements
  • Created technical data flows using Microsoft Visio for various ETL routines
  • Create and maintain technical documentation
  • Provided full production of all projects promoted to the production system
  • Responsible for developing and loading Disability and Long Term Care data marts
  • Extensive testing when migrating from Informatica 4.7 to 5.0 and to 6.2
  • Perform unit testing of code to ensure error and exception processing issues are implemented

UNIX SYSTEMS ADMINISTRATOR

Confidential

Responsibilities:

  • RS/6000 SP2 UNIX systems administration Install/Upgrade AIX OS
  • Monitor and maintain UNIX system backup using UNIX scripts and Autosys
  • Perform disaster/recovery procedures on the New York UNIX system
  • Setup Autosys and Syswatch rules to monitor jobs and processes

We'd love your feedback!