Hyderabad,

About Wells Fargo


Wells Fargo & Company (NYSE: WFC) is a leading global financial services company headquartered in San Francisco (United States). Wells Fargo has offices in over 20 countries and territories. Our business outside of the U.S. mostly focuses on providing banking services for large corporate, government and financial institution clients. We have worldwide expertise and services to help our customers improve earnings, manage risk, and develop opportunities in the global marketplace. Our global reach offers many opportunities for you to develop a career with Wells Fargo. 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.

Market Job Description


About Wells Fargo India


Wells Fargo India enables global talent capabilities for Wells Fargo Bank NA., by supporting business lines and staff functions across Technology, Operations, Risk, Audit, Process Excellence, Automation and Product, Analytics and Modeling. We are operating in Hyderabad, Bengaluru and Chennai locations.

Department Overview


The consumer Lending Technology group consists of Home lending, Auto, Cards and Platform support for various applications across retail/mortgage lending businesses. From achieving sustainable homeownership, managing credit, purchasing a car to financing college, Wells Fargo Consumer Lending cares about our customers. Today, our diversified team provides home lending, auto loans, credit cards, merchant services and student loans to more than 30 million customers


About the Role


This role will require technical expertise in Informatica, PowerCenter, Data Quality , Power Exchange (Salesforce, Oracle). This position will be required to have deep knowledge in Data, SQL and banking domain [ preferred ]. Work with business stakeholders to support strategic business initiative by bringing value based and practical technology innovations and solutions.Collaborate with internal business and technical partner teams to improve effectiveness of delivery .

Responsibilities:


Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
Creates ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter 10.x and prepare corresponding documentation.
Designs and builds integrations supporting standard data warehousing objects (type-2 dimensions, aggregations, star schema, etc.).
Performs source system analysis as required.
Works with DBAs and Data Architects to plan and implement appropriate data partitioning strategy in Enterprise Data Warehouse.
Implements versioning of the ETL repository and supporting code as necessary.
Develops stored procedures, database triggers and SQL queries where needed.
Implements best practices and tunes SQL code for optimization.
Works with XML's, XML parser, Java and HTTP transformation within Informatica.
Build efficient and high performing solutions to meet the business requirements
Define and Design solutions to meet the business and strategic requirements
Provides technical direction to the team and collaborate with team to design, develop, test and refine deliverables that meet the objectives.Collaborate with Product Owners, System Architects, Analysts and any other stakeholders as needed

Essential Qualifications


Core skills – minimum 8+ years Informatica, PowerCenter, Data Quality, Power Exchange (Salesforce, Oracle) & knowledge on Oracle and SQL Server databases.
Experience in creating mappings and workflows, good exposure to Informatica code deployments.
Understanding of building data pipeline for Near-Real Time and Batch Data
Good understanding of Data, Data Governance, SQL.
Must have strong SQL experience with a relational database concepts.
The candidate should also be familiar with good database design patterns and concepts [referential integrity, primary keys, foreign keys, many to many relationships, indexes, normal forms etc...]
Hands on experience in delivering high value projects in Agile (SCRUM) methodology .
Good business communication skills, problem solving & critical thinking.

Desired Qualifications


Knowledge of integration with Sales Force platform is desirable
Secondary skill in Java / Sales Force / MuleSoft Development is desirable
Strong Data warehousing concepts and good analytic skills
Working experience in Banking Domain
Experience of working across one or more geographic territories or regions
Experience in a business intelligence role, including data warehousing and business intelligence tools
Good understanding of global trends and practices in Technology RWF

Market Skills and Certifications



Essential Qualifications

Bachelor's Degree in Technology (or) Graduation/Post Graduation in Computer science.
Core skills – minimum 8+ years Informatica, PowerCenter, Data Quality, Power Exchange (Salesforce, Oracle) & knowledge on Oracle and SQL Server databases.
Experience in creating mappings and workflows, good exposure to Informatica code deployments.
Understanding of building data pipeline for Near-Real Time and Batch Data
Good understanding of Data, Data Governance, SQL.
Must have strong SQL experience with a relational database concepts.
The candidate should also be familiar with good database design patterns and concepts [referential integrity, primary keys, foreign keys, many to many relationships, indexes, normal forms etc...]
Hands on experience in delivering high value projects in Agile (SCRUM) methodology .
Good business communication skills, problem solving & critical thinking.


Desired Qualifications

Knowledge of integration with Sales Force platform is desirable
Secondary skill in Java / Sales Force / MuleSoft Development is desirable
Strong Data warehousing concepts and good analytic skills
Working experience in Banking Domain
Experience of working across one or more geographic territories or regions
Experience in a business intelligence role, including data warehousing and business intelligence tools
Good understanding of global trends and practices in Technology



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. 66417

Hyderabad,

At Wells Fargo, we’ve been proudly supporting military veterans and their families for more than 170 years.

We value the leadership, discipline, and skills you’ve gained through your service to our country and recognize the contributions our veteran team members bring to the table. We’re committed to hiring and retaining military veterans, veterans with disabilities, National Guard, Reservists, and Military Spouses.

As a Wells Fargo employee, you’ll find a work culture that is team-oriented, collaborative, structured, and challenging. We support veterans transitioning from military service with a variety of job options, confidential resources, educational information, and career guidance. You may choose to join our Veteran’s Connection Employee Resource Group, a group of thousands who share an interest in veterans’ matters, and that promotes greater awareness and job development within the veteran community. To learn more about opportunities at our company, please visit wellsfargojobs.com/military. Let’s talk about turning your military experience into a great civilian career.

Similar jobs