Job Description

Primary Skill

ETL Informatica Developer

Secondary skills: Oracle, SQL

Experience: Minimum 10 years

Roles & Responsibilities
  • Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.
  • Deep understanding of HDFS, YARN, MapReduce, Hive, Pig, HBase, Flume, Sqoop, Zookeeper, Oozie.
  • Experience with Spark, Kafka, NoSQL 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, 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.

Salary Range: $90,000–$120,000 a year

Qualifications

Bachelor of Computer Science

#J-18808-Ljbffr
Similar jobs

Software Developer

Apply Now
Back to search page