The Technology and Operations Division of Zions Bancorporation has team members in Los Angeles, Las Vegas, Phoenix, Salt Lake City, Denver, Dallas, and Houston, and is dedicated to creating success for the banks that make up Zions Bancorporation. The 1500-member division builds and maintains the world-class infrastructure of the entire corporation, and also contributes to the company's bottom line by providing exceptional customer service.

Zions Bancorporation is one of the nation's premier financial services companies, consisting of a collection of great banks in select high growth markets. Zions operates its banking businesses under local management teams and community identities through over 500 offices and 600 ATMs in 10 Western states: Arizona, California, Colorado, Idaho, Nevada, New Mexico, Oregon, Texas, Utah and Washington. Zions Bancorporation is a leader in small business lending, and agricultural and public finance. The Corporation also operates several new technology ventures such as Contango and NetDeposit. Zions Bancorporation's common stock is traded on NASDAQ under the symbol ZION, and the company is a member of the S&P 500 Index and the NASDAQ Financial 100 Index.

Programmer Analyst (ETL Developer)

 
 
ETL Developer                        
           
 
 
Job Description:
The ETL Developer is responsible for the definition, development, and testing of the processes and programs necessary to extract data from the client's operational databases/files and deliver it to the desired target environments. Duties include extraction, transformation, cleansing and loading of data into a data warehouse, data marts, etc. The ETL Developer is experienced with all of the techniques used to manage and maintain a data warehouse environment. The ETL Developer defines the program specifications for the data migration processes, as well as the necessary test plans used to ensure successful execution. The ETL Developer is also responsible for managing the metadata associated with the ETL processes used to populate the data warehouse. Knowledge of data warehousing ETL procedures such as changing dimension strategies and use of surrogate values is a necessity.


Job Responsibilities:
-          Participate in the development and support of an enterprise wide data transformation and movement architecture and platform.
-          Design/review, develop and test ETL applications consistent with application architecture guidelines
-          Design error-processing routines
-          Create/manage batch processes
-          Access disparate data sources (databases, hardware devices, VSAM and flat files) and apply internal and external business rules, policies and data quality measures
-          Insure the data is safely and securely transferred to target destinations
-          Gather mapping and reporting requirements and coordinate all data movement activities
-          Analyze business requirements as they relate to the ETL process, research, evaluate and recommend alternative solutions
-          Transform business requirements into technical requirement documents
-          Analyze, develop, install, test, upgrade, maintain and support complex data/process models, and processes in an ETL environment
-          Provide project estimates, plans, and schedules
-          Work productively in a team environment
-          Communicate effectively with business and IT staff across functional departments
-          Work with management and staff to establish best practice standards for ETL functions.
-          Lead development of new methodologies for supporting data transformations and processing in a corporate-wide ETL solution.
-          Provide after business hours support for production ETL systems.
-          Maintain an in-depth knowledge of current and emerging technologies and standards and provide technical direction to management and users.
-          Provide technical direction to other team members including contractors and employees
-          Performs other duties, as assigned.
 


Job Requirements:
Required:
-          Batchelor's degree in Computer Science or equivalent degree.
-          8+ years of total IT Experience
-          5+ years experience with the IBM DataStage ETL tool in a data warehouse environment is a must.
-          Experience with Unix scripting, SQL, DMExpress, Fileport also strongly preferred.
-          Knowledge of Extraction, Transformation, and Loading (ETL) disciplines.
-          Knowledge of database loading methods.
-          Knowledge of data warehousing methodologies.
-          Knowledge of Greenplum database platforms.
-          Knowledge of mainframe platforms, files and utilities.
-          Knowledge of  Sun UNIX systems and tools.
-          Knowledge of all phases of the system development life cycle.
-          Strong problem resolution skills.
-          Strong testing and debugging skills.
-          Strong communication and interpersonal skills
-          Demonstrated ability to take ownership & responsibility for development and maintenance projects.
-          Sound understanding of banking/financial industry processes is a plus
 

We have many opportunities both at the Bancorporation and at our affiliates. Wherever you find your fit in the Zions family, we look forward to working with you!