ETL Developer - Paper Street Media

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.

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 http://paperstreetmedia.com/)

What You'll Be Doing:

• 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.

Must Haves:

• 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)

Powered by JazzHR