Data Engineer

Job description


JOB ROLE Data Engineer

Job Role

  • We are looking for an experienced SQL , PLSQL and Data Stage ETL developer to join our team as a Data Engineer who will work as part of a team to help design and develop data-driven solutions that deliver insights to the business.
  • The ideal candidate is a data pipeline builder and data wrangler who enjoys building data-driven systems that drive analytical solutions and building them from the ground up.
  • You will be responsible for building and optimizing our data as well as building automated processes for production jobs.
  • You will support our software developers, database architects, data analysts and data scientists on data initiatives.

Essential Job Functions

  • Designs, develops, builds and implements extracts transforms and loads (i.e. the facilitation of data movement across platforms) utilizing Client DataStage ETL Tool.
  • Designs and develops highly complex ETL processing the support of data warehouses and/ or operational data stores.
  • Outstanding SQL/PLSQL Skills and experience performing deep data analysis on multiple database platforms. (Oracle is preferable)
  • Understanding Data Transformation and translations requirements and which tools to leverage to get the job done.
  • Experience in Data Lake Implementation in snowflake (preferable).
  • Develops UNIX scripts and Oracle packages.
  • Determines the appropriate design for ETL applications based on information gathered including data sources, data targets, data definitions, data relationships, and business rules.
  • Works closely with project management, analysts, data modelers and the existing ETL developers to understand project requirements and contribute to the project solution.
  • Provides technical expertise on ETL design, Data modeling, Data Warehousing, and Data integration Partner with Business Intelligence and Business operational teams to understand data sources and implement new requirements.
  • Analyzes and summarize data to facilitate Business Intelligent decisions.
  • A Solid Experience and understanding of designing and operationalization of large-scale data and analytics solution on snowflake cloud data warehouse.
  • Advanced proficiency with SQL and related RDBMS query tools
  • Ability to clearly communicate solutions to both technical and non-technical teams
  • Scripting /Coding experience in Python /UNIX.

Qualification & Experience Requirements

  • Bachelor's degree in computer science, computer engineering, or a related field.
  • 5 + years of experience working with Oracle and ETL (Data Stage)
  • 2+ years of experience with the snowflake (Preferable) .
  • Familiar with issue tracking systems like JIRA (Project Management Tool) or Trello.
  • Experience working in an agile environment.

Desired Skills

  • Experience in Snowflake.
  • Experience in DataStage and Snap logic
  • Working knowledge of AWS or Azure
  • Experience in migrating from on-prem to cloud systems.
  • Experience in Data Lake Implementation in Snowflake (preferable).

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.

Similar jobs

Browse All Jobs

AWS Data Engineer

May 22, 2024

Data Engineer