Data Consultant

PT IDstar Cipta Teknologi (IDstar); Jakarta Pusat; On-site; IDR 180,000,000 - 300,000,000; Full time

Job summary

PT IDstar Cipta Teknologi (IDstar) is seeking an experienced ETL Developer/Data Engineer to design, develop, and maintain scalable data pipelines. You will extract, transform, and load data from multiple sources into target systems, ensuring data quality and reliability.

Responsibilities include optimizing ETL workflows using Ab Initio, Python, and Apache Spark; troubleshooting datapipeline issues; and collaborating with data engineers and analysts to support data integration and reporting

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Information Systems, or a related field.
• 4–8 years of experience as ETL Developer, Data Engineer, or similar role.
• Strong understanding of ETL concepts, data warehousing, data integration, and data quality management.
• Experience with SQL and relational databases.
• Strong analytical, problem-solving, and troubleshooting skills.
• Good communications skills and the ability to collaborate effectively within a team.

Responsibilities

• Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into target systems.
• Develop and optimize data integration workflows using Ab Initio, Python, and Apache Spark.
• Optimize ETL workflows and data processing performance to handle large-scale datasets efficiently.
• Troubleshoot datapipeline issues and implementsolutions to improve reliability and performance.
• Collaborate with data engineers, business analysts, and other stakeholders to support data integration and reporting requirements.

Skills

ETL design

Data pipeline

Python

SQL

Education

Bachelor's degree in Computer Science/Information Technology/Information Systems

Tools

Ab Initio

Apache Spark

Python

SQL

Job description

Company Description PT IDstar Cipta Teknologi (IDstar) is an Indonesia-based IT consulting and digital transformation company serving 30+ enterprise clients across Asia, Oceania, North America, and Africa. Supported by ISO 9001 and ISO 27001 certifications, IDstar has delivered over 1,000 successful projects by combining local insight with global execution standards. With a pool of more than 900 pre-screened IT professionals and partnerships with leading technology providers such as UiPath, IBM, and Josys, the company focuses on IT talent solutions, Intelligent Automation (RPA), and SaaS support. Positive reviews on platforms like GoodFirms and Glassdoor highlight IDstar as a trusted partner for smart, secure, and future-ready digital transformation.

Job Description :

• Design,develop,andmaintainETLprocessestoextract,transform,andloaddatafromvarioussourcesintotargetsystems.
• DevelopandoptimizedataintegrationworkflowsusingAbInitio,Python,andApacheSpark.
• OptimizeETLworkflowsanddataprocessingperformancetohandlelarge-scaledatasetsefficiently.
• Troubleshootdatapipelineissuesandimplementsolutionstoimprovereliabilityandperformance.
• Collaboratewithdataengineers,businessanalysts,andotherstakeholderstosupportdataintegrationandreportingrequirements.

Requirements :

• Bachelor'sdegreeinComputerScience,InformationTechnology,InformationSystems,orarelatedfield.
• 4 - 8yearsofexperienceasanETLDeveloper,DataEngineer,orinasimilarrole.
• StrongunderstandingofETLconcepts,datawarehousing,dataintegration,anddataqualitymanagement.
• ExperienceworkingwithSQLandrelationaldatabases.
• Stronganalytical,problem-solving,andtroubleshootingskills.
• Goodcommunicationskillsandtheabilitytocollaborateeffectivelywithinateam.