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 (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 .
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:
Work very closely with business analysts, development teams and project managers for requirements and business rules.
Design and implement highly distributed, scalable and performant ETL processes - Staging, Data Enrichments and Strong data delivery techniques using Ab Intio as ETL environment
Hands on ETL development (data transformations and data movement) using Ab Initio, Ab Initio Express IT, DQE (Data Quality) and Metadata Portal as a key tools.
Effectively work in an ETL framework driven environment.
Identify key business processes and deliver subject specific ETL processes to load physical data models
Perform data research, analysis, conceptual and logical data modeling to solve data issues, validate and document business data artifacts.
In-depth understanding of entity relationship design, data normalization & relational modeling techniques
effectively communicate data design to other members of the team to ensure proper implementation and utilization of the data structures.
Support ongoing ETL efforts for Development, QA and Production environments
Market Skills and Certifications
7+ years of application development and implementation experience.
5+ years of Ab Initio experience.
7+ years in database design and programming experience: SQL SERVER or any other Database Management Systems with thorough understanding of design patterns and their applications
1+ year of capital markets experience is a PLUS.
Knowledge and understanding of relational database designing schema, stored procedures, and views for performance with large data sets
SQL, PL/SQL & performance tuning experience
Knowledge and understanding of project management methodologies: used in waterfall or Agile development projects
Bachelors in Computer Science, Engineering or any relevant field.
2+ years of AbInitio Express > IT
7+ years' of overall Database information architecture, design, development and implementation experience in Relational and Dimensional databases.
7+ years of designing and implementing highly distributed, scalable, and performant back-end database processes - Staging, Data Enrichments and Strong data delivery techniques.
7 + years of Strong Unix and Shell Scripting.
Translate business and data requirements into Logical data models in support of Enterprise Data Models, OLTP, Operational Data Structures and Analytical systems
Experience in business analysis techniques and data warehouse design techniques.
Experience deploying and supporting large, complex data warehouse/business intelligence solutions.
Reporting/BI experience using one of the tools - SSRS, Microstrategy or Tableau is desirable.
Big Data experience
Back to top