Data Integration DI ETL Consultant
Location: Curitiba, Sao Paulo BR
Requisition Number: 205902
Position Title: Managed Services III
Data Integration ETL Technical Consultant
Location: Curitiba, Brazil
Data Integration/ETL (DI/ETL) Technical Consultant role is responsible for the development, testing, implementation, sustainment, and support of data warehouse solutions including Data Integration tools.
The DI/ETL Consultant specializes in the analysis development and testing of the DI/ETL environment, processes, programs, and scripts to acquire data from source systems and load the data to the tables in the database.
This individual must have the skills necessary to develop and test DI/ETL processes for extracting data from legacy and production databases, develop and test DI/ETL processes for loading initial and cyclical data in a data warehouse, develop scripts for historical data retention, create and maintain technical documentation of the solution, and interact and work within a team environment.
- Bachelor’s Degree preferably in Computer Science, Computer Engineering, Management Information Systems or equivalent work experience.
- At least 5 year of experience working in Data Warehouse projects using Teradata Database.
- Strong experience and skills in structured query language (SQL).
- Have work experience on creating UNIX Shell Scripts and Stored Procedure and Macros.
- Must have a good understanding of Database Designs and Data Models
- Knowledge of DI/ETL Tools such as Teradata Parallel Transporter, Teradata Bteq, Informatica Power Center with push down optimization, including construction, testing, corrections, adaptation, migration and implementation of maps, workflows, worklets, sessions and load jobs
- Experience in analyzing and understanding business requirements
- Definition of detailed design and architecture of subject areas
- Use and dissemination of best data warehouse implementation techniques and practices
- Test planning (unit, integrated and user acceptance) and deployment
- Knowledge of BI Tool Microstrategy
- Teradata environment optimization for integration with MicroStrategy platform
- Elaboration of the ETL strategy
- Design of logical and physical data models (logical design and physical design)
- Data model adjustments and optimizations
- Elaboration of data mappings
- Collection and analysis of data demographics
- Elaboration of technical specification of data integration processes (ETL)
- ETL implementation and monitoring, including load loop rite, performance check (throughput and time duration), verification of correct load process execution and effective data loading, validation testing the content loaded by the loading, error handling and exception management
- Deployments and maintenance (evolutionary, corrective, adaptive) and support of load processes, including construction, testing, correction, adaptation, migration and deployment of maps, workflows, worklets, sessions and load jobs
- Data and environment preparation for predictive and prescriptive modeling
- Conducting experimental and prototyping activities for data solutions
- Identification of improvements to data reliability, efficiency and quality
- Advanced level of English spoken and written
- Fluent Spanish language
- Certifications: Teradata 14 Certified Professional; or Teradata Database Certified Associate is an advantage
State: Sao Paulo
Community / Marketing Title: Data Integration DI ETL Consultant
Job Category: Consulting
With all the investments made in analytics, it’s time to stop buying into partial solutions that overpromise and underdeliver. It’s time to invest in answers. Only Teradata leverages all of the data, all of the time, so that customers can analyze anything, deploy anywhere, and deliver analytics that matter most to them. And we do it at scale, on-premises, in the Cloud, or anywhere in between.
We call this Pervasive Data Intelligence. It’s the answer to the complexity, cost, and inadequacy of today’s analytics. And it's the way Teradata transforms how businesses work and people live through the power of data throughout the world. Join us and help create the era of Pervasive Data Intelligence.
Location_formattedLocationLong: Curitiba, Sao Paulo BR