Streamlining Data Migration and ETL Processes in Banking with Automation and BI Tools
summary
Describes an implemented ETL and migration pipeline that replaces manual bank processes with automated workflows using Informatica, AWS Glue, Airflow and Teradata for processing and Power BI and Tableau for decision dashboards. Claims include higher data accuracy, faster scalable daily throughput, lower legacy maintenance cost, and enforced PII encryption plus role‑based access controls. Workflow standardizes formats, runs validations and cleansing before loading, and deploys with no data loss or compliance breaches in production.
AI-written summary · about
chapters (7)
- 0:00Data migration in banking
- 2:34Traditional banking challenges
- 5:09Banking data and compliance
- 6:55Automation benefits in ETL
- 9:44Automation and BI tools
- 11:55Secure data migration best practices
- 14:04Conclusion
related talks
13mHow to automate legacy ETL migration to AWS Glue
29mHow financial services companies derive greater value from data with AWS
51mIncreasing Productivity and Reducing Costs in Big Data Ecosystems on AWS
42mWeb Development To Big Data. A Journey
30mData Engineering building your BI infrastructure from scratch
34mTales of Data Architecture Evolution
27mData-Driven Approach to Process Automation in Banking
26mBuilding a data lake at a bank #bbuzz