Skillhouse Internal Career Opportunity
ETL Engineer (Informatica Power Center )
Position Title:
ETL Engineer (Informatica Power Center )
Employment Type:
Permanent
Working Hours:
English Level - Advanced (TOEIC 860),Japanese Level - Low Intermediate (JLPT Level 4)
Salary
Description
A Leading European Global Insurance Company is seeking an experienced ETL Engineer for Cloud integration to join their dynamic team.
An ETL Engineer for Cloud integration is a professional who designs, develops, tests, and maintains the Extract Transform Load (data integration) workflows that enable the smooth and efficient transfer of data on the Cloud or between the cloud and on-premise systems. The role of an ETL Engineer involves understanding the source data, its format, and quality, mapping the data requirements to the target system, and ensuring data quality, accuracy, and consistency. ETL Engineer uses various tools and technologies such as SQL, ETL frameworks, data modeling. ETL Engineer works closely with local as well as remote peer IT teams, Data Governance team.
Responsibilities:
- Design, set up, develop, test, and maintain the ETL pipeline from ingestion to destination
- Own data integration at the project level on a need basis
Required Skills:
- Hands-on experience with AWS Glue, Informatica Power Center, data modeling, SQL, AWS Lambda, Serverless, Terraform
- Understanding of Infrastructure as Code (IaC) and source code management with GIT/GIT Hub.IaC, GIT/GIT Hub
- Knowledge of data ingestion, transformation, modeling, security, governance, privacy, schema design, and optimal data store design for AWS cloud-based solutions
- Ability to analyze data, verify data quality, and ensure data consistency using AWS services
- Database issues, pipeline issues, data model design, ETL pipeline design aligned with business requirements and standards
Why should you apply:
- Improvement of user satisfaction: This is a challenging position where you can directly contribute to improving user satisfaction by solving end-user problems
- Global collaboration: You will work closely with the Asia team (Hong Kong) and gain international experience
- Diverse technical support: You can utilize your support experience in a wide range of technical areas, including Citrix XenDesktop VDI, Windows PC, Office365 products, etc.
Company Overview
This international insurance company serves as a key regional hub in Asia for a major global insurance group. It offers a wide range of insurance services to individual customers through various channels, including direct sales, partnerships, and agencies, meeting diverse customer needs. Founded in Europe in the 19th century, the global insurance group now operates in more than 215 countries and regions, with approximately 55,000 employees worldwide, offering a comprehensive suite of insurance products and services.
Working hours: Monday-Friday 9:00-18:00
Working Style: Hybrid (daily office attendance is required for the first few months.
After that, the office will be open 1-2 days a week. Days in the office may change depending on the situation)
Holidays: Saturdays, Sundays, national holidays, paid vacations (10 days granted 6 months after start of work)
Benefits: Various social insurance programs (health insurance, pension, employment insurance, workers’ compensation, etc.), retirement pension plan, employee savings plan, group life insurance, startup support program (housing rent subsidy), corporate welfare club membership, Employee Assistance Program (EAP) with on-site/online counseling, childcare leave, reduced working hours for childcare, nursing care leave, flextime system, part-time work system, shift work system, early return-to-work support allowance for childcare leave, childcare support allowance for shift workers, in-house club activities, no dress code (business casual allowed).