This job is no longer accepting applications. Start a new search to view available jobs.

ETL Consultant - PowerCenter & Teradata - 207877

Full Time

On-Site

São Paulo, State of São Paulo, Brazil

ETL Consultant – PowerCenter & Teradata

Location: São Paulo

Job Summary

The ETL Consultant will participate in the design, development, and implementation of ETL process/programs and scripts to acquire data from source systems to Teradata Tables, utilizing 3rd party ETL tools like PowerCenter and Teradata Utilities(TPT).

General Key Areas of Responsibility

Support in the development of ETL process, developing the following activities:
Data Modeling: design of logical and physical data models (logical design and physical design)
Elaboration of data mapping
Handling basic and advanced SQL.
Construction of scripts and queries in SQL Teradata and BTEQ (Basic Teradata Query).
Construction of scripts in Teradata platform loaders and data transport (Teradata Tools and Utilities).
Construction of PowerCenter ETL process including construction, testing, correction, adaptation, migration and deployment of maps, workflows, worklets, sessions and load jobs.
Develop of data integration processes (ETL) using the features of the Informatica PowerCenter tool, especially the override option, together with the pushdown option for Teradata database.

Skills & Attributes

Bachelor’s Degree or post degree on IT or Computer Sciences
Proven experience of +3 years in data analytics projects related to Teradata / PowerCenter on one or more than the following:

Business requirements gathering
Testing plans elaboration and execution
Homologation/approval plans creation
Creation, maintenance, adjustment or improvement of ETL Jobs
Planning tests (unitary, integrated and user acceptance) and deployments
Elaboration of the ETL strategy
Provide technical training (training, mentoring or workshops)
Knowledge transfer management

Informatica PowerCenter Specialist certification is required.
Portuguese / English spoken and written level.

Desirable Skills :

Teradata certification.

Why We Think You’ll Love Teradata We prioritize a people-first culture because we know our people are at the very heart of our success. We embrace a flexible work model because we trust our people to make decisions about how, when, and where they work. We focus on well-being because we care about our people and their ability to thrive both personally and professionally. We are committed to actively working to foster an inclusive environment that celebrates people for all of who they are.