Apps Systems Engineer 5

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 ( 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 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 to enable strategic risk & regulatory, customer enablement, business automation technology, along with analytics and innovation solutions. 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
Enterprise Core 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 development lead with also strong individual contributor abilities in providing application design guidance and consultation, utilizing a thorough understanding of applicable technology (Oracle 11g, Abinitio, Unix, Informatica) and related tools and existing designs.

Job Responsibilities
As a Tech lead, Team member will perform hands-on requirement analysis, design, development, testing, maintenance and production support.
Team member will work closely with 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 process aspects to measure the delivery and optimize the team operation.
Team member would define coding standards and best practices for team members to follow.
Team member would also sphere head code review, documentation, deployments aspects. Team member guides team on doing continuous improvements.
Team member guides production support team to ensure production stability.

Market Skills and Certifications
Primary Skills:

•Minimum 8+ years of experience in software development, production support/implementation
•Expertise skills and experience on ETL/Data Warehouse development using AbIntitio, Oracle, Unix. Nice to have Informatica to Abinitio conversion experience.
•Should have hands on experience working with plans, psets, graph components, mfs/multiway processing, transform components, database components using Ab Initio
•Should be familiar working with job scheduling tools like Autosys
•Should have good Unix/Linux working experience; basic commands & perl/shell scripting skills
•Should have strong database knowledge preferably databases like Oracle/Exadata
•Familiarity with Ab Initio Express is a plus
•A good team lead who can lead, collaborate and work with multiple groups within the organization.
•Should possess strong communication, analytical and problem solving skills
•Must be self-disciplined who can handle his work with less oversight/direction.
•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.

Secondary Skills:
- Experience with enterprise system monitoring and high availabity architectures
- Exposure to AUTOSYS Job scheduler and Shell scripting.
- Exposure to Oracle PL/SQL
-Nice to have prior ETL tool experience using Informatica
-Nice to have OFSAA/FSDF data model knowledge.

Back to top