ETL Informatica/Hadoop Developer

Job Description

Role :: ETL Informatica/Hadoop Developer

\n

Location :: Charlotte, NC/Plano, TX

\n

Type :: Fulltime

\n

\n

Job Description

\n

Must-Have Technical/Functional Skills

\n

\n

• Primary skill: ETL Informatica Development

\n

• Secondary skills: Oracle and SQL

\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

Roles & Responsibilities

\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, 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 modelsinnovative solutions for the industry

\n

\n