Senior ETL Developer
Experience:5 - 9 Years
Location:Malaysia
Education:UG - Any Graduate - Any Specialization,Graduation Not Required PG - Any PG Course - Any Specialization,Post Graduation Not Required
Industry Type:IT-Software/ Software Services
Role:Software Developer
Functional Area:DBA, Datawarehousing
Desired Candidate Profile
Responsibilities and Accountabilities:
Provide guidance to junior ETL developers within the team in ensuring adherence to the BI development/customization standards.
Work closely with the Data Architect to re-engineer the existing Oracle Data Warehouse environment and provide a scalable global EDW
Build regional data marts for ResMed entities
Build necessary ETL mechanisms for data transfer from various source application (predominantly Oracle Applications)
Design conformed dimensions, slowly changing dimensions and star schemas as required various subject areas
Actively contribute to developing data warehousing best practices for new reporting and analysis requirements as required
Participate in BI projects in an ETL developer / data modeler capacity, as required
Translate functional specifications to technical design documents as needed
Position Specific IT Skills:
Oracle 10g (8i) required
PL/SQL skills in the Data Warehouse environment(required)
SQL Loader (required)
ETL skills using Oracle Warehouse Builder (OWB)
Use of TOAD
Windows and UNIX platforms
Qualifications and Experience:
Demonstrated experience in engineering Data Warehouses from the ground up
Involvement in at least one major data warehousing project in an Analyst Programmer’s / ETL Developer’s / Data Modeller’s capacity
In depth understanding of OLAP technology and data modelling tools.
5 years exposure to Oracle and BI / EDW environments
Desirable
Discoverer, Noetix views
Exposure to Oracle ERP (especially A/R module)
Exposure to the Cognos 8 suite
Job Description
Responsibilities and Accountabilities:
Provide guidance to junior ETL developers within the team in ensuring adherence to the BI development/customization standards.
Work closely with the Data Architect to re-engineer the existing Oracle Data Warehouse environment and provide a scalable global EDW
Build regional data marts for ResMed entities
Build necessary ETL mechanisms for data transfer from various source application (predominantly Oracle Applications)
Design conformed dimensions, slowly changing dimensions and star schemas as required various subject areas
Actively contribute to developing data warehousing best practices for new reporting and analysis requirements as required
Participate in BI projects in an ETL developer / data modeler capacity, as required
Translate functional specifications to technical design documents as needed
Position Specific IT Skills:
Oracle 10g (8i) required
PL/SQL skills in the Data Warehouse environment(required)
SQL Loader (required)
ETL skills using Oracle Warehouse Builder (OWB)
Use of TOAD
Windows and UNIX platforms
Qualifications and Experience:
Demonstrated experience in engineering Data Warehouses from the ground up
Involvement in at least one major data warehousing project in an Analyst Programmer’s / ETL Developer’s / Data Modeller’s capacity
In depth understanding of OLAP technology and data modelling tools.
5 years exposure to Oracle and BI / EDW environments
Desirable
Discoverer, Noetix views
Exposure to Oracle ERP (especially A/R module)
Exposure to the Cognos 8 suite
Keywords: ETL, SQL Loader, TOAD, Oracle Warehouse Builder, PL / SQL
Contact Details
HTC Global Services (India) Pvt. Ltd.
Website:https://www.htcinc.com
Executive Name:NarayanaSamy
Address:HTC Global Services (India) Pvt Ltd
Unit 25, SDF II, Phase II MEPZ, Tambaram Chennai
CHENNAI,Tamilnadu,India 600001
Email Address:narayana.samy@htcindia.com
Telephone:91-44-22625044