Description

You will manage the development, implementation, administration, and support of ETL processes for large-scale data warehouses.

Responsibilities

• Design, develop, and maintain software applications within Data Warehousing environments.
• Build Enterprise Data Warehouses (EDW), Operational Data Stores (ODS), and Data Marts.
• Implement dimensional modeling using Star and Snowflake schemas.
• Manage Slowly Changing Dimensions (SCD) including Type 1, Type 2, and Type 3.
• Apply normalization and denormalization concepts to relational database structures.

Required Skills

• 5+ years of experience in data warehousing and ETL processes.
• Expertise in SQL and PL/SQL, including stored procedures, functions, packages, cursors, triggers, indexes, and views.
• Strong knowledge of relational database concepts and Entity Relation Diagrams (ERD).
• Proficiency with data modeling tools like ERWIN.
• Experience with Kimball and Inmon dimensional modeling techniques.
• Hands-on experience with Teradata.
• Working knowledge of Tableau, OBIEE, or Business Objects (BO XI r2).
• Degree in any graduate field.

Preferred Skills

• Experience with large-scale data warehouse administration.

Key Skills

Education

Any Graduate