We provide IT Staff Augmentation Services!

Senior Datastage Developer Resume

SUMMARY

  • Senior ETL - Datastage developer with close to 7 years (6yrs 11 months) of experience on ETL, Data profiling and Data migration between application databases and data warehouses
  • Using ELT or ETL frameworks to extract, transform and load data to maintain Type1 and Type 2 dimensional tables and fact tables in Data warehouses/Marts
  • Developing and Leading the technical design, Development, Testing, Maintain and support New and existing Applications
  • Experience in Migrating data from/into Data Marts and Data Warehouse built on Star Schema or Snowflake Schema along with implementing Decision Support Systems.
  • Good understanding with hands on of Data Profiling, Relational Data Modeling and unstructured Data
  • Impact Analysis, Troubleshooting, solving complex problems and addressing issues like performance tuning of DataStage jobs .
  • Worked on DataStage Migration projects from 8.7,9.1 to 11.5
  • Worked on PL/SQL, Oracle, DB2, Control-M and UNIX commands.
  • Worked on hive for data archiving and building data lake
  • Creating and reading Hive tables, partitioning Hive tables into buckets for performance.
  • Writing Hive queries, writing into Hive tables for data Archiving.
  • Designing application level Data Models by creating the data models with normality up to 3NF
  • Data cleansing and re-structuring before loading into the ODS tables and further to the Data marts
  • Used python programming scripts for ETL controlM framework

TECHNICAL SKILLS

  • Infosphere DataStage PX 8.1, 8.5,8.7, 9.1,11.3, 11.5
  • SQL and PL/SQL,
  • Unix commands & Shell Scripts,
  • Hive
  • Python
  • IBM DB2,
  • SQL Server 2005 & 2008,
  • Oracle 9g
  • Netezza

PROFESSIONAL EXPERIENCE

Confidential

Senior Datastage Developer

Responsibilities:

  • Used the generic framework built by re-usable components of data stage to perform all the extraction and load processes.
  • Used Remove Duplicate stage, sort stage, Transformer stage, Filter stage, Join stage, Copy stage, Sequential file, Lookup stage, DB2 connector stage, Dataset stage, Funnel stage, MQ connector stage, XML Transformer stage etc. for development, enhancement and performance tuning of DataStage ETL jobs.
  • Importing & Exporting the Jobs/ sequencer from one server to another server and involved in preparing build for DataStage migration to Dev, UAT and production.
  • Preparing Technical Design document, STM (Source to Target Mapping) for DataStage development
  • Involved in creating job sequences and used different stages like Notification Activity, exception handler.
  • Preparing the unit test case document based on the Low level Documentation
  • Python programming to trigger generic ETL framework.
  • Build jobs/sequences for Data-strategy, data masking as key primary member.
  • Participated in daily scrum calls, backlog refinement, iteration planning and other agile ceremonies
  • Involved in requirement gathering, discussion with business analyst and other team members.
  • Involved in writing PL SQL complex queries, stored procedure for requirements.
  • Responsible for Identifying and Fixing Performance Bottlenecks on DataStage business Mappings
  • Read and write into Hadoop file system and hive tables

Confidential

Senior Datastage Developer

Responsibilities:

  • Preparing Technical Design document, STM (Source to Target Mapping) for DataStage development.
  • Preparing the unit test case document based on the Low level Documentation.
  • Used DataStage as an ETL tool to extract data from source systems, data validations, aggregate the data filter and load into the target tables and create XML as output.
  • Used Remove Duplicate stage, sort stage, Transformer stage, Filter stage, Join stage, Copy stage, Sequential file, Lookup stage, DB2 connector stage, Dataset stage, Funnel stage, MQ connector stage, XML Transformer stage etc. for development, enhancement and performance tuning of DataStage ETL jobs.
  • Participating DRB call as ETL Team lead and Senior DataStage developer.
  • Importing & Exporting the Jobs/ sequencer from one server to another server and involved in preparing build for DataStage migration to Dev, UAT and production.
  • Involved in creating job sequences and used different stages like Notification Activity, exception handler.
  • Involved to build jobs/sequences for Data-strategy, data masking as key primary members.
  • Participated in daily scrum call/meeting for agile methodology.
  • Involved in code and job review meetings and providing solutions for improved the performance tuning of the ETL DataStage jobs.
  • Involved in requirement gathering, discussion with business analyst and client team members.
  • Involved in writing PL SQL complex queries, stored procedure for requirements.
  • Responsible for Identifying and Fixing Performance Bottlenecks on DataStage business Mappings
  • Involved and interacted with users, business and release management team members during DataStage code migration to Dev, UAT and Production

Confidential

Datastage Developer

Responsibilities:

  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
  • Preparing Technical Design document, STM (Source to Target Mapping) for DataStage development.
  • Preparing the unit test case document based on the Low level Documentation.
  • Used DataStage as an ETL tool to extract data from source systems, data validations, aggregate the data filter and load into the target tables and create XML as output.
  • Used Remove Duplicate stage, sort stage, Transformer stage, Filter stage, Join stage, Copy stage, Sequential file, Lookup stage, DB2 connector stage, Dataset stage, Funnel stage, MQ connector stage, XML Transformer stage etc. for development, enhancement and performance tuning of DataStage ETL jobs.
  • Participating DRB call as ETL Team lead and Senior DataStage developer.
  • Importing & Exporting the Jobs/ sequencer from one server to another server and involved in preparing build for DataStage migration to Dev, UAT and production.
  • Involved in creating job sequences and used different stages like Notification Activity, exception handler.
  • Involved to build jobs/sequences for Data-strategy, data masking as key primary members.
  • Participated in daily scrum call/meeting for agile methodology.
  • Involved in production support as a DataStage specialist.
  • Involved in code and job review meetings and providing solutions for improved the performance tuning of the ETL DataStage jobs.
  • Involved in requirement gathering, discussion with business analysts and client team members.
  • Involved in managing and handling offshore/onshore DataStage team members.
  • Involved in writing PL SQL complex queries, stored procedure for requirements.
  • Responsible for Identifying and Fixing Performance Bottlenecks on DataStage business Mappings
  • Involved and interacted with users, business and offshore/onshore team members during DataStage code migration to Dev, UAT and Production .
  • Read data from hive DB for processing.

Hire Now