Senior ETL Developer

About our client

A multi-national organization producing on-demand software for SCM industry across the globe, is expanding their IT team.

About the role

Hiring a talented database ETL developer to join a growing global data operations team.  As a Data Center Operations team member, you will be joining a collaborative team responsible for delivery and support of mission critical EDI infrastructure used by major global brands. 

Your responsibilities

• Analysis, design and build ODS, Data Warehouse, Data Mart & Data Lake in association with the Business Intelligence (BI) semantic layers to drive and optimize business analytics and reporting.

• Develop new ETL flows for On-Premise to On-Premise, On-Premise to Cloud and/or from Cloud to Cloud.

• Enhance and maintain existing ETL application function and performance.

• Lead efforts to understand content & patterns, as well as investigate data issues; quality, lineage or decision-making business questions.

• Collaboration with other teams to optimize fault tolerant features to ensure High Availability.

• Develop, maintain, and document code for Application Deployment and Administration.

• Work within Agile methodology to build and deploy new functionality.

• Work within ITIL framework for change, incident & problem management processes.

You will have

Prior Experience

• At least 5+ years’ of Data Warehouse & Information Management experience.

• At least 3+ years’ experience with Oracle or Postgres databases.

• At least 2+ years’ experience with PL/SQL Development.

• At least 2 years’ experience with RedShift, Python.

• At least 2 years’ experience with Oracle Data Integrator.

Skills & Qualities

• Proficient in Data Integration/Modeling, Reporting/Analytics and Business Intelligence tools.

• Solid understanding of ETL concepts and Data Mart skills are required.

• Proficient with Python and/or Java.

• Working knowledge of ETL, Data and Application Integration tools and technologies.

• Proficient in SQL, PL/SQL and T-SQL and optimization and monitoring.

• Proficient in Oracle Data Integrator (ODI).

• Proficient with *NIX shell and batch scripting and processing.

• Familiarity with AWS products; RedShift, RDS, Lambda, Data Pipe.

• Familiarity with Dell Boomi a plus.

• Experience with columnar databases.

Education & Professional Qualifications

• B.S. Computer Science/Engineering or equivalent computer-related education.