26 Oct
ETL - ETL Data Engineer
Illinois, Oakbrook , 60523 Oakbrook USA

Vacancy expired!

Job Description:The Data Engineer we hire will perform a variety of project and technical tasks supporting the analytics infrastructure, including data integration and ETL, database architecture and design, data prep, and reporting. Contribute to all aspects of the project lifecycle, including requirements gathering, design, development, testing, and deployment. Become familiar with the business model and the various business functions that utilize the analytics infrastructure, including sales, marketing, supply chain, operations, pricing, finance, and customer care. Keep abreast of trends, architectures, and tools in the analytics landscape and evaluate them for incorporation into their analytics landscape. Learn quickly and juggle multiple tasks for various customers. Communicate complex technical problems effectively to management and to the business. Collaborate with other technical team members on solutions. Effectively prioritize support tasks with project work. Specific duties include:
  • Design, develop and maintain data models, database architectures, and associated database objects in Snowflake, Oracle, and other database solutions such as Azure.
  • Design, develop, and maintain data integrations using Informatica Power Center, Informatica Integrated Cloud Services, and data prep tools.
  • Participate in or drive project activities such as requirements gathering, design, develop, test, and deploy.
  • Assist in the set-up of, and administer, on premise and cloud tools used in the analytics infrastructure.
  • Create and maintain necessary technical documentation, including requirements, design, and test documents.
  • Identify emerging trends, processes, and techniques impacting analytics infrastructure and make suggestions for incorporation of these into the analytics infrastructure.

Qualifications:Mandatory:
  • • A Master’s or Bachelor’s degree in Computer Science, MIS, engineering, or a related technical discipline is required.
  • • 5+ years of experience in data engineering, data warehousing, business intelligence, ETL on databases such as Oracle or SQL Server, and/or big data is required.
  • • 3+ years of experience in ETL/ data integration is required with 2+ years of experience in Informatica PowerCenter, job scheduling tools is required.
  • • Working experience in Python/R/Scala, Snowflake is required.
  • • Hands on experience in writing and understanding complex SQL (e.g. CTE’s others).
  • • Thorough understanding of relational database design and best practices, including dimensional (star, snowflake) models is required.
  • • A collaborative working style and ability to work well within the team and with business consumers is required.
  • • Ability to clearly communicate to technical and non-technical audience by written and verbal is required.
  • • Independent analytical, critical thinking, and problem-solving ability in complex technical environments is required.
Nice to have:
  • Production experience in OBIEE, Oracle Analytics Cloud (OAC) and Tableau is nice to have.
  • Familiarity with big data technologies such as Microsoft Azure Data or AWS is nice to have.

Qualifications:Mandatory:
  • • A Master’s or Bachelor’s degree in Computer Science, MIS, engineering, or a related technical discipline is required.
  • • 5+ years of experience in data engineering, data warehousing, business intelligence, ETL on databases such as Oracle or SQL Server, and/or big data is required.
  • • 3+ years of experience in ETL/ data integration is required with 2+ years of experience in Informatica PowerCenter, job scheduling tools is required.
  • • Working experience in Python/R/Scala, Snowflake is required.
  • • Hands on experience in writing and understanding complex SQL (e.g. CTE’s others).
  • • Thorough understanding of relational database design and best practices, including dimensional (star, snowflake) models is required.
  • • A collaborative working style and ability to work well within the team and with business consumers is required.
  • • Ability to clearly communicate to technical and non-technical audience by written and verbal is required.
  • • Independent analytical, critical thinking, and problem-solving ability in complex technical environments is required.
Nice to have:
  • Production experience in OBIEE, Oracle Analytics Cloud (OAC) and Tableau is nice to have.
  • Familiarity with big data technologies such as Microsoft Azure Data or AWS is nice to have.

Vacancy expired!

Subscribe for new vacancies
Report job