This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Perform development work and technical support related to our data transformation and ETL jobs in support of a global data warehouse. Requires the ability to work independently, as well as in cooperation with a variety of customers and other technical professionals.
Job Responsibility:
Development of new ETL/data transformation jobs, using PySpark and IBM DataStage in AWS
Enhancement and support on existing ETL/data transformation jobs
Perform technical code reviews for peers moving code into production
Perform and review integration testing before production migrations
Provide high level of technical support, and perform root cause analysis for problems experienced within area of functional responsibility
Requirements:
4+ years of ETL experience
A certification with less experience may also be considered
Strong knowledge of SQL fundamentals
Able to write SQL code sufficient for most business requirements for pulling data from sources, applying rules to the data, and stocking target data
Proven track record in troubleshooting ETL jobs and addressing production issues like performance tuning, reject handling, and ad-hoc reloads
Proficient in developing optimization strategies for ETL processes
Strong knowledge of core Python programming for data transformation
Beginning PySpark skills
Can read/understand existing code and do simple debug and code fixes
Basic AWS technical support skills
Has ability to log in, find existing jobs and check run status and logs
Will run and monitor jobs running via Control-M
Can create clear and concise documentation and communications
Ability to coordinate and aggressively follow up on incidents and problems, perform diagnosis, and provide resolution to minimize service interruption
Ability to prioritize and work on multiple tasks simultaneously
Effective in cross-functional and global environments to manage multiple tasks and assignments concurrently with effective communication skills
A self-starter who can work well independently and on team projects
Bachelors of Science in computer science or equivalent