Datastage Data Warehouse Etl Developer Resume
3.00/5 (Submit Your Rating)
South Plainfield, NJ
SUMMARY:
- A challenging data warehouse position utilizing various ETL tools with the possibility of career advancement.
- Exceptional experience and background in data warehouse methodology, star schema, snow flake schema, design, development, customization, and implementation and testing of software applications and products.
- Worked on insurance data and retail data
- Strong expertise in RDBMW, SQL scripting and utilized SQL Server Management Studio, SQL Navigator, SQL Developer, Toad.
- Worked on a retail database and performed change data capture in server Datastage 7.5 edition
- Used the join stage to perform joins between tables and utilized the transformer stage to do various data manipulations by using functions such as trim, right and left.
- In parallel extender 8.1 platform, me Extracted data from flat file (NVarchar), made some transformations in shared container, and inserted the data in the target database.
- Used the lookup stage in parallel 8.1 edition to lookup calendar fiscal year
- Learned how to do data validation by using the len and other various functions in transformer
- Replaced ODBC stage jobs with merge stages to enhance the performance and reduce processing time
- Learned source - to-target mapping to determine transformation logic prior to the ETL design flow
- Learned about job parameters and why parameter sets are used
- Demonstrated expertise utilizing Datastage ETL tool, Oracle, SQL Server and Unix.
- me have light experience of scripting/coding server routines
- Used various partitioning techniques me.e. hash, same, auto, round-robin
- Learned dat the best partition method is hash because it ensures dat all the duplicates are in the same partition and can be cleansed using the remove duplicates stage
- Team player with excellent communication and problem solving skills.
- Demonstrated noledge of Triggers, Stored Procedures, and Functions in Oracle
- Wrote Unix Scripts to run Datastage jobs, Used Unix sort commands to sort data as a performance tuning technique
TECHNICAL SKILLS:
- Core Java, Javascript
- SQL, HTML, CSS, MS Office 2007
- Adobe Photoshop, Dreamweaver MX
- Lotus Notes, MS Access, Oracle 10g, Unix, Datastage (7.5/8.1)
PROFESSIONAL EXPERIENCE:
Confidential, South Plainfield, NJ
Datastage Data Warehouse ETL Developer
Responsibilities:
- Extracted data from Oracle database and developed Datastage Parallel Jobs
- Developed SQL queries using Toad platform
- Wrote UNIX scripts to run Datastage jobs
- Used various partitioning methods and employed various performance tuning techniques
- Refer to summary above for an elaborate description of my skillset regarding Datastage
Confidential, Woodbridge, NJ
Field Services Assistant
Responsibilities:
- Assisted with configuring hardware equipment used in stores
- Analyzed entity relational diagrams and identified referential integrity between relations
- Updated systems with new programs and necessary applications
- Assisted and managed Java based software programs
- Developed SQL queries and used group by and having clauses
Confidential
Research Assistant
Responsibilities:
- Conducted research on the human computer interaction and attended Aresty meetings
- Managed experiment sessions for subjects to use the special computer interface
Confidential
Financial Services Representative
Responsibilities:
- Assisted corporate executives with obtaining new clients
- Performed profit and loss management and maintained commission charts
- Used pivot tables and performed V - lookups on MS Excel spreadsheets
Confidential, Trenton, NJ
IT Business Analyst Assistant
Responsibilities:
- Designed a matrix showing all budget categories listed by programs
- Used Java based software programs and conducted several configurations
- Assisted with the development of System of Administrative Grants Electronically
- Planned and designed customized application forms for various programs
- Helped with administrative tasks: grant writing, budget review and clinic chart audits
- Attended administrative meetings to discuss contracting and fiscal reports