Browse
Employers / Recruiters
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

See more

More jobs at ipjdnw7f5napvetweqr2ziz9mno8hm0423sbqrczl5q6rasimprbblk5rouuuujo

Analyzing

Stamford, Connecticut

 · 

30+ days ago

Dallas, Texas

 · 

30+ days ago

Atlanta, Georgia

 · 

30+ days ago

Hanover, New Jersey

 · 

30+ days ago

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

Remote

 · 

30+ days ago

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

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 resume.
🔥 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 resume. 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.
© 2024 RemoteAmbitionAffiliate · Privacy · Terms · Sitemap · Status