Job Description
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 Enterprise Global Services
:Enterprise Global Services (EGS) enables global talent capabilities for Wells Fargo Bank NA., by supporting over half of Wells Fargo's business lines and staff functions across Technology, Business Services, Risk Services and Knowledge Services. EGS operates in Hyderabad, Bengaluru and Chennai in India and in Manila, Philippines. Learn more about EGS at our
International Careers website.
Department Overview:Wholesale Technologies supports various applications for the Wholesale line of businesses. The teams are spread across various locations including EGS. Team member will be working from any of the EGS India work locations. The technology team has various applications based on Java Stack, Microsoft, DWH, Etc.,
About the Role
Middle Marketing group is seeking a Senior Software engineer. Client onboarding and underwriting platforms are critical processes for Wells Fargo in onboarding new customers / new products for customers.
Candidate should perform development, testing, maintenance and support of Informatica based enterprise solution. Develop Informatica Mappings, Informatica workflow run capabilities and experience with Informatica design and implementation. Tuning SQL Query and Batch Process Performance. Estimates projects, provide knowledge transfer to other developers and will work closely with business analyst/onsite partners to help translate user requirements into ETL solutions. Candidate should provide post-production support service along with maintenance and development
Essential Qualifications:
• 11+ years of hands-on strong integration experience in Legacy / on-Prem to cloud services integration
• Complete understanding of relational database concepts - Create data mappings, and implements extract/transform/load processes flows for huge volume of structured data in DW environment.
• Must have Strong knowledge on Data Warehousing (DWH) concepts (Schema Structures, Archive, Data Migration and Data Quality)
• Technical Experience in Informatica intelligent Cloud services, Informatica Power Center Designer, Workflow manager, Workflow monitor, Repository manager, Integration service, Informatica Data Quality (IDQ), MDM
• Must have experience performing ETL performance optimizations and improvements.
• Must have strong Oracle SQL and PLSQL knowledge (Performance Tuning, Stored procedures, data modeling),
3+ years of experience extracting and loading information into Salesforce/nCino using ETL tools such as Apex DataLoader, PowerCenter or IICS
•
Desired
Data / Platform Integration - Oracle RDBMS and integrations with Salesforce Java/J2EE, Apache Camel and Spring, highly scalable and performance intensive low latency transactions using various open stack libraries
• Good to have hands-on experience in Linux/UNIX shell scripting for batch and adhoc jobs, and exposure to Autosys Job Scheduling tool.
• Experience of noSQL database
Non-Technical:• Good problem solving and analytical skills
• Significantly contribute to design and analysis sessions to ensure sound team decision-making
• Actively involved in system and user acceptance testing activities, including issue resolution.
• Complete technical documentation to ensure system is fully documented.
• Excellent verbal and written communication skills.
• Share best practices and lessons learned from past implementation efforts.
• The flexibility to work outside of normal working hours to meet deadlines.
Good to Have Skills:• Experience in Wholesale Banking LOB and its Products.
• Experience in building ETL solutions on Cloud/Open Source tools.
• Experience developing ETL solution to load unstructured data.
• Integration experience with any DMS with OCR / Automation)
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.