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

TP Consulting; Indonesia; On-site; IDR 120,000,000 - 180,000,000; Full time

Job summary

TP Consulting is seeking an ETL Developer in Indonesia to architect and implement robust ETL pipelines using SSIS and manage SSMS databases. You will optimize data extraction, transformation, and loading processes for enterprise data warehouses while ensuring data quality, governance, and security.

You will collaborate with data analysts, BI teams, and stakeholders to deliver reliable data migrations and real-time reporting.

Qualifications

• Bachelor's degree in CS/IT or related field.
• 2+ years of ETL, data engineering, or DB administration experience.
• Hands-on with SSIS and SSMS in production environments.
• Strong relational DBMS knowledge, dimensional modeling, and data warehousing concepts.
• Proficient in T-SQL, stored procedures, UDFs, and views.
• Experience with data validation, error handling, and performance tuning.
• Excellent analytical, communication, and teamwork abilities.
• Indonesian citizenship and residency required.

Responsibilities

• Design, develop, test, and deploy ETL pipelines using SSIS.
• Manage and query relational databases with SSMS; optimize T-SQL.
• Extract data from diverse sources; transform and load to data warehouses.
• Troubleshoot ETL issues and resolve data integrity problems.
• Monitor jobs, analyze logs, and ensure SLA compliance.
• Collaborate with data architects, engineers, BI analysts, and stakeholders.
• Ensure data governance, security, and backup procedures.
• Maintain technical docs, data lineage, and deployment runbooks.

Skills

ETL development

SSIS

SSMS

SQL

Data warehousing

Data governance

Analytical skills

Education

Bachelor's degree in Computer Science/IT or related

Tools

Azure Data Factory

Snowflake

Job description

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)