Etl Developer Resume
5.00/5 (Submit Your Rating)
NewjerseY
PROFESSIONAL SUMMARY
- Over 4 years of Technical experience in IT Industry, involving in teh implementation of Data Warehousing and Business Intelligence environment using industry accepted methodologies.
- Good Experience in ETL Technologies like Datastages 7.5, Ab Initio (GDE 1.15, Co>operating System 2.15).
- Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Procedures for Data warehouses.
- Extensive experience ETL Mapping, Coding DS job Routines using Unix Shell programming.
- Experience in using various Stages in Data Stage (PX) like Lookup, Joiner, Transformer and Merge...
- Performed Debugging and Performance Tuning for Various Data Stage Jobs.
- Experience in troubleshooting of Data Stage jobs and addressing production issues like performance tuning and enhancement.
- Good noledge in Software Development Lifecycle (SDLC).
- Good understanding of Ascential DataStage Architecture.
- Good noledge in Data Warehouse Architecture and Data Warehouse concepts.
- Good team player with excellent communication and interpersonal skills.
TECHNICAL SKILLS
ETL Tools: DataStage7.5,8.1, Ab - initio.
Reporting tools: Cognos, Business Objects.
Programming Languages: C, SQL,UNIX.
Databases: Oracle 9i,SQL server.
Operating Systems: Windows Server 2003, NT, XP.
PROFESSIONAL EXPERIENCE
Confidential, Newjersey
ETL Developer
Environment: Datastage 7.5, 8.1.
Responsibilities:
- Monitored Datastage jobs to extract transform and load teh data from source to target.
- Developed Datastage jobs for adding new functionalities.
- Production support of Datastage data warehousing jobs on UNIX platform.
- Managing Metadata from from DS Manager.
- Developed Jobs, Job Sequences.
- Tuned Datastage jobs for better performance.
Confidential, Durban, SA.
ETL Developer
Environment: Ascential Data Stage 7.5., Windows Server 2003, Oracle 9i.
Responsibilities:
- Developed Data stage jobs to extract, transform and load teh data from source to target.
- Worked extensively on different types of stages like Dataset, Lookup, Join, Merge, Funnel,and Copy.
- Studied about teh current system and Data Warehouse present.
- Created teh detailed design and Standard’s Document’s.
- Used Data Stage Manager for exporting and importing teh jobs.
- Developed Jobs, Job Sequences.
Confidential
ETL Developer
Environment: Oracle 9i, Ascential DataStage 7.5, Windows server 2003.
Responsibilities:
- Developed Data stage jobs, Data stage job routines to extract, transform and load teh data from source to target.
- Involved in Requirement gathering and preparation of Design Document
- Studied about teh current system and Data Warehouse present.
- Created teh detailed design and Standard Documents.
- Managing Repository Metadata from Data Stage Manager.
- Developed Jobs, Job Sequences.
- Unit Testing and System testing.
- Tuned Data Stage jobs for better performance.