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)