We provide IT Staff Augmentation Services!

Datastage Developer Resume

Charleston, WV

SUMMARY:

13 years of experience in IT experience using DataStage, Implementation and Testing of ETL applications for Banking and Healthcare using Data Extraction, Data Cleansing, Data Transformation, Data Loading and Data Analysis. Strong experience in Data Warehouse projects, familiar with all areas of Data warehouse. Expertise in data requirement analysis, design, development of ETL process using Confidential Data Stage v7.5 thru 11.3 Data Stage Designer, Data Stage Director, Parallel Extender (PX) and experience with Information Analyzer and Quality Stage

TECHNICAL SKILLS:

Operating Systems: Linux, Unix Sun Solaris 5.10, AIX 5.3

Languages: SQL, T - SQL, My SQL

Tools: Confidential InfoSphere DataStage, QualityStage, Information Analyzer, Autosys, Toad, SQL Plus, SQL Server Management Studio, and others

Databases: Oracle 9I, DB2, MS SQL, SQL Server, Vertica and Netezza

PROFESSIONAL EXPERIENCE:

Confidential, Charleston, WV

DataStage Developer

  • Worked remotely
  • Documented extensive Confidential InfoSphere Data warehouse processes in DataStage 11.3
  • Work was off-shored

Confidential

DataStage Developer

  • Developed and modified DataStage jobs using Runtime Column Propagation to dump many tables
  • Developed Job Sequences, job activities, execute commands, user variable activity and implemented logic for job sequence loops, recovery and restart
  • Created detailed design documents for ETL jobs and Sequences
  • Worked with State of Delaware Medicaid and Medicare systems
  • Migrated jobs from DataStage 8.5 to 11.3
  • Developed jobs to load data in slowly changing dimensions to the Data Warehouse using CDC Stage using DataStage 11.3
  • Utilized Pivot, Looping, Transformer, Join, Lookup, User variables, Command stage and other stages

Confidential

DataStage Developer/Business Analyst

  • Worked as Business Analyst for Basel certification
  • Confidential InfoSphere DataStage Version 9.5
  • Reviewed scope and requirements to achieve Basel certification
  • Created documentation for gaps and test cases for the same
  • Completed all required training for fraud prevention and other financial related crimes

Confidential

Senior Technical Consultant

  • Participated in analysis and design of new ODS from existing warehouses
  • Developed tested and maintained Confidential InfoSphere DataStage jobs and Sequences.
  • Implemented slow changing dimensions using Change Data Capture stage to load the Data Warehouse
  • Created processes to extract Master Data from several sources using DataStage 9.1.2

Confidential

Senior Technical Consultant

  • Attended HIPAA training to for Data security and privacy requirements
  • Adhered to HIPAA Privacy Rules and Compliance and received required training for the same
  • Created and Updated DataStage jobs and sequences to load data into Netezza Data Warehouse
  • Created Unix scripts to run the assets required to be implemented

Confidential

Lead DataStage Developer

  • Created DDLs for DB2 and Vertica tables from Mainframe files and loaded the same tables
  • Used Linux scripts and Osh Wrappers to load tables to Vertica
  • Created and implemented Information Analyzer and QualityStage rules
  • Performed thorough data profiling by using the Investigate stage of Quality Stage
  • Provided technical expertise and assisted DataStage developers with creating jobs and following best practices
  • Created JIL scripts for implementation of effective Autosys jobs (job scheduler)
  • Developed jobs to load data in slowly changing dimensions using CDC Stage in DataStage 9.5
  • Used Autosys job scheduler for automating the monthly regular run of DW
  • Migrated and Tested all programs in several different environments

Confidential

DataStage Developer

  • Provided experienced technical consulting in the definition, design, and creation of many DataStage jobs in FDB
  • Reviewed test results and verified Data transformations where implemented according to designed mappings
  • Debugged and resolved any Data issues with Unicode and various NLS maps
  • Implemented several Bit fields to match Data as it is produced today using PL/1 in a mainframe environment
  • Mentored, assisted and lead junior DataStage developers and implemented DataStage ETL standards
  • Developed many DataStage jobs on 8.5 using many different stages such as DB2 connectors, Transformers, Filters, Look ups, Joins and Complex Flat Files and others
  • Assisted in trouble shooting issue HM jobs implemented April 2012

Hire Now