ETL Engineer
MITech
- Jakarta Selatan, IndonesiaJalan Letjen M T Haryono, Tebet Barat Kel., Tebet, Jakarta Selatan, DKI Jakarta, IndonesiaJakarta SelatanDKI JakartaIndonesiaIndonesia
- ContractualCONTRACTOR
Posted 9 days ago and deadline of application is on 14 Apr
Recruiter was hiring 2 days ago
2025-02-14T09:37:51.882972+00:002025-04-14T17:00:00+00:00Job Description
- Develop, manage, and optimize ETL processes to collect data from various sources (databases, APIs, files, etc.).
- Clean, validate, and transform data to meet business requirements.
- Build efficient and scalable data pipelines to support data warehousing or lakehouse solutions.
- Design and manage database structures to support large-scale data processing.
- Optimize query performance and ETL processes for faster and more efficient execution.
- Collaborate with the data warehouse team to ensure data is properly stored and easily accessible.
- Develop automation solutions to improve ETL process efficiency.
- Monitor ETL processes to identify and resolve errors or bottlenecks in data pipelines.
- Maintain technical documentation related to ETL processes and data integration.
Minimum Qualifications
- Bachelor Degree (S1), semua jurusan
- Experience: Junior (1-3 thn), Middle (3-5 thn), Senior (52 thn)
- Experience with Oracle Data Integrator (ODI) for building ETL pipelines
- Familiar with data transformation, cleansing, and loading strategies.
- Understand ETL including error handling, logging. and performance optimization
- Experience in Oracle SQL and PL/SQL to create stored procedures and triggers for ETL operations
- Familiar with data warehouse concepts like star schema, snowflake schema, and data marts.
- Oracle Certified Specialist for Data Integration.
- Familiar with Talend Open Studio or Talend Data Integration for designing ETL jobs, transformations, and workflows.
- Understand ETL concepts and data warehousing principles, including data extraction, cleansing and transformation.
- Experience with integrating different data sources (e.g., relational databases, flat files, APIs) usTalend.
- Experience with Talend Big Data components (e.g., Spark, Hadoop, Hive, HBase) for integrating and processing large datasets.
- Experience in implementing error-handling mechanisms, logging, and monitoring for ETL
- Experience in optimizing talend jobs for performance and scalability.
- Experience in writing scripting languaes (Python, Java, or Groovy) for advance customizations.
- Talend Data Integration Certification
Jobs Summary
- Job Level
- Entry Level / Junior, Apprentice
- Job Category
- IT and Software
- Educational Requirement
- Bachelor's degree graduate
- Recruiter response to application
- Once in a while
- Office Address
- Soho Pancoran South Jakarta, Jalan Letjen M T Haryono, Tebet Barat Kel., Tebet, Jakarta Selatan, 12810, Indonesia
Feel secure when applying: look for the verified icon and always do your research on a company. Avoid and report situations when employers require payment or work without compensation as part of their application process.
About MITech
Didirikan pada tahun 2012, memulai bisnis sebagai penyedia layanan untuk ATM. Saat ini perusahaan mengembangkan solusi dan penyedia layanan multi-vendor, untuk menawarkan berbagai solusi dan layanan inovasi yang lebih luas.
VISI
Menghasilkan solusi dan layanan terbaik di bidang Layanan dan Konsultasi IT dengan upaya maksimal yang diarahkan pada kepuasan pelanggan.
MISI
Untuk membangun reputasi sebagai salah satu penyedia Solusi dan Layanan IT yang paling inovatif. Kami percaya dalam melakukan pekerjaan dengan cara yang paling efisien serta dengan metodologi yang kuat dan terstruktur, dengan evolusi bertahap dari kerja keras ke budaya kerja cerdas, untuk memenuhi kepuasan klien.
IT Consulting & Professional Services
To keep pace in the digital age while controlling costs and mitigating business risks, you can no longer depend on the past as a guide for the future. Leverage our consulting services and technology expertise to accelerate your business transformation and innovation strategies. We help you create and execute strategies to unlock opportunities, optimize processes, and uncover cost savings, with the offering as follow:
• Advisory Services. Our expert security consultants help you to secure your technologies by putting the right policies, processes, and architectures in place
• Architecture consulting services. Use existing and estimated future application traffic patterns to design a technology architecture for your organization.
• Project and programmed management services. We support the successful execution of your IT projects using robust, proven project management methodologies.
•Application Customization and Programming Services. Our Developer expert could help you to provide the customization and enhancement of your existing applications.
•QA and Automation Consultancy. Our QA and Automation expert will help you to ensure the quality of software development and deployment. Performing automated and manual tests to ensure the software created by developers is fit for purpose, include analysis of the software, and systems, mitigate risk and prevent software issues.