Data Engineer (ETL/Informatica/SQL/Python)

Element Technologies Inc.
Raleigh / durham / CH, NC
09 Feb 2025

Vacancy expired!

Job Title: Data Engineer (ETL/Informatica/SQL/Python)

Location: Smithfield, RI., Westlake, Texas or Raleigh, NC

Duration: 8+ Months

Must Have:
  • Informatica/ETL experience
  • SQL/Oracle/Snowflake (Snowflake preferred)
  • Basic Python (5/10)
We are currently sourcing for a Data Engineer to work in Smithfield, RI., Westlake, Texas or Raleigh, NC!. Client enables business partners to win in their respective marketplaces by crafting, building and maintaining the technology platforms and products of Client Institutional, Personal Investing and Workplace Investing. FBT Business Intelligence Team is looking for a Lead Technologist to build and support various BI applications on as part of Consolidated Data Platform initiative

Role Description
  • You will be responsible for partnering with the project sponsors, Analysts and Architecture teams to craft and deliver outstanding business intelligence applications.

Required Qualifications
  • 7+ years of experience design and development of large-scale Data engineering applications,
  • 10+ Years of IT experience
  • 2+ years of Python development experience
  • 8+ years of architecture, design and development of highly scalable distributed data processing systems
  • 5+ years implementing batch and real-time Data integration frameworks and/or applications,
  • 3+ years of hands-on experience in Oracle PL/SQL programming and applying Oracle query optimization techniques (must have minimum three years hands on experience)
  • Proficient with DevOps, Continuous Integration and Continuous Delivery (Jenkins, Stash).
  • Experience and comfort completing projects in Agile environments (Kanban and Scrum).

Experience
  • A minimum of 2 years of Python development experience
  • In-depth understanding of ETL & Data warehousing System
  • Developing PL/SQL objects as per business logic in Teradata, PostgreSQL and/or Oracle databases.
  • Performing SQL & PL/SQL code tuning, creation of partitions and indexes to improve performance
  • Working experience with Informatica, Unix Programming is must
  • Experience with SQOOP, Hive, Spark is a PLUS
  • Experience with shell scripting, control