Resource Informatics Group - Des Moines, IA

posted 3 months ago

Full-time - Mid Level
Des Moines, IA
Computer and Electronic Product Manufacturing

About the position

The Sr. ETL Developer will play a crucial role in the design, development, and implementation of ETL processes to support data integration and transformation initiatives. This position requires a deep understanding of ETL methodologies and tools, particularly Informatica PowerCenter and IICS, as well as familiarity with IDMC. The ideal candidate will be responsible for analyzing data requirements, designing data flows, and ensuring data quality throughout the ETL process. The role involves collaborating with data architects, business analysts, and other stakeholders to gather requirements and translate them into technical specifications. Additionally, the Sr. ETL Developer will be expected to optimize existing ETL processes for performance and scalability, troubleshoot issues, and provide support for production systems. In this position, the developer will also be involved in the documentation of ETL processes and best practices, ensuring that all work is compliant with organizational standards. The role may require participation in code reviews and mentoring junior developers. A strong emphasis will be placed on SQL skills, as the developer will need to write complex queries to extract, transform, and load data from various sources. Familiarity with .Net development is considered a significant advantage, as it may be required for certain integration tasks. The position is onsite/hybrid in W. Des Moines, IA, and candidates who can interview in person will be given strong preference. This is a contract position expected to last for 6 months, with the possibility of extensions based on project needs.

Responsibilities

  • Design, develop, and implement ETL processes using Informatica PowerCenter and IICS.
  • Analyze data requirements and design data flows to meet business needs.
  • Ensure data quality and integrity throughout the ETL process.
  • Collaborate with data architects and business analysts to gather requirements.
  • Optimize existing ETL processes for performance and scalability.
  • Troubleshoot and resolve issues in production systems.
  • Document ETL processes and best practices for future reference.
  • Participate in code reviews and mentor junior developers.

Requirements

  • Proven experience with Informatica PowerCenter and IICS.
  • Familiarity with IDMC (Intelligent Data Management Cloud).
  • Strong SQL skills for data extraction and transformation.
  • Experience in .Net development is a plus.

Nice-to-haves

  • Experience with data warehousing concepts and methodologies.
  • Knowledge of cloud data integration tools.
  • Familiarity with data governance and data quality frameworks.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service