25 days old

Apps Systems Engineer 4 - Datastage Developer

Flagstaff, AZ 86004
  • Job Code
Job Description

We are looking for a Datastage developer to join the team supporting the Wholesale Loan Services Datamart reporting platform.To be successful in this role, you will need an extensive background in IBM Datastage and Oracle Database, building complex data systems, and a good understanding of commercial and real estate loan domain. You will be working closely with business and technology partners to build and support the platform.

This role will involve

  • Working as a developer providing technical guidance and consultation to Datastage and Cognos BI developers and business team for Wholesale Loan Services Datamart.
  • Works closely with business, QA, Datastage and Cognos development to analyze requirements, performs complex data modelling, design code and develop technical solution.
  • Performs complex ETL coding using IBM Datastage v9, 10 or 11, Oracle database v12, batch scheduling tools preferably Autosys, UNIX shell and Windows batch scripting.
  • Performs builds, test and deploy ETL jobs, stored procedures and BI reports.
  • Analyze production issues with Cognos and Datastage development, business and interfacing application teams, recommend solution and fix the issues.
  • Utilizes advanced technologies and methods to integrate data systems and other existing platforms such as SharePoint and websites.
  • Develops new documentation and technical procedures.
  • Provides guidance and direction to less experienced staff in design, development and resolution of highly complex technical problems.
  • Assures quality, security and compliance requirements are met for supported area and oversees creation of or updates to and testing of the business continuation plan. Ability to proactively recommend system efficiencies, processes and designs.
  • Ability to research and identify root cause of complex production issues; Support production processes
  • Prepare detailed specifications and ETL design documentation.
  • Ability to effectively market and communicate concepts and solutions

In addition, will have production support responsibilities of the data processing applications. Collaborate with Enterprise Availability Office (EACO), Wholesale Service Level Management, System Admins, Middleware Support, DBAs, Developers Business Intelligence Competency Center, Datastage Administration and other stakeholders relevant to addressing production issues.

Required Qualifications

  • 4+ years of performance tuning experience
  • 5+ years of data warehouse experience
  • 4+ years of Perl or Shell experience
  • 5+ years of DataStage experience
  • 4+ years of application production support experience
  • 4+ years of stored procedures development experience
  • 3 + years of experience gathering business requirements from various sources including end-users and stakeholders
  • 5+ years of experience with databases such as Oracle, DB2, SQL server, or Teradata
  • 5+ years of application development and implementation experience

Desired Qualifications

  • A BS/BA degree or higher in information technology
  • Ability to work effectively in virtual environment where key team members and partners are in various time zones and locations
  • Knowledge and understanding of business intelligence development and reporting
  • Knowledge and understanding of technology support: System including business requirement design or review, release management support, test script development and execution, and system issue resolution
  • 1+ year of Cognos experience
  • Experience successfully escalating complex issues and tracking follow-through to completion
  • Excellent verbal, written, and interpersonal communication skills

Job Expectations

  • Willingness to work on-site at stated location on the job opening
  • Flexibility to work in a 24/7 environment


All offers for employment with Wells Fargo are contingent upon the candidate having successfully completed a criminal background check. Wells Fargo will consider qualified candidates with criminal histories in a manner consistent with the requirements of applicable local, state and Federal law, including Section 19 of the Federal Deposit Insurance Act.

Relevant military experience is considered for veterans and transitioning service men and women.

Wells Fargo is an Affirmative Action and Equal Opportunity Employer, Minority/Female/Disabled/Veteran/Gender Identity/Sexual Orientation.



  • Information Technology
  • Business
  • Retail / Wholesale
  • Real Estate
  • Transportation / Warehouse
  • Engineering
  • Administrative / Clerical

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Apps Systems Engineer 4 - Datastage Developer

Wells Fargo
Flagstaff, AZ 86004

Share this job

Apps Systems Engineer 4 - Datastage Developer

Wells Fargo
Flagstaff, AZ

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast