Job Opportunity:
We are seeking an expert in data solution design to play a pivotal role in crafting and implementing scalable data solutions tailored for consumer banking environments.
The successful candidate will be responsible for designing and delivering data solutions that meet the needs of our clients.
* Design and implement scalable data solutions using ETL tools (e.g., Informatica IDMC/CDI, PowerCenter, or equivalent platforms) across diverse, high-volume data environments
* Lead solution design for large-scale data migration and integration projects, including inventory analysis, impact assessments, and creation of detailed data flow diagrams
* Develop and optimize ETL pipelines to ensure high performance, data integrity, and operational efficiency in both on-premises and hybrid environments
* Drive the reengineering of legacy data warehouses and ETL workflows (e.g., Oracle, custom platforms) into modern, maintainable architectures
* Collaborate with cross-functional teams to translate consumer banking requirements, such as General Ledger (GL) processes, into practical, scalable technical solutions
* Create and maintain comprehensive technical documentation, including solution designs, mapping specifications, and workflow designs
* Implement robust data validation, governance, and quality frameworks using tools like Informatica IDQ or similar
* Apply CI/CD practices using tools such as Bitbucket, GitHub Actions, or Jenkins to automate and streamline deployments
* Perform performance tuning of ETL jobs, SQL queries, and batch processes to optimize resource utilization across systems
* Provide mentorship and technical leadership, delivering knowledge-sharing sessions on best practices for integrating and modernizing complex data systems, with a focus on consumer banking use cases