Be aware of scams on social media involving phony job postings. Learn more


ETL Consultant - PowerCenter & Teradata

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

Apply

Requisition Number: 214843

External Description:

ETL Consultant - Power Center

Location: São Paulo

 Job Summary   

Specializes in the design and development of the ETL environment, processes, programs, and scripts to acquire data from source systems and apply the data to Hadoop or the tables in the Teradata database.

 General Key Areas of Responsibility

Data Developers development, implement, and test data ingestion and/or ETL/ELT processes to meet functional and non-functional requirements and objectives. Data Developers focus on moving vast amounts of data from source to target systems and building data pipelines. A Data Developer works with the delivery team, Data Engineers, and Data Scientists as part of an agile process solving complex data projects using innovative solutions. Data Developers have a deep knowledge of Teradata and the data warehousing arena, and open source analytical and data technologies. Data Developers are broadly aligned with the Data Acquisition & Integration sub-practice.

 

Data Developers are encouraged to develop into “T-shaped” professionals, who may specialize in one or two disciplines (e.g.: streaming ingest or ELT processing) and technologies (e.g.: Informatica, GCFR, Kafka), but also have a working knowledge of a wider range of data processing patterns and technologies. Data Developers develop an adaptable skillset to enable them to perform technical consultancy and post sales project delivery.

Skills & Attributes

  • Bachelor’s Degree or post degree on IT or Computer Sciences

 

  • Proven experience of +1 year in Data Warehouse projects related to Teradata or more years of working experience and certified on Informatica Powercenter and the following:

 

  • Architecture definition and design detailed in subject areas.
  • Use and dissemination of the best practices of implementing data warehouses
  • Definition of test plan (units, integrated and user acceptance) and deployments
  • Expertise in ETL strategy
  • Logical and physical data models
  • Data mapping
  • Handling advanced SQL
  • Construction of scripts using BTEQ (Basic Teradata Query).
  • Construction of scripts in Teradata platform loaders and data transport (Teradata Tools and Utilities), especially for the Teradata Parallel Transporter utility
  • Analyzes and understands the client’s business at a functional or technical level
  • Testing plans elaboration and execution
  • Homologation/approval plans creation
  • Provide technical training (training, mentoring or workshops)
  • Knowledge transfer management
  • Developing Maps, Sessions, Worklets and Workflows using Powercenter
  • Developing Maps using PushDown Optimization with Teradata and PowerCenter
  • Log analysis and PowerCenter process monitoring
  • Troubleshooting Strategies
  • Understanding of shell script programming
  • Knowledge of Unix/Linux commands

 

  • Informatica PowerCenter: PowerCenter Data Integration 10: Developer, Specialist Certification
  • Teradata 14 Certified Professional certification or Vantage Certified Associate SQL Engine 16.x certification
  • English skills at least intermediate level

CountryEEOText_Description:

City: SAO PAULO

State: Sao Paulo

Community / Marketing Title: ETL Consultant - PowerCenter & Teradata

Job Category: Consulting

Company Profile:

Our Company

Teradata is the connected multi-cloud data platform for enterprise analytics company. Our enterprise analytics solve business challenges from start to scale. Only Teradata gives you the flexibility to handle the massive and mixed data workloads of the future, today.

The Teradata Vantage architecture is cloud native, delivered as-a-service, and built on an open ecosystem. These design features make Vantage the ideal platform to optimize price performance in a multi-cloud environment.

LinkedIn Remote:

Location_formattedLocationLong: SAO PAULO, Sao Paulo BR

.

© 2022, Teradata. All rights reserved. | Privacy | Terms of Use | Fraud Alert | Tracking Consent | Teradata is an Equal Opportunity Employer | www.teradata.com