ABOUT THE ROLE
The holder of this position works with a team of professionals with development support in ETL / SAP Business Objects.
THE ETL DEVELOPER WILL:
－ Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts.
－ Assist in the ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL－related activities
－ Provide technical knowledge of Extract/Transform/Load （ETL） solutions for Business Intelligence projects
－ Work closely with project Business Analyst, Data Modeler and BI Lead to ensure that the end to end designs meet the business and data requirements
－ Develop the task plan for ETL developers for a specific project
－ Participation and contribution in quality assurance walk through of ETL components
－ Support development teams with performance tuning and troubleshooting issues
－ Proficient with a database SQL language for user defined database extract or update statements. SQL and database skills are the two great building blocks for ETL work.
－ Work closely with Project Manager to develop and update the task plan for ETL work and to keep the manager aware of any critical task issues and dependencies on other teams
－ Ensure the ETL code delivered is running, conforms to specifications and design guidelines
－ Unit testing ETL code to ensure it can be delivered and run in a system testing environment.
－ Review of ETL design documents and working closely with Business/Architect team
－ Understands the range of options and best practices for common ETL design techniques such as change data capture, key generation and optimization
－ Bouncing Activities or Restarting the Services
－ Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
－ Monitor all business requirements and validate all designs and schedule all ETL processes and prepare documents for all data flow diagrams.
－ Analyze and interpret all complex data on all target systems and analyze and provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
－ Develop all data warehouse models and prepare reports for all metadata integration into systems and draft all ETL scripts and prepare required reports for all end users.
－ Be able to proactively monitor the overall system from the data load perspective and take appropriate actions to improve the overall implementation.
－ Should have strong ability to troubleshoot performance and configuration related issues including connectivity issues due to firewalls, load balancers etc.
EXPERIENCE – ESSENTIAL
－ ETL Knowledge any tool （Talend/Informatica/Data Stage）
－ Experience of ETL Developer
－ Exposure to BI tools such SAP BO/SSIS/Cognos/QlikView/Tableau
EXPERIENCE – DESIRABLE
－ Experience in the insurance industry will be a good to have
－ Global project implementation
－ Onsite－Offshore business model
QUALIFICATIONS AND EDUCATION REQUIREMENTS
－ University degree
－ Bilingual Japanese and English
Japanese: Business Level （at least JLPT 2）
English: Business Level