ESSENTIAL DUTIES AND RESPONSIBILITIES
Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.
· Collaborate with peer groups in Technology and LOBs to identify, document and communicate business needs and provide technology solutions.
· Work closely with business stakeholders to understand business processes and strategies.
· Establish project and work requests requirements using document, business process and workflow analysis. Ensure all stakeholders are involved in requirements gathering activities.
· Facilitate requirements elicitation sessions and walkthroughs with appropriate stakeholders to plan, elicit, capture, analyze and validate business, functional and technical requirements
· Work closely with Fraud and Enterprise Architects to perform current state analysis of existing business systems, applications and functions.
· Understand the long-term business objectives and suggest strategies to meet those objectives and introduce technical innovations, as needed.
· Develop and maintain effective working relationships with business process owners and other stakeholders to support documenting the acceptance criteria and a plan to facilitate user acceptance testing of a solution that meets the business requirements.
· Prioritizing and requesting data capture in enterprise repositories (Data Lake, Snowflake) for analytic support, card fraud team needs.
· Support Card Fraud Data Delivery Team with new initiatives, work on design and solutions (interim and long-term) to enable business partners to perform better analytics to fight fraud
· Work with various vendors that supply data for Card Fraud needs, and support delivery of new initiatives and projects
· Researching data – availability, sourcing, quality, relationships, lineage
· Work with other Data Delivery teams to source data within the Enterprise.
· Partners with engineers, data scientists, and the data office leadership to define and refine data architecture and technology choices.
· Analyze existing Informatica and Ab Initio ETL codebases, document transformation logic, and convert them into scalable Talend ETL jobs.
· Support migration and modernization efforts from legacy ETL tools (Informatica/Ab Initio) to Talend and Snowflake DB.
· Design and implement ETL/ELT pipelines to load and transform data into Snowflake, aligning with Medallion architecture layers (Bronze, Silver, Gold). · Optimize data pipelines for performance, scalability, and cost-efficiency within Snowflake.
· Collaborate with data engineering teams to ensure data quality, governance, lineage, and reconciliation during ETL migration and transformation processes.