Raas Infotek - Irving, TX

posted 3 months ago

Full-time - Senior
Irving, TX
Professional, Scientific, and Technical Services

About the position

The Senior ETL Informatica Developer will play a critical role in the design, development, and implementation of ETL processes using Informatica PowerCenter and other ETL tools. This position requires a deep understanding of data integration and transformation processes, as well as the ability to work with various data sources and technologies. The ideal candidate will have extensive experience in developing complex SQL scripts and will be responsible for ensuring the efficiency and performance of ETL jobs. The role involves collaborating with data analysts and other stakeholders to gather requirements and translate them into technical specifications for ETL processes. Additionally, the developer will be expected to troubleshoot and resolve any issues that arise during the ETL process, ensuring data integrity and accuracy throughout the data pipeline. In this position, the Senior ETL Informatica Developer will also be responsible for managing multiple projects simultaneously, prioritizing tasks effectively, and adapting to changing project requirements. The candidate will work closely with data visualization teams to ensure that data is properly integrated and available for reporting and analysis in tools such as Tableau. The role requires strong analytical and problem-solving skills, as well as the ability to communicate technical concepts to non-technical stakeholders. The developer will also be expected to document ETL processes and maintain best practices for data integration and management.

Responsibilities

  • Design and develop ETL processes using Informatica PowerCenter, IICS, and ADF.
  • Create and optimize complex Oracle SQL scripts for data extraction and transformation.
  • Integrate data from multiple sources including Oracle, SQL Server, Excel, Access, and Adobe PDF.
  • Collaborate with data analysts to gather requirements and translate them into technical specifications.
  • Troubleshoot and resolve ETL process issues to ensure data integrity and accuracy.
  • Document ETL processes and maintain best practices for data management.
  • Work with Tableau data visualization teams to ensure data availability for reporting.
  • Manage multiple projects and prioritize conflicting assignments effectively.

Requirements

  • 10+ years experience with ETL tools such as Informatica PowerCenter, IICS, and ADF.
  • 10 years experience designing and developing complex Oracle SQL scripts.
  • 10 years of strong analytical and problem-solving skills, particularly in data analytics or data warehousing projects.
  • 9 years of experience integrating data from multiple sources using Informatica PowerCenter for Tableau.
  • 8 years experience with JIRA software.
  • 8 years experience working with Snowflake.

Nice-to-haves

  • Master's degree in Computer Science, Information Systems, or Business or equivalent experience.
  • Experience managing multiple responsibilities and prioritizing conflicting assignments.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service