Reliable Software Resources - St. Louis, MO

posted 3 months ago

Full-time
St. Louis, MO
Professional, Scientific, and Technical Services

About the position

The ETL Developer position is a critical role within our client's organization, focusing on the extraction, transformation, and loading of data to support various business processes. The successful candidate will be responsible for designing and implementing ETL processes that ensure data integrity and availability for reporting and analytics. This role requires a deep understanding of data warehousing concepts and the ability to work with large datasets to optimize performance and efficiency. The ETL Developer will collaborate closely with data architects, business analysts, and other stakeholders to gather requirements and translate them into technical specifications. In this position, you will leverage your expertise in PL/SQL and Oracle databases to develop and optimize stored procedures and functions. You will also be expected to utilize data integration tools such as Informatica, Talend, or SSIS to facilitate seamless data movement across systems. A solid grasp of data governance, quality, and security principles is essential, as you will be tasked with ensuring that data is accurate, consistent, and compliant with organizational standards. The role is onsite in Saint Louis, MO, and requires a proactive approach to problem-solving and a strong ability to communicate technical concepts to non-technical stakeholders. As the ETL Developer, you will play a key role in enhancing the organization's data capabilities and supporting data-driven decision-making processes.

Responsibilities

  • Design and implement ETL processes to extract, transform, and load data.
  • Develop and optimize stored procedures and functions using PL/SQL.
  • Collaborate with data architects and business analysts to gather requirements.
  • Utilize data integration tools such as Informatica, Talend, or SSIS for data movement.
  • Ensure data integrity and availability for reporting and analytics.
  • Monitor and tune database performance for optimal efficiency.
  • Implement data governance, quality, and security measures.

Requirements

  • Bachelor's degree in Computer Science, Information Technology, or a related field.
  • Proven experience as an ETL Developer, Data Engineer, or in a similar role.
  • Strong proficiency in PL/SQL and experience with Oracle databases.
  • Expertise in developing and optimizing stored procedures and functions.
  • Solid understanding of data warehousing concepts, data modeling, and ETL processes.
  • Experience with data integration tools and technologies (e.g., Informatica, Talend, SSIS).
  • Knowledge of database performance tuning and optimization techniques.
  • Familiarity with data governance, data quality, and data security principles.
  • Strong analytical and problem-solving skills.
  • Excellent communication and collaboration skills.

Nice-to-haves

  • Master's degree in Management Information Systems (MIS), Computer Science, Big Data or Analytics or equivalent.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service