Senior Technology Specialist
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 About Wells Fargo
Wells Fargo & Company (NYSE: WFC) is a diversified, community-based financial services company with $2.0 trillion in assets. Founded in 1852 and headquartered in San Francisco, Wells Fargo provides banking, insurance, investments, mortgage, and consumer and commercial finance through more than 8,500 locations, 13,000 ATMs, the internet (wellsfargo.com) and mobile banking, and has offices in 42 countries and territories to support customers who conduct business in the global economy. With approximately 273,000 team members, Wells Fargo serves one in three households in the United States. Wells Fargo & Company was ranked No. 25 on Fortune's 2017 rankings of America's largest corporations. Wells Fargo's vision is to satisfy our customers' financial needs and help them succeed financially. News, insights and perspectives from Wells Fargo are also available at Wells Fargo Stories . 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
Enterprise Core Services (ECS) group is within the Enterprise Information Technology business and a critical component of the Enterprise CIO operating model aimed at providing common, consistent, and foundational software services and solutions to be used across technology at Wells Fargo. The group includes the strategic development and support of core information management services including data technology blue print, common data services, customer relationship management services and customer due diligence services to be leveraged across all technology teams in Wells Fargo. Additionally their Cloud enablement services is another strategic priority to re-engineer of a significant portion of Wells Fargo's large and complex application portfolio. About the Role
Wholesale Data Services was formed to improve Wholesale Banking's data environment. Our technology platform will acquire data from systems of record, cleanse and conform it before distributing it to downstream analytics data marts and operational data stores.
We are looking for ETL developer who has strong technical abilities in providing application design guidance and consultation, development, unit testing, utilizing a thorough understanding of applicable technology (Oracle 11g, Informatica v9.6, AUTOSYS, UNIX) and related tools and existing designs. Ab initio prior experience is nice to have but not mandatory.
As a developer Team member will perform hands-on requirement analysis, design, development, testing, maintenance and production support. Team member will work closely with other developers, leads and business analysts at onshore/offshore to help translate user requirements into ETL Solutions. The team member is responsible for his and teams technical deliverables. Team member adopts the existing process aspects to mature the delivery and optimize the team operation. Team member would adhere, define, coding standards and best practices for team members to follow. Team member would also be part of the code review, documentation, deployments aspects. Team member is expected to provide continuous improvements. Team member guides production support team to ensure production stability. Job Responsibilities
- End to End development and implementation experience of complex data warehouses using Informatica and Oracle, Unix.
- Well versed with Dimensional modelling aspects
Market Skills and Certifications
- Analyzes highly complex business requirements, designs and writes technical specifications to design or redesign complex computer platforms and applications.
- Work with all stakeholders to review Data Model, Data Flows, high level ETL design, source to target data mapping document and be the point of contact for any ETL related questions.
- Create and review development estimates and actively seek clarification and verification as appropriate
- Develop & unit test Informatica ETL processes for optimal performance.
- Implement an Informatica based ETL solution fulfilling stringent performance requirements.
- Develop system specifications, design and Implementation specifics to provide solutions for the business.
- Works on problems where analysis of situations or data requires evaluation of business problems.
- Understand BCP, quality assurance, information security and compliance requirements and analyze changes for risk to the environment. Essential Qualifications
- Having 6+ years' experience working with Informatica, Oracle, PL/SQL, SQL Queries, Unix.
- Exposure to AUTOSYS Job scheduler and Shell scripting.
-Nice to have OFSAA/FSDF data model knowledge. Desired Qualifications
Ab initio ETL experience is secondary.
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.