Skip to content
Search jobs inside your AI agent. Claude, ChatGPT, Claude Code, Codex, Gemini, Cursor and Grok
Connect

Envision Technology Solutions

NewBe an early applicant

Informatica /ETL Developer

Posted

Summary

Designs, develops, and maintains ETL pipelines in Informatica PowerCenter, using Oracle/SQL-PLSQL, big-data tools (Hadoop ecosystem, Spark, Kafka), and schedulers like AutoSys to build and optimize data warehouses. On-site role based in Pittsburgh, Charlotte, or Plano.

Role : Informatica /ETL Developer

Location : Pittsburgh PA/ Charlotte, NC Plano TX


Primary skill: ETL Informatica Development

Secondary skills: Oracle and SQL


  • Experience: Demonstrated extensive experience in ETL development using Informatica, Oracle, and SQL, with the expertise required to perform the responsibilities of the role.


Roles & Responsibilities


  • Bachelor's or master's degree in computer science or a related field.
  • Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
  • Demonstrate a deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop,
  • Zookeeper, and Oozie.
  • Apply experience with Spark, Kafka, and NoSQL databases.
  • Work effectively within Agile methodology.
  • Use code-versioning tools such as Bitbucket.
  • Use SQL/PLSQL to extract, transform, and load data.
  • Apply advanced transformations, including data transformations and parsing JSON/XML messages.
  • Use job-scheduling tools such as AutoSys.
  • Integrate data from various sources while ensuring data consistency and quality.
  • Design and maintain data warehouses to support business intelligence activities.
  • Optimize SQL scripts and queries for speed and efficiency.
  • Identify and resolve issues in ETL processes.
  • Create and maintain technical documentation for ETL processes.
  • Perform unit, integration, and system testing on ETL processes.
  • Collaborate with cross-functional teams to support the successful implementation of ETL processes.
  • Ensure data quality by implementing data-cleansing and transformation processes.
  • Develop and maintain relational and dimensional data models innovative solutions for the industry.

Skills

Apply

See also

Data Engineering jobs by country — openings, pay and top skills →