Etl Consultant

Há 7 dias


São Paulo, São Paulo, Brasil Teradata Tempo inteiro

ETL Consultant - Power Center
**Location**: São Paulo
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



  • São Paulo, São Paulo, Brasil Fast Dolphin Tempo inteiro R$90.000 - R$120.000 por ano

    Oracle Hyperion Consultant – Suporte a Aplicações (Hyperion + Unix)Duração:até dez/2025 (possibilidade de prorrogação)Inglês:Mínimo B2Hibrido( 2x no bairro do Itaim Bibi em São Paulo )Estamos em busca de um(a) profissional com forte experiência em Oracle Hyperion,Unix,SQL,Essbaseescripting (Shell, Python, VB/Java/Batch)para atuar com suporte e...

  • Data Engineer Consultant

    4 semanas atrás


    São Paulo, São Paulo, Brasil Inter-American Development Bank Tempo inteiro

    Join to apply for the Data Engineer Consultant role at Inter-American Development Bank2 weeks ago Be among the first 25 applicantsJoin to apply for the Data Engineer Consultant role at Inter-American Development BankGet AI-powered advice on this job and more exclusive features.Direct message the job poster from Inter-American Development BankGlobal Talent...

  • Data Consultant

    2 semanas atrás


    São Paulo, São Paulo, Brasil Endava Tempo inteiro

    **Company Description**Technology is our how. And people are our why. For over two decades, we have been harnessing technology to drive meaningful change.By combining world-class engineering, industry expertise and a people-centric mindset, we consult and partner with leading brands from various industries to create dynamic platforms and intelligent digital...

  • Sap Bw Btp Consultant

    1 semana atrás


    São Paulo, São Paulo, Brasil NP Group Tempo inteiro

    SAP BW / BTP ConsultantLocation: On-site – São Paulo, BrazilContract Type: ContractLanguage Requirements: Portuguese About the Role:We are seeking an experienced SAP BW / BTP Consultant to join our team on-site in São Paulo. The ideal candidate will have a strong background in SAP BW or BW/4HANA, combined with practical experience in SAP Business...


  • São Paulo, São Paulo, Brasil beBeeData Tempo inteiro R$60.000 - R$90.000

    About this Position:Expertise in data modeling, ETL, and data warehousing is key for a successful SAP BW/BTP consultant.Key Responsibilities:Develop sophisticated data models in SAP BW/BW/4HANAIntegrate on-premises BW systems with SAP BTP services, including SAP Datasphere and SAP HANA CloudDesign and implement data pipelines and transformations in SAP...


  • São Paulo, São Paulo, Brasil Denodo Tempo inteiro

    OverviewJoin to apply for the Technical Consultant role at Denodo.As a passionate Technical Consultant, you will be responsible for consulting, solution/problem-solving, and empowering our clients data journey using Data Virtualization. Our customers' projects include integrating data in a virtual manner for operational and/or analytical purposes - combining...


  • São Paulo, São Paulo, Brasil Denodo Tempo inteiro

    Overview Join to apply for the Technical Consultant role at Denodo . As a passionate Technical Consultant, you will be responsible for consulting, solution/problem-solving, and empowering our clients data journey using Data Virtualization. Our customers' projects include integrating data in a virtual manner for operational and/or analytical purposes -...


  • São Paulo, São Paulo, Brasil Denodo Technologies, Inc. Tempo inteiro

    Select how often (in days) to receive an alert:Technical ConsultantJob Category: Product & SolutionsDenodo is a leader in data management. The award-winning Denodo Platform is the leading data integration, management, and delivery platform using a logical approach to enable self- service BI, data science, hybrid/multi-cloud data integration, and enterprise...


  • São Paulo, São Paulo, Brasil Denodo Technologies, Inc. Tempo inteiro

    Select how often (in days) to receive an alert:Technical ConsultantJob Category: Product & SolutionsDenodo is a leader in data management. The award-winning Denodo Platform is the leading data integration, management, and delivery platform using a logical approach to enable self- service BI, data science, hybrid/multi-cloud data integration, and enterprise...


  • São Paulo, São Paulo, Brasil Denodo Technologies, Inc. Tempo inteiro

    Select how often (in days) to receive an alert: Technical Consultant Job Category: Product & Solutions Denodo is a leader in data management. The award-winning Denodo Platform is the leading data integration, management, and delivery platform using a logical approach to enable self- service BI, data science, hybrid/multi-cloud data integration, and...