Datastage Developer

E*Pro Inc; Culver City (CA); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading IT consultancy is seeking an experienced Datastage Developer in Culver City, California. The candidate should have over 7 years of hands-on experience with IBM Datastage 9.1, developing ETL solutions for large data warehouses. Strong knowledge of data warehousing concepts and relational databases is essential, alongside excellent communication skills. This role promises a dynamic work environment catering to diverse IT needs.

Qualifications

• 7-8 years working with IBM Datastage 9.1 and Quality Stage.
• Experience developing ETL jobs for multi-terabyte data warehouses.
• Strong understanding of data warehousing concepts, including snowflake and star schema.

Skills

IBM Datastage 9.1

ETL development

Data warehousing concepts

Teradata

Oracle

SQL Server

Unix shell scripting

Database Performance Tuning

Job description

E*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website www.epro-tech.com

Job Description

Title : Datastage Developer

Location : Culver City, CA

Required Skills:

• Hands on working experience of at least 7-8 years working with IBM Datastage 9.1 and Quality Stage
• Hands on experience on developing ETL jobs using Datastage 9.1
• Experience in creating Technical Design & Implementing ELT/ETL solution for multi-terabyte Data Warehouse and understand its impacts
• Understanding on Data warehousing concepts including snowflake, Star schema implementations
• Strong working knowledge of Teradata, Oracle, SQL Server and/or other large RDBMS
• Good understanding of design considerations for high volume transaction systems
• Good communication skills (Verbal + Written) and convincing skills to various stakeholders
• Knowledge of Unix shell scripting
• Experience in Data Modeling, Database Performance Tuning