ilfijandrisno

Senior Data Engineer

Experienced IT professional with a strong background in banking management information systems (MIS), data engineering, and business intelligence. Proven expertise in ETL processes, data warehousing, analytics, budgeting, and activity-based costing. Skilled in designing interactive dashboards that enhance decision-making and reduce analysis time. Adept at working with various tools and technologies including SQL Server, SSIS, Python, Tableau, AWS, and IBM solutions. 


Experience: 7 years

Yearly salary: $22,000

Hourly rate: $15

Nationality: 🇮🇩 Indonesia

Residency: 🇮🇩 Indonesia


Experience

Data Engineer
Optus Solution
2019 - 2022
Project on Bank Mandiri Taspen - Synergize the Master Data Management process with the parent company Bank Mandiri in relation to the output data that needs to be provided. - Building an ideal Data Quality Management at Bank Mantap. - Perform ETL (Extract, Transform, Load) - Models data structure from product needs to database tables. - Perform query testing on large datasets, and define the best practices of data query style to meets business requirement. - ETL Tools (Datastage), SQL Server. Project on Bank Mandiri - Updating IBM InfoSphere Information Server with multinode Massive Parallel Processing (MPP). - Conducts a system architecture evaluation and collaborates with project management and IT development teams to improve the architecture. - Evaluates project constraints to find alternatives, alleviate risks, and perform process re-engineering if required. - Installed and configured IBM IIS and also troubleshoot problems arising from IBM IIS functionality. - Monitor, troubleshoot, and resolve system alerts for managed infrastructure services in an environment. - Coordinate with the IBM Support center and other related team for any problem escalation - Provided a documentation to client needs such as FSD, TSD and VIT (Vendor Internal Testing). - Linux RHEL (Red Hat Enterprise Linux), IBM DB2, IBM IIS

Skills

aws
big-data
data-entry
data-viz
linux
python
sql
english
indonesian