Posts Tagged ‘ETL specialists’

0

Oracle ETL Developers

Ajilon (formerly AeM Group) is a national professional services company with global capability. Our committed and talented professionals have delivered world class IT and business Consulting services across a wide range of industries. As a member of global professional services group Ajilon, we offer world-class employment opportunities.

We are now looking for an experienced Data Warehouse ETL specialists to fill an exciting new role with Ajilon.

To be successful you will be experienced with;

* Expertise in an Oracle environment (preferably 10g)
- Strong SQL
- Star Schema Database Design
- Performance tuning of large databases (queries and loads)
- Oracle partitioning
- Strong PL/SQL
- TOAD or equivalent IDE
- Use of a Data Modeling Design tool eg PowerDesigner, Erwin
- Knowledge of Data Replication
- Knowledge of SQL Server, DB2, Ingres (not essential)
* Data Warehouse Design
- Dimensional Modeling (Star Schemas)
- Hierarchy build and management
- Data Marts development and maintenance
- Source System Analysis (ERP background useful)
- Data Mapping/Transformation – Meta data
* Unix Experience
- Korn Shell

Optional:
* Business Subject Areas
- Finance, Logistics, Risk, Works and Project Management, Human Resources, Asset management, Enterprise Dashboards and Scorecards Continue reading…