Search

Informatica /ETL Developer

PublishedPublished: 6/14/2022
Technology
|

Job Description

Role : Informatica /ETL Developer

\n

Location : Pittsburgh PA/ Charlotte, NC Plano TX

\n


\n

Primary skill: ETL Informatica Development

\n

Secondary skills: Oracle and SQL

\n


\n

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

\n


\n

Roles & Responsibilities

\n


\n

    \n
  • Bachelor's or master's degree in computer science or a related field.
  • \n

  • Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
  • \n

  • Demonstrate a deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop,
  • \n

  • Zookeeper, and Oozie.
  • \n

  • Apply experience with Spark, Kafka, and NoSQL databases.
  • \n

  • Work effectively within Agile methodology.
  • \n

  • Use code-versioning tools such as Bitbucket.
  • \n

  • Use SQL/PLSQL to extract, transform, and load data.
  • \n

  • Apply advanced transformations, including data transformations and parsing JSON/XML messages.
  • \n

  • Use job-scheduling tools such as AutoSys.
  • \n

  • Integrate data from various sources while ensuring data consistency and quality.
  • \n

  • Design and maintain data warehouses to support business intelligence activities.
  • \n

  • Optimize SQL scripts and queries for speed and efficiency.
  • \n

  • Identify and resolve issues in ETL processes.
  • \n

  • Create and maintain technical documentation for ETL processes.
  • \n

  • Perform unit, integration, and system testing on ETL processes.
  • \n

  • Collaborate with cross-functional teams to support the successful implementation of ETL processes.
  • \n

  • Ensure data quality by implementing data-cleansing and transformation processes.
  • \n

  • Develop and maintain relational and dimensional data models innovative solutions for the industry.
  • \n

Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...