Scribd
Upload
10 views2 pages

ETL Developer Position at Banking Institution

This job posting is for an ETL Developer position at a major banking institution with over 130 years of history and operations across 19 states and 84 countries. The ETL Developer will be responsible for developing Extract, Transformation, and Load processes to move data from multiple sources like Oracle, SQL Server, and sequential files into the company's Teradata data warehouse using Informatica. Key responsibilities include developing transformations in Informatica Designer, creating mappings and integrations between data sources and targets, performing ETL process design and programming for Teradata, and evaluating data quality. A Bachelor's degree in Computer Science or related field and 5+ years of experience with Informatica Toolset are required.

Uploaded by

api-26177831
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
10 views2 pages

ETL Developer Position at Banking Institution

This job posting is for an ETL Developer position at a major banking institution with over 130 years of history and operations across 19 states and 84 countries. The ETL Developer will be responsible for developing Extract, Transformation, and Load processes to move data from multiple sources like Oracle, SQL Server, and sequential files into the company's Teradata data warehouse using Informatica. Key responsibilities include developing transformations in Informatica Designer, creating mappings and integrations between data sources and targets, performing ETL process design and programming for Teradata, and evaluating data quality. A Bachelor's degree in Computer Science or related field and 5+ years of experience with Informatica Toolset are required.

Uploaded by

api-26177831
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd

ETL Developer Full Time Regular

Concord, CA

ETL DEVELOPER

Our client is a major banking institution whose history spans over 130 years, and whose
geographical reach extends over 19 states, as well as over 84 countries through our
affiliation with BNP Paribas, one of the world’s six strongest banks according to
Standard & Poor’s. From their earliest days as a community bank, their focus on
relationships, exceptional customer service and being a good corporate neighbor has
never wavered. Today, as one of the leading regional financial services companies in the
nation, their team members are dedicated to being their customers’ trusted financial
partners – whether they’re opening a first account, purchasing a home, running a small
business, or leading a large corporation. When customers join this Bank, they will be a
part of an organization that has learned how to grow and adapt in an ever-changing
environment. And most of all, they will become part of a company that recognizes that
the Bank’s success is rooted in their relationship banking model and in the satisfaction of
their customers. That’s why this Bank was ranked the highest in customer satisfaction
among retail banks in the West.

Purpose Statement

The ETL Developer will be responsible for developing Extract, Transformation and Load
(ETL) processes for this Bank’s enterprise data warehouse using Teradata database for an
assigned client group.

Essential Functions

1. Develops transformations like Lookup, Joiner, Rank and Source Qualifier


Transformations in the Informatica designer.
2. Creates transformations and mappings using Informatica Powercenter to move data
from multiple sources into targets.
3. Integrates various data sources like Oracle, SQL server, VSAM and sequential files
into staging area.
4. Performs the analysis, design, and programming of ETL processes for Teradata.
5. Evaluates data using the Informatica Data Quality (IDQ) toolkit. Applies data analysis,
data cleansing, data matching, exception handling, and reporting and monitoring
capabilities of IDQ
6. Creates sources to target mappings, edit rules and validation, transformations, and
business rules.

Education:
• Bachelor’s Degree in Computer Science or related field require

Required Experience:

• 5+ years experience working with the Informatica Toolset - ETL Development

Administrative/Technical Skills/ Other Information


• Good knowledge of analytical and logical conceptual level programming skills
• Good knowledge of Erwin model generation tools (logical and physical); Teradata and
the Teradata Financial Services Logical Data Model

You might also like