Have Copilot read job descriptions and extract out key info you want to know. Click "Analyze All" to try it out. Click on the Copilot's gear icon to customize the prompt.

I

ETL Developer [Zions]

ipjdnw7f5napvetweqr2ziz9mno8hm0423sbqrczl5q6rasimprbblk5rouuuujo · 30+ days ago

Saltlake City, UT, US

Negotiable

Full-time

Continue

By pressing the button above, you agree to our Terms and Privacy Policy, and agree to receive email job alerts. You can unsubscribe anytime.

Job Description :

Requires a Bachelor's degree in Computer Science, Information Systems or a related field and 7+ years experience with analyzing, designing and developing of ETL systems, data warehouse applications and systems, relational databases; i.e. DB2 or Oracle, SQL, database design, ETL languages.
Familiar with Unix/AIX, ANSI SQL, PL/SQL, DB2 SQL and Shell Scripting.
Experience in the banking/finance industry a plus.
A combination of education and experience may meet requirements.
Extensive knowledge of data warehouse applications and systems, Logical and Physical Data Modeling, Extensive knowledge of relational databases (DB2 or Oracle) SQL, database design, ETL languages .
Familiar with Unix/AIX, ANSI SQL, PL/SQL, DB2 SQL and Shell Scripting.
Extensive knowledge of full life cycle of applications development and support including: analysis, design, development, testing, implementation and support.
Experience with Data mapping/conversion, loading activities, interface programs.
Strong problem resolution and communication skills (oral and written).
Ability to work independently and exercise independent judgment, effectively prioritize, and execute tasks while under pressure.
Ability to identify and solve problems.
Strong attention to detail.
Strong organizational and customer service skills.
Must be able to manage resources, timelines, deliverables and expectations for related projects.
Must be comfortable and good at interacting and communicating with all levels inside and outside of the IT department.

Zions Bancorporation is currently seeking a contractor with great experience as an ETL Developer. The Contract-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 Contract-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.

Depending on one's performance, ability, and career goals, there will be ample opportunities to expand one's skill sets beyond ETL development and into the various aspects of the IBM InfoSphere Information Server Suite, such as QualityStage, Information Analyzer, Change Data Delivery, Balance Optimizer, and Master Data Management.

Job Responsibilities:
•Participate in the development and support of an enterprise wide data transformation and movement architecture and platform.
•Design, 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.

Qualifications
•Requires a Bachelor's degree in Computer Science, Information Systems or a related field and 4+ years experience with analyzing, designing and developing of ETL systems, data warehouse applications and systems, relational databases; i.e. DB2 or Oracle, SQL, database design, ETL languages.
•Familiar with Unix/AIX, ANSI SQL, PL/SQL, DB2 SQL and Shell Scripting.
•Experience in the banking/finance industry a plus.
•A combination of education and experience may meet requirements.
•Extensive knowledge of data warehouse applications and systems, Logical and Physical Data Modeling, Extensive knowledge of relational databases (DB2 or Oracle) SQL, database design, ETL languages .
•Familiar with Unix/AIX, ANSI SQL, PL/SQL, DB2 SQL and Shell Scripting.
•Extensive knowledge of full life cycle of applications development and support including: analysis, design, development, testing, implementation and support.
•Experience with Data mapping/conversion, loading activities, interface programs.
•Strong problem resolution and communication skills (oral and written).
•Ability to work independently and exercise independent judgment, effectively prioritize, and execute tasks while under pressure.
•Ability to identify and solve problems.
•Strong attention to detail.
•Strong organizational and customer service skills.
•Must be able to manage resources, timelines, deliverables and expectations for related projects.
•Must be comfortable

•

Last updated on Feb 6, 2018

About the company

I

ipjdnw7f5napvetweqr2ziz9mno8hm0423sbqrczl5q6rasimprbblk5rouuuujo

More jobs at ipjdnw7f5napvetweqr2ziz9mno8hm0423sbqrczl5q6rasimprbblk5rouuuujo

Analyzing

Senior Data Engineer

Stamford, Connecticut

·

30+ days ago

Senior .Net Developer : Frontier Communication

Dallas, Texas

·

30+ days ago

Sr. Salesforce Developer

Atlanta, Georgia

·

30+ days ago

Full Stack Developer

Hanover, New Jersey

·

30+ days ago

Technical Writer/Business Analyst

New Hartford, New York

·

30+ days ago

More jobs like this

Analyzing

Test

G

Grapevine · Influencer marketing platform for YouTube

Boston, Massachusetts

·

30+ days ago

Backend Software Engineer (Bridge) US, Remote

G

getbridge

Remote

·

30+ days ago

C# Unity Developer (Game Development)

A

arcanys

Remote

·

30+ days ago

test

S

shib

Portland, Oregon

·

30+ days ago

Oracle Financial - Application Developer Consultant Sr

R

rsjdnwc9jel4i3xyjsm3m8vnhrmayk037bphn44zg3i1bl3dcjtqhqlclsisinpr

Glen Allen, Virginia

·

30+ days ago

Informatica Developer

B

b8jdnwfetm91aeh4xxktytk2xff310011dbi7c94iwf3w4g8qka7cjkc4daepyd7

Washington, District of Columbia

·

30+ days ago

GA DHS Sr. Java Developer & Tech Lead

B

b6jdnwcpcemgg8el3r9winlpunj8hc038b1vkhowrzxn9gitznreodi38t7rirkp

Atlanta, Georgia

·

30+ days ago

Infrastructure - Devops Engineer

Blackbird AI · AI driven cybersecurity solutions

Remote

·

30+ days ago

iOS Developer

AnchorFree · Online privacy and security

Mountain View, California

·

30+ days ago

Java Developer with Kafka & Microservices

C

crjdnwsnowo2i4nz45b1teboszrxlg0351vr73gpqw7yanury9u287prckhdnkww

Columbus, Ohio

·

30+ days ago

For job seekers

Job searchSearch millions of jobs

LaunchpadNew

Resume to business

Cover Letter StudioGenerate a cover letter

Add to ChatGPTFind and discuss jobs

For employers and recruiters

Resume ScreenerOrganize and rank candidates

Talent PipelinePre-order

Source top talent

Promote a jobReach more candidates

For everyone

Referral programEarn 30% commission

Get mobile appBrowse anywhere

Jobs API

Become a partner

Developed by Blake and Linh in the US and Vietnam.

We're interested in hearing what you like and don't like! Live chat with our founder or join our Discord

Changelog

🚀 LaunchpadNov 27

Create a site and sell services based on your CV.

🔥 Job search dashboardNov 13

Revamped job search UI with a sortable grid, live filtering, bookmarks, and application tracking.

🫡 Cover letter instructionsSep 27

New Studio settings give you control over AI output.

✨ Cover Letter StudioAug 9

Automatically generate cover letters for any job.

🎯 Suggested filtersAug 6

Copilot suggests additional filters above the results.

⚡️ Quick applicationsAug 2

Apply to jobs using info from your CV. Initial coverage of ~200k jobs in Spain, Germany, Austria, Switzerland, France, and the Netherlands.

🧠 Job AnalysisJul 12

Have Copilot read job descriptions and extract out key info you want to know. Click "Analyze All" to try it out. Click on the Copilot's gear icon to customize the prompt.