- Design, develop, and implement ETL processes using Apache Hop or Kettle/PDI (preferably) to extract, transform, and load data from various sources into target systems.
- Identify and resolve data quality issues, data transformation challenges, and performance bottlenecks during the ETL process using Apache Hop or Kettle/PDI.
- Develop and maintain ETL documentation, including technical specifications, data mappings, and process flows, with a focus on Apache Hop or Kettle/PDI.
- Establish connections to different data sources based on SQL, APIs, or file exchange.
- Maintain and expand the staging area with new data sources.
- Collaborate with business analysts, data architects, and other stakeholders to understand data requirements and develop ETL solutions.
- Create data analysis models based on fact and dimension tables.
- Perform data validation and testing using Apache Hop or Kettle/PDI to ensure accuracy and completeness of ETL processes.
- Monitor and troubleshoot ETL jobs using Apache Hop or Kettle/PDI to ensure smooth execution and identify and resolve any issues or failures.
- Collaborate with database administrators and system administrators to optimize ETL processes using Apache Hop or Kettle/PDI and ensure optimal performance.
- Stay updated on emerging ETL technologies, tools, and best practices, particularly related to Apache Hop, Kettle/PDI, and similar tools, and recommend improvements to enhance the efficiency and effectiveness of ETL processes.
- Bachelor's degree in Computer Science, Information Systems, or a related field. Relevant work experience may be accepted in place of a degree.
- Extensive experience with Apache Hop or Kettle/PDI ETL tools at least three years.
- Proven experience as an ETL developer or in a similar data integration role.
- Strong understanding of ETL concepts, methodologies, and best practices.
- Proficiency in SQL and experience with databases such as Oracle, SQL Server, or MySQL.
- Knowledge and experience in integrating systems using APIs (Application Programming Interface), including the ability to consume and expose APIs, use protocols like REST or SOAP, and understand concepts like authentication, authorization, and error handling in API-based integrations.
- Familiarity with data warehousing concepts and dimensional modeling.
- Strong problem-solving and error-solving skills.
- Excellent attention to detail and ability to work with large datasets.
- Strong communication and collaboration skills to work effectively with cross-functional teams.
- Ability to work independently and handle multiple tasks simultaneously in a fast-paced environment.
- Extensive knowledge and experience using GIT as a version control system, including the ability to use basic GIT commands such as commit, push, pull, and merge, as well as branch management and conflict resolution.
- Familiarity with GitFlow workflow and experience in its implementation, including creating and merging feature branches, release branches, and hotfix branches according to established best practices.
- Experience in connecting to remote systems (UNIX) via SSH and the ability to navigate the file system using basic Bash commands. Skills to navigate, create, copy, move, and delete files and directories in the remote server's file system using commands such as ssh, cd, ls, mkdir, cp, mv, and rm. Knowledge of UNIX permission system.
- High level of English (required)
- Intermediate level of Spanish (desirable)
-
Etl Developer Mexico
hace 1 día
Photon Ciudad de MéxicoOverview · : · Development and support of ETL processes to support analytic needs. · **Description**: · We're looking for an ETL developer with experience in tech stack to support existing ETL streams and also build new streams and enhancements as needed. · Key job responsibiliti ...
-
Informatica Etl Jr Developer
hace 6 días
PepsiCo Miguel Hidalgo, MéxicoOverview: · At PepsiCo, we're redefining what it means to be a consumer products company with a digital-first mindset, and our Global IT team is leading that charge. Our technology teams unlock digital capabilities, enhance cybersecurity safeguards, deliver data-driven insights, ...
-
Etl Developer
hace 1 semana
Capital Empresarial Horizonte Xico, México**Capital Empresarial Horizonte Empresa Mexicana especialista en Recursos Humanos y Tecnologías de la Información Solicita**:**ETL Developer****Hibrido****Perfil****Escolaridad**: Ingeniería en Sistemas, Informática o afín.**Nível de inglés: inglés Conversacional INDISPENSABLE*** ...
-
Consultor (Informática Data Quality) - Santander
hace 4 días
ITKAWA Ciudad de México**Consultor (Informática Data Quality) - Santander** · **Esquema**:Hibrido - Colonia Santa Fe. · **Salario**:Abierto a negociar de acuerdo a experiência. · **Duración**:Posibilidad de prórrogas y/o contratación a tiempo completo. · **Idioma**: Inglés - Intermedio · **Experiência* ...
-
Developer Ab Initio
hace 1 día
Capgemini Ciudad de MéxicoRRHH: Rosa Barba · Puesto: Developer Ab initio · Nível de experiência: +4 años · Nível de educación: Licenciatura e Ingeniería · Ubicación: CDMX · Práctica: I&D · Industria - Sector: IT · Tus funciones: · Desarrollo de aplicaciones Ab Initio para migración de datos utilizando ETL ...
-
Data Engineer Pentaho
hace 1 día
VinkOS Ciudad de MéxicoEn **VinkOS** somos una empresa especializada en consultoría en **Big Data**, desde arquitecturas, administración de base de datos, pipelines de ingesta, modelos de análisis, hasta capacitación en herramientas de Big Data. · Nuevamente nos encontramos en crecimiento, y en esta oc ...
-
Financial Data Analyst
hace 4 días
ckl32 Ciudad de MéxicoFluency in English is required for this role. Please provide a short introductory video of yourself describing your experience and qualifications related to: · - ETL, analysis, and programming including: · - ETL data to/from customers using Excel, SQL, Python, and BI tools · - Bu ...
-
Data Analyst
hace 1 día
Pulpo Ciudad de México**We are Pulpo and PulpoPay** · Pulpo is a cloud-based, fleet operation software: it maximizes vehicle utilization, saves costs, and reduces management time. · **The opportunity**: · Pulpo is looking for a Data Analyst who design, implement and manage a business intelligence repo ...
-
Software Developer
hace 1 día
Capgemini Ciudad de MéxicoNúmero de Need: · RH: Karina Gonzalez · Position: Consultor SAS · Experience level: SR · Education level: Bachelor's Degree · Location: Mexico, Remote · Practice: I&D · Industry - Sector: Banking · What you'll do? · - Development of ETLs · - Development of scenarios · - for the ...
-
Collection Specialist
hace 4 días
Clip México**Who we are?** · Payclip is changing the way payments work in Mexico We are empowering people to exchange value directly from a mobile device. Clip enables anyone to accept card payments, at any time, and anywhere by turning your smartphone or tablet into a card terminal. We're ...
-
Engineer, SAP Business Warehouse
hace 6 días
Warner Bros Careers Ciudad de México**_Every great story has a new beginning, and yours starts here._** · **_ Welcome to Warner Bros. Discoverythe stuff dreams are made of._** · **Who We Are ** · When we say, "the stuff dreams are made of," we're not just referring to the world of wizards, dragons and superheroes, ...
-
Data Trainne
hace 3 días
Sryas Ciudad de México**Responsibilities**: · - Responsible for building / leveraging architecture and design principles in large scale implementation of enterprise projects · - Responsible in delivering solutions with high quality and on time · - Be a part in achieving the organization's technical vi ...
-
Retention Analyst
hace 3 días
Nissan Ciudad de México**Duties and Responsibilities**: · Create and design technical solutions to meet business needs by translating end user's requirements and finding innovative, creative visualizations and tools. Must be capable of strategizing and brainstorming with the team to create a viable sol ...
-
Retention Analyst
hace 6 días
Nissan Ciudad de México**Duties and Responsibilities**: · Create and design technical solutions to meet business needs by translating end user's requirements and finding innovative, creative visualizations and tools. Must be capable of strategizing and brainstorming with the team to create a viable sol ...
-
Operation Analyst
hace 6 días
NTT Data Services Ciudad de México**Req ID**: 218710 · We are currently seeking a Operation Analyst - Azure/ AWS to join our team in CDMX, Ciudad de México (MX-CMX), Mexico (MX). · **Must have Skills**: · - _2 to 3 Years of overall experience in building data pipelines and ETL using following Technologies AWS Dat ...
-
Data Engineer
hace 4 días
PPG Industries MéxicoAs a DATA ENGINEER SPECIALIST, you will be part of the business, function, or process specialists and can be technology generalists or specialists. · **Key Responsibilities** · - understanding of business intelligence solutions to help the business in decision-making. · - Accompl ...
-
Discover Support
hace 5 días
Qualtrics Ciudad de MéxicoAt Qualtrics, we create software the world's best brands use to deliver exceptional frontline experiences, build high-performing teams, and design products people love. But we are more than a platform—we are the creators and stewards of the Experience Management category serving ...
-
IT Full Stack Graphdb Developer
hace 5 días
Siemens Energy Ciudad de MéxicoMid-level Professional · **IT Full Stack GraphDB Developer** · **Location**: Mexico · **Department**: Siemens Energy Information Technology · **Mode of Employment**: Permanent · **LET'S TALK ABOUT YOU** · **Your Profile** · - Bachelor's or master's degree in Engineering with Comp ...
-
Data Engineer
hace 2 días
Chubb México**With you, Chubb is better** · Are passionate with data infrastructure, metrics and coding? Do you love creating pipelines to support business? Would you like to be a member of a fun working environment where your innovative projects make a real impact? Then, check this outstand ...
-
Mdm Engineer
hace 2 días
Trinity Technologies MéxicoRole**:MDM Engineer** · Location**:Mexico (Remote)** · Type**:Contract position.** · **Responsibilities**: · - Create and implement Master Data Management Solutions to ensure data standardization, quality, governance, and enrichment and provide a single source of truth for the do ...
ETL Developer - Ciudad de México - Paper Street Media
Descripción
Who we are - We are web-based video-on-demand networks with a focus on adult entertainment, based out of Downtown Miami. We are a group of creative souls with diverse backgrounds. If you are also a true believer of work hard & play hard, this is the place to be. At PSM, you will enjoy a fun & casual environment, team-building retreats, startup spirits, and great benefits.
What we do - We discover what excites the world and deliver it seamlessly to our members We are the creators of top sites you know and love. We are leading the industry by using cutting-edge technologies to deliver top-quality content. Our content and websites are published exclusively and enjoyed by millions of fans worldwide.
What we are looking for - Paper Street Media, LLC is hiring for a FULL-TIME ETL Developer. The primary role of the ETL Developer is responsible for the creation and maintenance of current data integration processes as well as new data sources. You will collaborate with multidisciplinary teams to understand the needs and final modeling. This job is a REMOTE position.
The job will expose you to the content of adult nature. If this is something you are not comfortable with please do not apply.
We will contact you via email only. We will not contact you via phone calls or any 3rd party messaging system. Please be aware of any job offer scam.
The job will start on a 90-day probationary period. Learn more about us here (link to )
What You'll Be Doing:
Must Haves:
