Software Developer, Data Engineering, SQL Developer

Primary Skill

ETL Informatica Developer

Oracle, SQL

Minimum 10 years

• 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.
• Integrate data from various sources, ensuring data consistency and quality.
• Design and maintain data warehouses to support business intelligence activities.
• Optimize SQL scripts/queries for speed and efficiency.
• Identify and resolve issues in ETL processes.
• Create and maintain technical documentation for ETL processes.
• Perform unit, integration, and system testing on ETL processes.
• Collaborate with cross‑functional teams to ensure successful implementation of ETL processes.
• Implement data cleansing and transformation processes to ensure data quality.
• Develop and maintain relational and dimensional data models.

Bachelor of Computer Science

$90,000 – $145,000 a year