5+ years of experience
Concerned about your lack of experience? Learn More...
Employment Type:
Full time
Job Category:
Software Development
Informatica Developer
(This job is no longer available)
Wells Fargo | Chandler, AZ
Grad Date

Not sure what types of jobs you are interested in?

Explore Jobs
Based on Your Education

Follow This Company

Job Description

Job Title:

Informatica Developer

Job ID Number:


Schedule Type:


Work Hours:





Undergraduate degree in technology, MIS, business or related field or equivalent experience
Ability to work independently or collaboratively
Ability to multi-task in a fast-paced environment
Strong and effective interpersonal communication (written and oral), organizational, and customer service skills.
Wholesale Banking experience
SFDC integration experience with other internal and third party applications
ETL and batch processing experience
Experience working with offshore teams/resources
Experience with Production support and processes
Ability to interact effectively with a variety of contacts/relationships, including executive/senior-level managers.
Knowledge of financial services products and business processes
Experience with cross LOB data distribution efforts
Databases : Oracle, SQLServer
SDLC lifecycle
Operational Data Store concepts
8+ year s technical background with directly related to Informatica connecting to multiple database environments (Oracle and SQL Server etc.)
5+ years of software development experience encompassing application/database s, including development of large scale enterprise solutions.
5+ years of development experience on Informatica platform on UNIX/LINUX, including developing near real-time integrations on Web Services Hub. Development of Web services and XML.
5+ years experience with SQL and/or Oracle/SLQ Server development, ETL and application integration.
Experience in creating reusable transformations and complex mappings, partitioning
Experience in versioning and managing/deployment groups in Informatica environment
Experience in writing complex SQL queries and PLSQL Functions/Procedures
Experience on tuning SQL and long running process mostly in Oracle
Skilled in authoring technical documentation and performing reviews, design, data manipulation, and creative problem solving
Excellent communication skills, both written and oral
Working knowledge on Informatica 9.1 , Analyst Tool and Power Center
Experience in oracle 10g/11g
Proficiency in writing, tuning oracle and sql-server queries
Have worked on unix/linux environment, Unix/Linux shell scripting, and on autosys scheduling tool
Experience in tuning of ETL processes and optimization of SQL queries
Working experience with XML, Web Services and HTTP transformations.
Experience with Web Services Hub
SDFC integration experience desirable
7+ years application development and implementation experience. LIIFTS supports various wholesale lines of businesses, including Specialized Lending Servicing and Trust (SLST). There are several initiatives in SLST to build out Salesforce CRM based sales platforms for various LOBs within SLST. LIIFTS technology team is establishing a technology team to support SLST s Salesforce initiatives. Informatica platform plays a critical role in being the integration bridge between SLST Salesforce implementations and various Wells Fargo s applications. Informatica platform is leveraged for ETL/batch, near real-time integrations and real time integrations.

We are looking for senior Informatica developer to provide application design guidance and consultation, utilizing a thorough understanding of Informatica platform, Relational databases, Web Services and XML technologies with enterprise application integration experience.

Responsibilities include:
Analyzes highly complex business requirements, design, write technical specifications to design or redesign complex computer platforms and applications.
Implement an Informatica based solution for ELT/batch, near real time and Web services based real time application integrations (preferably Salesforce integrations), meeting stringent performance requirements.
Collaborate with other development teams and senior designers to develop architectural requirements to ensure new business requirements are met.
Assist and verify design of solution and production of all design phase deliverables.
Develop & unit test Informatica implementations for optimal performance.
Review physical Database objects including staging, materialized views, indexes provided by Data Modeler.
Provide production support to existing Informatica implementations
Coordinate and collaborate with extended team in EGS India for Informatica development needs

About Wells Fargo

Wells Fargo & Company is a financial holding company and a bank holding company. It is a diversified financial services company. It provides retail, commercial and corporate banking services through banking stores located in 23 states: Alaska, Arizona, California, Colorado, Idaho, Illinois, Indiana, Iowa, Michigan, Minnesota, Montana, Nebraska, Nevada, New Mexico, North Dakota, Ohio, Oregon, South Dakota, Texas, Utah, Washington, Wisconsin and Wyoming. It provides other financial services through subsidiaries engaged in various businesses, principally wholesale banking, mortgage banking, consumer finance, equipment leasing, agricultural finance, commercial finance, securities brokerage and investment banking, insurance agency and brokerage services, computer and data processing services, trust services, investment advisory services and venture capital investment. It operates in three segments: Community Banking, Wholesale Banking and Wells Fargo Financial. (Source: 10-K)