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.

• 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.

ETL Pipeline Development