We provide IT Staff Augmentation Services!

Data Stage Developer Resume

3.00/5 (Submit Your Rating)

Middletown, NJ

Hire Now

SUMMARY:

To obtain an ETL developer Position.

TECHNICAL SKILLS:

Ascential Data Stage 7.1x/6.x using Component like Data Stage Designer, Data Stage Manager, Data Stage Director, Data Stage Administrator, Parallel Extender, Sybase, SQL, MS SQL Server, Oracle 9i, DB2, Erwin 4.x, UNIX, MS Access, Networking, Telecommunication, Business Analysis and Design, Visual Basic programming, C, HTML, XML Files Front Page, SAP, Microsoft Excel, Power Point, Punjabi and Hindi fluency (Strength in translation and writing)

PROFESSIONAL EXPERIENCE:

Confidential, Middletown, NJ

Data Stage Developer

Responsibilities:

  • In Ascential DataStage 7.x/6.x/5.x using Components. Such as DataStage Designer, DataStage Manager, DataStage Director, DataStage Administrator, Parallel Extender, using Oracle.
  • Analyzed and designed the ETL processes.
  • Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
  • Created DataStage Server jobs to load data from Sequential files, Flat Files.
  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Used Data stage Manager for importing metadata from repository, new job categories and creating new data elements.
  • Used the DataStage Designer to design and develop jobs for extracting, cleansing, transforming, integrating, and loading data into different Data Marts.
  • Defined the data definitions, and created the target tables in the database.
  • Mapped the source and target databases by studying the specifications and analyzing the required transforms.
  • Troubleshooting jobs using the debugging tool.
  • Analyzed the performance of the jobs and project and enhance the performance using the standard techniques.
  • Created job sequences and schedules for automation.
  • Used the DataStage Director and its run - time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an ad hoc or scheduled basis).
  • Used DataStage to transform the data to multiple stages, and prepared documentation.
  • Prepared deployment document, Test plans, Test cases and worked on Test strategy.
  • Used Data Marts for aggregating customer information. ETL activities supported analysis of Data Marts using OLAP business intelligence tools by Business Objects.

Environment: Ascential Data Stage 7.1 (Designer, Director, Administrator, Manager, Parallel Extender), Windows UNIX, Oracle 9i, MS SQL Server, DB2, Sybase, UNIX Sequential Files, MS Access, XML files, Erwin 4.0, Toad, DB Visualizer (Testing).

Confidential, Iselin, NJ

Data Stage Developer

Responsibilities:

  • Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Identified source systems, their connectivity, related tables and fields and ensure data suitably for mapping.
  • Created source table definitions in the Data Stage Repository by studying the data sources.
  • Generated Surrogate ID’s for the dimensions in the fact table for indexed and faster access of data.
  • Created surrogate key tables to map the required dimensions.
  • Created hash tables used for referential integrity and/or otherwise while transforming the data representing valid information.
  • Enabled Proper selection of the hash table design parameters for faster table look-up.
  • Created re-usable components using shared containers for local use or shared use.
  • Imported and exported repositories across projects.
  • Created Error Files and Log Tables containing data with discrepancies to analyze and re-process the data.
  • Used Aggregator stages to sum the key performance indicators used in decision support systems.
  • Tuned DataStage transformations and jobs to enhance their performance.
  • Created jobs sequences.
  • Created job schedules to automate the ETL process.
  • Enhanced the job properties for performance tuning.

Environment: Ascential Data Stage 7.1 (Designer, Director, Administrator, Manager, Parallel Extender), Windows UNIX, Oracle 9i, MS SQL Server, DB2, Sybase, PLSQL, UNIX Sequential Files, MS Access, XML files, Erwin 4.0, Toad, DB visualizer.

Confidential, Trenton, NJ

Manager

Responsibilities:

  • Handled bank transactions and bookkeeping.
  • Maintained daily reports by tracking sales and volume of gasoline.
  • Responsible for determining payments that are made to vendor and suppliers.
  • Sustained ongoing operational activities.

Confidential, Burlington, NJ

Electronic Salesperson

Responsibilities:

  • Responsible for all cash and credit card sales during shift.
  • Informed customers about new features of individual products.
  • Contacted other stores for the purpose of locating products for customers

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship