We provide IT Staff Augmentation Services!

Datastage Etl Developer Resume

5.00/5 (Submit Your Rating)

Plainsboro, NJ

SUMMARY

  • Presently looking for a DataStage Developer opportunity - Data Warehouse with Oracle, PL/SQL, DB2/UDB. PERM (preferred) or CTH or Long term Contract.
  • Experience with Data Warehouse and Data Mart environments.
  • Experience with healthcare data reporting/analysis experience.
  • Healthcare experience in an IT role.
  • 8 years of hands-on Data Warehouse experience doing Analysis, Development, Testing, Deployment, and Post-Production Support of Applications Programs in various Oracle, DB2/UDB, Enterprise Data Warehouse, and DataMart environments.
  • 8 years of hands-on experience using DataStage (DataStage versions 8.7, 8.5, 7.5, 7.1 - both Server and Parallel), writing Queries in Structured Query Language (PL/SQL; SQL), utilizing TOAD, Sql Plus, Sql Developer, WinSCP, Putty, SFTP, Accessing data from, and Loading data to ORACLE, and DB2 UDB databases, working in both UNIX and LINUX environments.
  • Served as a Lead DataStage Developer and Subject Matter Expert on a # of different Enterprise Data Warehouse Projects.
  • Responsible for all aspects of development and maintenance of ETL jobs using the DataStage tool, including ETL implementation and enhancements, testing and quality assurance, troubleshooting issues, performance tuning of ETL jobs, technical documentation writing, and routine production ETL process support.
  • Test planning and execution. Hands-on experience Coordinating, & Running UNIT testing, Systems Testing, Regression Testing, and UAT - for various IT Software Applications.
  • Understanding of normalized and de-normalized data repositories.
  • Provided root cause analyses of production problems.
  • Ability to effectively communicate findings, recommendations, and conclusions.
  • Data and transformation mapping.
  • Actively participated in High Level Design reviews, & Strategy/Planning sessions.
  • Excellent problem solving and organizational skills.
  • Experienced with the onshore/offshore model - with respect to communications and coordination.
  • Wrote ETL specs for junior developers in India based on the business rules, and then monitored their development, testing, and deployment processes.
  • Acted as a resource for others with less experience.
  • Responsible for working on multiple projects simultaneously, multi-tasking and balancing work based on priority.
  • Strong communication and collaboration skills.
  • Strong analytical and conceptual skills.
  • Strong Documentation skills.
  • Ensured timely delivery of required ETL tasks. A consistent track record of ‘on-time’ applications software delivery and execution.
  • Effectively operated within a team of technical and business professionals. Extensive experience working with Vendors, Off-shore consultants, Business Management, End users, IT Management, and Technical staff.
  • Experience with MS-Office: Word, Excel, and Visio.
  • Supported the training of associates by sharing product knowledge and IT knowledge as needed. Assisted other IT staff with implementation and support issues.
  • Technical skills also include 20+ years of hands-on Analysis, Development, Testing, and Deployment experience in an IBM Mainframe Legacy environment: COBOL / COBOLII, MVS JCL, FTP, VSAM, IDCAMS, IDMS; FILEAID, TSO ISPF, PROCS, IBM Utilities, SQL, CA7, SDSF, CONTROL-D, CONTROL-M, NYLLMS, ENDEVOR, REMEDY, CHANGE MAN, Panvalet.

TECHNICAL SKILLS

Hardware: LINUX; UNIX/SUN SOLARIS; CITRIX; IBM Mainframes.

Databases: ORACLE, DB2/UDB, SYBASE, IDMS.

Database Query Tools: PL/SQL, SQL, TOAD, Oracle SQL Plus, Oracle Sql Developer, Query Analyzer, Terradata SQL Assistant; QMF, OLQ (Mainframe).

ETL Software: DATASTAGE EE V 7.5/8.1/8.5/8.7 - Server and Parallel Editions;

VI; EDI; WINSCP; SFTP; FTP.:

ETL Concepts: DATA WAREHOUSE; DATA MARTS; NORMALIZATION/DE-NORMALIZATION; FACT and DIMENSION tables; STAR SCHEMA.

IBM Software: IBM Mainframe COBOL / COBOLII, MVS JCL, VSAM, IDCAMS, IDMS; FILEAID, CA7, SDSF; TSO/ISPF, SYNCSORT, CONTROL-D, CONTROL-M, IBM Utilities, FTP, SFTP, SQL, ENDEVOR, NYLLMS, CHANGE MAN; REMEDY and AOTS. Lotus Notes;

Other: MS-OFFICE (Excel, Word, Visio, Outlook).

PROFESSIONAL EXPERIENCE

Confidential, Plainsboro NJ

DataStage ETL Developer

Responsibilities:

  • Worked on the Sunshine Project - an initiative designed to meet new Federal Reporting Requirements for Health Care Professionals (HCPs).
  • Writing of SQL Queries and PL/SQL scripts to pull the required data, as well as the Development, Coding, and Testing of DataStage 8.7 jobs in a DataStage, LINUX, SQL, Oracle Data Warehousing environment. Source data was housed in Sequential files as well as in an Oracle database, & the Targets were an Oracle EDW, Data Marts, and Sequential files that would be SFTP’d out to the Vendor.
  • Test planning and execution - Handled Unit Testing, Systems Integration Testing, and QA/UAT Testing of DataStage 8.7 Parallel jobs.
  • Handled in-depth analyses of DataStage job logs in Director and on UNIX, and verified the accuracy of data housed in target files as well as in Oracle tables - for quality assurance purposes.
  • Analyzed and coded fixes as required.
  • Provided explanations and information to others on difficult issues.
  • Updated Technical Documentation, specifically the Technical Design Spec, to include the requirements and changes for the latest releases.
  • Provided technical support for existing Data Warehouse ETL processes.
  • Modified LINUX scripts to include/allow the processing of new data sources, & tested the DataStage Sequencer jobs utilizing these new versions of the scripts. Testing Results were successful.
  • Participated in on-call production problem resolution activities as required.
  • Monitored current DW applications and developed procedures to improve the DW environment.
  • Identified and supported quality improvement initiatives.
  • Solved moderately complex problems and/or conducted moderately complex analyses.
  • Worked with minimal guidance; sought guidance on only the most complex tasks.
  • Translated concepts into practice.
  • Reported directly to Team Lead. Managed individual work assignments, tracked and resolved issues, and reported status to manager and project team.

Confidential - Trenton, NJ

DataStage ETL Developer

Responsibilities:

  • Worked on the Recidivism Project for the Confidential OIT, a very high profile project. Specifically, worked on Master Offender, Offender Event Detail Daily, Released Offender Dimension, and FACT Monthly Processing.
  • Responsible for new development - As the primary ETL Consultant, I played a key role in the Writing of SQL Queries and PL/SQL scripts to pull the required data, as well as the Development, Coding, and Testing of DataStage 8.5 jobs in a DataStage, UNIX, SQL, Oracle Data Warehousing environment. These jobs pulled Source data from such systems as the NJ State Police, Dept of Corrections, State Parole Board, and Juvenile Justice. Source data was housed in MS SQL Server and Oracle databases, & the Targets were an Oracle EDW as well as various Data Marts.
  • Excellent problem solving and organizational skills.
  • Strong analytical and conceptual skills.
  • ETL Development, monitoring, reporting and metrics.
  • Performance tuning of ETL jobs - Optimized long-running DataStage jobs, & drastically reduced Actual Cycle Run Times.
  • Effectively operated within a team of technical and business professionals. Interfaced directly with architects, DBAs, other technical staff, & IT Management on a regular basis in order to keep up-to-date on new requirements, & to address any issues that arose.
  • Reported directly to Sr IT Management. Managed individual work assignments, tracked and resolved issues, and reported status to manager and project team.
  • Ensured timely delivery of required ETL tasks. Kept project and development work moving forward without delay. Successfully met deadlines. Viewed in a positive light by Management.
  • Actively participated in High Level Design reviews, & Strategy/Planning sessions.
  • Always willing to learn something new, & pitch in with work efforts.

Confidential, Bloomfield, CT

DataStage ETL Developer

Responsibilities:

  • Worked on the Minimum Loss Ratio (MLR) Reporting System Project.
  • Responsible for the Enhancement & Testing of all MLR SQL Queries and DataStage 8.1 Parallel jobs in a DataStage, Linux, SQL, DB2 UDB environment - due to new as well as changing business requirements.
  • Analyzed business requirements and translated into ETL data rules. Analyzed existing MLR DataStage jobs, determined what specific DataStage jobs needed to be updated in order to address particular business needs, and configured the updates to the existing software.
  • Experience in the development of data extraction and load processes in a parallel framework. Responsible for making all the necessary changes to the DataStage Code as well as documenting these changes in detail.
  • Test planning and execution - documented what needed to be Tested. Documentation was housed on a dedicated Sharepoint site.
  • Effectively operated within a team of technical and business professionals.
  • I resigned from this commuter role due to family health issues occurring Confidential home in another state.

Confidential, Pennington, NJ

Sr ETL Developer (Level IV) - DataStage

Responsibilities:

  • Responsible for new development - As a Sr DataStage Developer for the Global Wealth Investment Management Group, was actively involved in Custom Design, and Coding of new SQL Queries and DataStage 8.1 jobs for a number of high priority projects related to Fraud detection.
  • Test planning and execution - Handled Unit Testing, Systems Integration Testing, and QA/UAT Testing of DataStage 8.1 Server & Parallel jobs in a DataStage, Linux, SQL, DB2 UDB environment.
  • Handled in-depth analyses of DataStage job logs in Director and on Linux, and verified the accuracy of data housed in target files as well as in DB2 tables.
  • Documentation was housed on a dedicated Sharepoint site.
  • Documented the Actual Results of the test runs vs. the Expected Results, & communicated those Results to the parties involved, & then conducted any necessary follow-up.
  • Responsible for Deployment, and Production Support.
  • Provided root cause analyses of production problems.
  • Interfaced with Offshore Team to coordinate Testing Schedules.
  • Led DataStage technical code reviews.
  • Effectively operated within a team of technical and business professionals.
  • Worked on multiple projects simultaneously, multi-tasked and balanced work based on priority.
  • Responsible for reporting Status to IT management.

Confidential, Princeton, NJ

Lead ETL Developer - DataStage

Responsibilities:

  • Actively involved in Writing SQL Queries, and thoroughly Testing New ETL DataStage 8.1 jobs in a DataStage, UNIX, PL/SQL, Oracle environment for a high priority and critical Informatica-to-DataStage conversion project.
  • Worked on multiple projects simultaneously, multi-tasked and balanced work based on priority.
  • Strong analytical, conceptual, and problem-solving skills.
  • Executed and documented Technical Testing of data conversion programs.
  • Test planning and execution - Responsible for running the Test cycles, in-depth reviewing of DataStage job logs, and verifying the accuracy of data housed in target UNIX files as well as in Oracle tables.
  • Provided root cause analyses of production problems.
  • Worked with offsite Vendor Technical Support for problem resolution.
  • Ability to effectively communicate findings, recommendations, and conclusions. Responsible for identifying and documenting Errors, investigating the cause of the errors, identifying the “fix”, & recommending solution/s to off-shore developers on how to implement the fix.
  • Defined and documented Data Migration framework jobs and provided knowledge transfer to other technical team members.
  • Coordinated and provided specifications to remote ETL and DW Developers.
  • Documented Technical System Design Specifications related to ETL data conversion programs.
  • Provided advice and assistance on the technical application and environment.
  • Supported data conversion and reconciliation efforts relating to I4 related data.
  • Responsible for mentoring new team members in the technical aspects of how the Testing is done, what Documentation should be produced, how to log discrepancies found in testing that require follow-up, where the UNIX directories are, etc.
  • Effectively operated within a team of technical and business professionals.

Confidential, Princeton, NJ

Senior Applications Systems Analyst/Programmer

Responsibilities:

  • Worked with internal and external business partners to identify, analyze and document requirements for the creation of a new ETL application.
  • Created system documentation which included existing legacy application processes and business rules as well as the corresponding job flows. Documentation was housed on a dedicated Sharepoint site.
  • Worked with offsite Vendor Technical Support for problem resolution.
  • Performed source to target data mapping.
  • Worked on multiple projects simultaneously, multi-tasked and balanced work based on priority.
  • Analyzed specifications for completeness and accuracy.
  • Provided Development support for existing systems.
  • Responsible for new development - Designed, Coded & Tested new programs that produced the data required to meet these new requirements.

Confidential, Philadelphia, PA

Consultant - DataStage Developer/ Informatics Div.

Responsibilities:

  • Hands-on experience with Writing SQL Queries, DataStage, UNIX, Oracle, FTP as well as IBM Mainframe, MVS JCL, FTP, and COBOL. Limited experience with Query Analyzer and Teradata SQL Assistant.
  • Daily/Monthly support and validation of DataStage ETL loads.
  • Enhanced DataStage jobs in order to meet changing business requirements.
  • Responsible for troubleshooting, and analyzing data to ensure that delivered data and reports were accurate.
  • Handled Production Support - Provided root cause analyses of production problems.
  • Used SQL Server - Query Analyzer tool to write queries and perform data analysis on data contained in the Data Warehouse environment.
  • Used Teradata SQL Assistant tool to write queries and perform data analysis on data contained in the Data Warehouse Teradata environment.
  • Maintained standards for ETL operations including the scheduling, running, monitoring, and logging of Production jobs, management of errors, recovery from failures, and validation of outputs to target systems - for DataStage jobs.
  • Experience with Job Sequencers to Control the Execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Email Notification, Sequencer, Routine activity and Execute Command.
  • Worked both independently and as part of a Team - depending on the requirements of the assignment Confidential hand.
  • Assisted other IT staff with implementation and support issues.
  • Documented Job flows as well as Maintenance processes for easy reference.

Confidential - Middletown, NJ.

DataStage Developer

Responsibilities:

  • Hands-on experience in the Confidential & Confidential GCP (DBOR) Oracle, UNIX, DataStage, PL/SQL, Data Warehouse environment. Worked in both the Tier4/Development group handling Service Delivery and Service Assurance ETL assignments, and the Tier3/Prod Support group.
  • Hands on experience with data integration and ETL activities. Designed and implemented ETL DataStage applications that integrated data from multiple sources into multiple targets.
  • Responsible for new development - Wrote SQL Queries, Designed and coded new DataStage jobs. Was actively involved in all phases of testing (Unit, ST, UAT, UCT). Responsible for migrating Source Code & UNIX scripts to Production. Handled Deployment, Production Support, Troubleshooting production issues as well as data issues, and Writing Documentation.
  • Wrote Documentation which was then housed on a dedicated Sharepoint site.
  • Coordinated and provided specifications to remote ETL Developers.
  • Extensive experience working directly with Off-shore consultants, Business Management, End users, IT Management, Vendors, and Technical staff.
  • Worked with offsite Vendor Technical Support for problem resolution.
  • Provided on call support and problem resolution for a 24/7 Production environment - including many high priority SEV1 Production issues. Provided root cause analyses of production problems.
  • Provided subject matter expertise and interacted directly with other developers, technical staff, the business community, and management. Represented team Confidential meetings with business users as well as in meetings with technical staff from various departments.
  • Actively participated in High Level Design reviews.
  • Led Design and Code reviews.
  • Produced SDLC documentation as required.
  • Mentored, trained, and collaborated with other developers.

Confidential - Wilkes Barre, PA

Programmer/ Analyst

Responsibilities:

  • Provided Applications Development Support for the Billing System of a major telecom company - Coded and tested enhancements, Production Implementation and Support, Documentation, & Troubleshooting both Systems and Applications issues.
  • Provided 24/7 Production Support.
  • Researched, and successfully resolved outstanding Remedy Tickets as needed.
  • Provided root cause analyses of production problems.
  • Documented Production job flows & created a Production Run Sheet Check Off List to enable colleagues to check prod cycles in a timely manner. In addition, this served as a back-up reference so that new team members would not “miss anything” when monitoring nightly production cycles.

Confidential, Red Bank, NJ

Applications Developer

Responsibilities:

  • Provided Applications Development Support for the Claims Div. of a Property & Casualty Insurance Company - Coded and tested enhancements, Production Implementation, Documentation, Troubleshooting both Systems and Applications issues, Disaster Recovery.
  • Test planning and execution.
  • Provided 24/7 Production Support.
  • Researched, and successfully resolved outstanding Remedy Problem Tickets.
  • Tested Online Screens for Disaster Recovery purposes.
  • Special Projects: Designed, Developed, Coded, & Tested SQL queries that extracted selected data off of a Problem Tracking database housed on MS SQL Server. This data was used in formatting Daily Management Reports detailing Open and Closed Help Desk Work Orders.
  • In addition, documented, and implemented procedures to automate these queries for ease of use on a daily basis.

We'd love your feedback!