ETL Consultant - Power Center
**Location**: Curitiba
Job Summary
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:
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