This is a position reporting to the Head of Business Analytics in the xxxx Classifieds Group, within China Development Center. The Developer will be responsible for designing, developing, and implementing Data Warehouse applications in an enterprise data warehouse system.
Responsibilities will include:
· Work in cooperation with the Euro Analysis and Development team to prepare logical and physical design documents. These specifications will detail the operation of software intended to extract, transfer and load information from various data sources into the xxxx data warehouse.
· based on the detailed specifications, develop Extract, Transform and Load (ETL) programs (AbInitio, Teradata SQL, Perl/shell script) to populate the warehouse from various source systems(Oracle,Mysql,xml,flat files). Tune the programs and queries to optimize data load/transform times, ensure data accuracy, error handling and escalation.
· Work with the local development and QA group to document and execute Test plans.
·Report weekly on progress and deliverables against plan.
· Write the support documentation, assist the production handover and deployment the new applications to production.
·Build reports according to business requirement and maintains the existed reports
Job Requirements:
(Knowledge, skills, abilities, experience required to perform job)
Given the goals for this position, candidates must:
· Demonstrate effective communication written and verbal English skills.
· Also demonstrate excellent organization skills.
· Possess a BS degree in Computer Science or equivalent
· 2+ years implementing a large-scale data warehouse system (preferably Oracle and Teradata DBMS)
· Strong SQL skills (Oracle, Teradata) and good knowledge of UNIX and Perl.
· Good understanding of data warehousing concepts including dimensional modeling (star/snowflake), Extraction/Transport/Loading best practices.
· Performance tuning experience with large relational databases necessary. Knowledge of ETL tools (AbInitio, Informatica) is a plus.
· Experience in BI tools like MSTR/SAS report is a plus
· Ability to think logically and analyze application and business
