We provide IT Staff Augmentation Services!

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

We'd love your feedback!