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