Job Description
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.