About Wells Fargo
Wells Fargo & Company (NYSE : WFC) is a leading global financial services company with $2.0 trillion in assets and offices in over 37 countries.
Founded in 1852 and headquartered in San Francisco, Wells Fargo provides asset management, capital raising and advisory, financing, foreign exchange, payments, risk management, and trade finance services to support customers who conduct business in the global economy.
At Wells Fargo, we want to satisfy our customers' financial needs and help them succeed financially. We also value the viewpoints of our team members and encourage them to be their best.
Join our diverse and inclusive team where you will feel valued and inspired to contribute your unique skills and experience.
We are looking for talented people who will put our customers at the center of everything we do. Help us build a better Wells Fargo.
It all begins with outstanding talent. It all begins with you. Learn more at our International Careers website .
Market Job Description
Responsibilities : Lead technological
business analysis activities where Agile or Waterfall development methodologies are followed.
May act as the product owner or product owner proxy in an agile team.
Act as a liaison between business partners and technical teams by conducting, planning, and directing the analysis of complex business problems and data to be solved with system solutions.
Document data migration requirements, including source system analysis and source to target
Analyzes & acquires data from primary and secondary data sources creating mapping specifications for use by ETL development resources.
Work with business partners as well as system partners to identify, define and clarify requirements to create user stories, understand the application requirements and how they correspond with the business priorities in order to drive the backlog refinement.
Drives and participates in design, development and implementation of complex application, owning your solution through implementation.
Develop design document for data mapping and data transformation processes.
Develop metadata for structures in the data warehouse.
Identify and enforce data standards to ensure consistent and maintainable structures in the data warehouse. Perform source system analysis and data profiling.
eview and test ETL processes consistent with application architecture and security guidelines using Ab Initio
DataStage ETL tool to support Business Analytics
Analyze business requirements as they relate to the ETL or EDQ processes
Provide technical assistance to team and evaluate code for quality and performance
Monitor current design, architecture, daily loads; analyze performance and recommend changes as needed
Deliver data analysis reports that clearly articulate data accuracy and completeness results.
Prior experience of working on data warehouse / ETL project and workflow design
Working knowledge in SQL (DDL and DML) and writing test scripts for data validation, backend testing and data analysis.
Experience sourcing data from ERP, SQL, Oracle, MySQL, etc. and from flat files (JSON, CSV, etc.).
Familiar with technologies : Informatics ETL, IBM Data Stage, Ab Initio, Cognos, Oracle, SQL
Bachelor's degree in Computer Science, Engineering, or related discipline.
relevant work experience in a Techno functional role on at least 5 Years with over all
Proficient in using collaboration tools Confluence, JIRA etc.
Excellent communication skills, both written and verbal, and strong analytical and problem solving skills
Proven experience with Data Stage / Ab Initio
including admin and development .
Proven ability to debug, maintain, optimize, support, and test all ETL designs and code
Deep understanding of ETL methodologies, Business Intelligence and Data Warehousing principles, approaches, technologies, and architectures including the concepts, designs and usage of data warehouses and data marts
knowledge in Data Warehouse development, perform root cause analysis, monitor jobs for performance issues and troubleshoot
Demonstrated experience in ETL design and options to improve load and extract performance
Experience creating data warehouse documentation including, but not limited to requirements, technical specifications, and source to target mappings
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amount of information with attention to detail and accuracy
Prior experience in Linux scripting; Understand and aid in database performance tuning efforts, utilize Oracle analytic functions
Experience in Data modelling and design, Scheduling Tools, BI Reporting and Visualization tools
Experience in Talend is an advantage
We Value Diversity
At Wells Fargo, we believe in diversity and inclusion in the workplace; accordingly, we welcome applications for employment from all qualified candidates, regardless of race, color, gender, national or ethnic origin, age, disability, religion, sexual orientation, gender identity or any other status protected by applicable law.
We comply with all applicable laws in every jurisdiction in which we operate.