User Interface Designer

Overview

Primary Skill: ETL Informatica Developer. Secondary:
Oracle, SQL.

Experience:

Minimum 10 years.

• ETL Process Development:
  Design, develop, and maintain ETL processes using Informatica Power Center or other relevant Informatica tools.
• Deep understanding of HDFS, YARN, Map Reduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie.
• Experience with Spark, Kafka, No
  
  SQL databases.
• Experience in Agile Methodology.
• Experience with code versioning tools like Bit-Bucket.
• SQL Proficiency:
  Utilize SQL/PLSQL to extract, transform, and load data.
• Exposure to advanced transformations such as data transformations and parsing JSON/XML messages.
• Experience in Job scheduling tools like Autosys.
• Data Integration:
  Integrate data from various sources, ensuring data consistency and quality.
• Data Warehouse Design:
  Design and maintain data warehouses to support business intelligence activities.
• Performance Optimization:
  Optimize SQL scripts/queries for speed and efficiency.
• Troubleshooting:
  Identify and resolve issues in ETL processes.
• Documentation:
  Create and maintain technical documentation for ETL processes.
• Testing:
  Perform unit, integration, and system testing on ETL processes.
• Collaboration:
  
  Collaborate with cross-functional teams to ensure successful implementation of ETL processes.
• Data Quality:
  Ensure data quality by implementing data cleansing and transformation processes.
• Data Modeling:
  Develop and maintain relational and dimensional data models.

• Minimum 10 years of experience in ETL development and data integration.
• Strong expertise in Informatica Power Center or equivalent Informatica tools.
• Proficiency in Oracle and SQL/PLSQL.
• Experience with big data technologies (HDFS, YARN, Map Reduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie).
• Experience with Spark, Kafka, No
  
  SQL databases.
• Familiarity with Agile methodologies.
• Experience with code versioning tools (Bit-Bucket).
• Experience with Job scheduling tools (Autosys).
• Bachelor of Computer Science or equivalent.

Location:

Newark, DE

Salary Range: $70,000-$75,000 a year