DataStage Admin

2 months ago

Naperville, United States Syntricate Technologies Full time
Required Skills:
  • Strong experience in development of Data warehousing solutions using Data stage 8.5 &11.5.
  • Knowledge on ETL methodology for supporting Data Extraction, transformations and load processing In a corporate-wide-ETL
  • Solution Experience in integration of various data sources like Oracle and Flat files into a Staging area.
  • Knowledge in Data analysis, design, development, implementation and production support of Data warehousing applications.
  • Extensively used Transformation Activities for Designing the Data Stage jobs.
  • Good understanding in Change Data Capture (CDC) technique skills slowly changing dimensions (SCD).
  • Create Manage and Reuse Metadata, Run and Monitor jobs using IBM Data Stage.
  • Knowledge in issue Tracking, Debugging, Monitoring, Developing of jobs.
  • Thorough knowledge on Data Warehouse on cents like Star Schema, Snowflake Schema, Dimension tables, Fact table.
  • Good knowledge in writing SQL Queries, Having enough exposure on Basic UNIX commands.
  • Strong working experience in Data Warehousing application, directly responsible for the Extraction, Transformation and Loading of the data from multiple sources into Data Warehouse.
  • should have strong knowedge on datastage client tools like designer, director
  • Should be able to import and export the jobs and need to compile them without any issues.
  • Should have ability to analyze the datastage job flow.
  • Should have basic knowledge to develop job by using several stages in datastage