ETL Consultant - PowerCenter & Teradata

Requisition Number: 214852

External Description:

ETL Consultant - Power Center

Location: Curitiba / SP

 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 ingests 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 on Informatica PowerCenter (Teradata experience will be a plus), and/on 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..
• 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 
• Developing Maps using PushDown Optimization 
• Log analysis and process monitoring
• Troubleshooting Strategies
• Understanding of shell script programming
• Knowledge of Unix/Linux commands
• Will be highly desired to have certifications on Informatica PowerCenter (PowerCenter Data Integration 10: Developer, Specialist Certification) or Teradata (Teradata 14 Certified Professional certification or Vantage Certified Associate SQL Engine 16.x certification)
• English skills at least intermediate level
• The position will require to be based on Curitiba or Sao Paulo (with travels to Curitiba)

CountryEEOText_Description:

City: Curitiba

State: Sao Paulo

Community / Marketing Title: ETL Consultant - PowerCenter & Teradata

Job Category: Consulting

Company Profile:

Our Company

At Teradata, we believe that people thrive when empowered with better information. That’s why we built the most complete cloud analytics and data platform for AI. By delivering harmonized data, trusted AI, and faster innovation, we uplift and empower our customers—and our customers’ customers—to make better, more confident decisions. The world’s top companies across every major industry trust Teradata to improve business performance, enrich customer experiences, and fully integrate data across the enterprise.

LinkedIn Remote:

Location_formattedLocationLong: Curitiba, Sao Paulo BR