ETL Developer (SSIS & SSMS) | TP Consulting | Indonesia

Tech Junction Ltd; Tangerang; Hybride; IDR 120 000 000 - 240 000 000; Plein temps

Résumé du poste

TP Consulting seeks an ETL Developer to lead on-site data integration in Indonesia. You will design, build, test and maintain SSIS pipelines, manage SSMS databases, and optimize queries for enterprise data warehouses, enabling real-time reporting and BI capabilities.

With 2+ years in ETL or related roles, you will work with enterprise clients and recruitment consultants to ensure data integrity, governance, and scalable data migrations while adhering to SLAs and security standards.

Qualifications

• Bachelor's degree in a technical discipline.
• 2+ years in ETL development, data engineering, or database admin.
• Hands-on SSIS and SSMS experience.
• Knowledge of DW concepts and T-SQL.
• Strong data validation and performance tuning skills.
• Excellent communication and Indonesian citizenship and residency.

Responsabilités

• Design, develop, test, and deploy ETL data pipelines with SSIS.
• Administer relational databases using SSMS and write optimized T-SQL.
• Extract from diverse sources, cleanse, transform, and load to data warehouses.
• Troubleshoot ETL packages and monitor jobs to meet SLAs.
• Collaborate with analysts, engineers, and stakeholders; document workflows.

Connaissances

SSIS

SSMS

SQL

Data warehousing

ETL design

Data governance

Formation

Bachelor’s degree in Computer Science / IT / Software Engineering

Outils

SSIS

SSMS

Description du poste

Position Summary

Driving advanced data integration, extract, transform, and load (ETL) pipeline engineering, and enterprise database management across Indonesia, TP Consulting is actively seeking an accomplished ETL Developer proficient in SSIS and SSMS for a permanent professional engagement. In this vital technical role, you will architect, build, test, and maintain high-performance data transformation workflows, ensuring uncompromised data integrity, seamless database synchronization, and scalable data warehousing architectures. Bringing a solid foundation in data engineering and database management systems, you will empower global enterprise clients to achieve efficient data migration, real‑time reporting capabilities, and robust business intelligence operations. This prestigious career opportunity offers competitive remuneration, professional development, and career growth within a premier international recruitment and IT consulting enterprise.

Detailed Job Description

As an ETL Developer supporting TP Consulting on an on-site basis in Indonesia, you will take full operational, tactical, and technical ownership of ETL pipeline design, SQL Server Integration Services (SSIS) package development, SQL Server Management Studio (SSMS) database administration, and query optimization. Your day-to-day responsibilities include building automated data extraction routines, transforming complex datasets, loading structured data into enterprise data warehouses, troubleshooting data pipeline failures, collaborating with data analysts and business stakeholders, and interacting directly with professional recruitment consultants like Sabrina Akef.

Key Responsibilities

• Design, develop, test, and deploy robust ETL data pipelines, data integration routines, and automated transformation workflows utilizing SSIS.
• Manage, query, and administer relational databases utilizing SQL Server Management Studio (SSMS), writing optimized T‑SQL scripts and stored procedures.
• Extract data from diverse source systems, apply rigorous data cleansing and transformation rules, and load clean data into staging and target data warehouses.
• Troubleshoot, debug, and optimize existing ETL packages, resolving data truncation, type mismatch, and performance bottleneck issues.
• Monitor scheduled data integration jobs, analyze execution logs, and resolve runtime failures in alignment with enterprise SLAs.
• Collaborate seamlessly with data architects, software engineers, business intelligence analysts, and client stakeholders.
• Ensure strict adherence to data governance policies, security standards, and database backup protocols.
• Maintain meticulous technical documentation, data lineage mapping, ETL architecture diagrams, and deployment runbooks.

Required Qualifications & Skills

• Bachelor’s degree in Computer Science, Information Technology, Software Engineering, Data Analytics, or related technical discipline.
• Minimum of 2+ years of progressive professional hands‑on experience in ETL development, data engineering, or database administration.
• Mandatory hands‑on experience and demonstrable operational expertise with SQL Server Integration Services (SSIS) and SQL Server Management Studio (SSMS).
• Comprehensive working knowledge of relational database management systems, dimensional modeling, and data warehousing concepts.
• Deep practical proficiency in writing complex T‑SQL queries, stored procedures, user‑defined functions, and database views.
• Solid practical grasp of data validation, error handling routines, and performance tuning for large datasets.
• Exceptional analytical problem‑solving aptitude, meticulous attention to detail, and professional communication skills.
• Mandatory Indonesian citizenship and physical residency for professional operations in Indonesia.

Nice-to-Have Skills

• Professional certifications such as Microsoft Certified: Data Engineer Associate or Azure Database Administrator.
• Hands‑on familiarity with cloud data platforms (Azure Data Factory, Snowflake) and modern data stack orchestration tools.
• Prior professional working experience in top‑tier multinational consulting firms, banking institutions, or telecommunications enterprises.
• Experience utilizing enterprise agile tracking platforms (Jira, Confluence) for task coordination and sprint execution.
• Active participation in data engineering communities, technical forums, or database developer meetups.

Application Information

Recruiter: TP Consulting Recruitment Division

Contact Name: Sabrina Akef (Recruitment Consultant)

Email: [e-mail]

Phone:

Company Website: https://www.tpcrecruit.com

Salary/Rate: Market Competitive / Enterprise Consulting Package

Deadline: Open until filled (Urgent Indonesia ETL Developer Opening)

Notice Period: Immediate to 30 Days Preferred

Contract Duration: Permanent / Full-Time Engagement (Indonesia)