ETL/Informatica Developer

Overview

Remote
On Site
Hybrid
Depends on Experience
Contract - Independent
Contract - W2
Contract - 12 Month(s)
No Travel Required

Skills

ETL
Informatica
SQL
PySpark
Python

Job Details

Job Title: ETL/Informatica Developer

Location: Pittsburgh, PA / Cleveland, OH / Dallas, TX (Remote options available)
Duration: Long-term


ETL/Informatica Developer:

  • Lead ETL development using Informatica for large-scale data transformation and integration.
  • Utilize PySpark to handle big data processing and enhance data workflows.
  • Perform data modeling using Quest Irwin and work with other modeling tools to define and maintain data structures.
  • Write Linux scripts to manage and optimize data quality on Teradata, Hadoop, and Oracle platforms.
  • Design and implement data quality processes with in-house tools to ensure data integrity and consistency.
  • Create and maintain data lineage documentation, detailing transformations and source-to-target mapping.
  • Take ownership of migration activities, specifically migrating roles from Trillium to an in-house solution.
  • Collaborate with cross-functional teams to ensure smooth migration and seamless integration.
  • Strong experience in ETL development and working with Informatica.
  • Proficient in PySpark for handling large datasets and performing transformations.
  • Experience with Quest Irwin Data Modeling and other data modeling tools.
  • Solid understanding of Teradata, Hadoop, and Oracle environments.
  • Experience in writing Linux scripts for data quality roles and automation.
  • Strong SQL and Python skills for automation and scripting.
  • Experience with data lineage, data transformations, and source-to-target mapping.
  • Demonstrated leadership abilities to guide and manage migration processes.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.