Urgent C2C Hiring || DataStage Admin || Naperville, IL (Onsite)

Role – DataStage Admin

Location – Naperville, IL (Onsite).

Visa – GC/ USC/GC-EAD/ H1B

Role Description:

• 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 knowledge 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.

Thanks & Regards

Santosh kumar

Technical Recruiter 

Email: santosh.kumar@q1tech.com