ETL Engineer
ETL Engineer
Job type:
Permanent
Specialization:
Data and Analytics
Language Level:
English Level - Advanced (TOEIC 860),Japanese Level - Advanced (JLPT Level 1)
Location:
Tokyo
Salary:
8000000.00
Job Reference:
499230
We are seeking an ETL Engineer to support the design, development, and operation of enterprise data integration platforms for a leading international life insurance company.
In this role, you will be responsible for building and maintaining data integration solutions that enable business intelligence, analytics, and digital transformation initiatives across the organization. You will work closely with product teams, business stakeholders, application teams, and infrastructure teams to deliver scalable, secure, and reliable data solutions.
Responsibilities:
- Design, develop, and maintain ETL solutions using Informatica PowerCenter
- Support enhancement and optimization of existing ETL processes
- Participate in cloud migration initiatives for ETL platforms and data integration services
- Analyze and rationalize existing PowerCenter assets
- Support migration to Informatica Cloud Data Integration
- Design and implement data integration solutions between enterprise systems
- Create data mappings and transformation logic for business requirements
- Develop, monitor, and optimize large-scale batch processing solutions
- Collaborate with business users, product teams, application teams, and infrastructure teams
- Prepare technical documentation and provide technical guidance to stakeholders
- Coordinate with external vendors and review deliverables
- Monitor production jobs, troubleshoot issues, perform root cause analysis, and implement preventive measures
Requirements:
- 5+ years of experience designing, developing, implementing, and supporting Informatica ETL solutions
- Strong experience in data integration, data modeling, SQL development, and performance tuning
- Experience with Oracle Database and/or Microsoft SQL Server
- Experience developing, managing, or migrating solutions in cloud environments such as AWS or Azure
- Strong analytical and problem-solving skills
- Ability to work effectively with cross-functional teams and business stakeholders
- Advanced Japanese language proficiency
- Advanced English language proficiency
Why you should apply:
- Play a key role in supporting enterprise-wide data and analytics initiatives
- Contribute to large-scale cloud migration and system integration projects
- Work in a highly collaborative and international environment
- Opportunity to influence the future data platform strategy of the organization
- Clear career progression into Technical Lead, Product Owner, Management, or Chapter Lead positions
- Access to internal and external learning programs, certifications, and professional development opportunities
Work hours: 9:00 AM – 5:00 PM (Mon - Fri)
Work Location: Tokyo
Work Style: Hybrid (2–3-days/ month in office)
Holidays: Full two-day weekend system (Saturday and Sunday), National holidays, Year-end and New Year holidays, Paid leave, Special leave, Maternity and parental leave, Family care leave
Benefits: Comprehensive social insurance coverage, Retirement plan, Flexible working arrangements, Remote work program, transportation allowance, Employee savings program, Health and wellness support, Childcare and family support programs, Learning and certification support, Internal and external training opportunities
Share this job
