Permata Bank – Antasena ETL Pipelines

As a Data Engineer at AMARTEK, I was embedded in Permata Bank's Antasena platform — a high-stakes enterprise banking data environment.

My core responsibility was developing and maintaining production ETL pipelines using SSIS and SQL Server, ensuring data accuracy and consistency across multiple concurrent client environments.

What I built

• Developed and maintained 40–50 stored procedures and ETL pipelines using SSIS and SQL Server.
• Handled 6 projects covering new pipeline development, table additions, and transformation logic modifications.
• Collaborated directly with Permata Bank stakeholders to translate business requirements into scalable data solutions.
• Monitored, troubleshot, and resolved pipeline incidents to maintain data consistency in production.
• Optimized stored procedures for large-scale data transformation, improving pipeline reliability and processing efficiency.