ETL Informatica/Hadoop Developer
Job Description
Role : ETL Informatica/Hadoop Developer
\n
Location: Charlotte, NC / Plano, TX (NO REMOTE) Hybrid Only
\n
Duration: Fulltime Role
\n
\n
Must-Have Technical/Functional Skills
\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
\n
the expertise required to perform the responsibilities of the role.
\n
Experience : 10 Years
\n
Roles & Responsibilities
\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
\n
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 modelsinnovative solutions for the industry.