Description

You will design, develop, and maintain ETL processes to move data from source to target systems.

Responsibilities

• Design and develop ETL workflows, graphs, and mappings to process and transform data.
• Create and implement logic for extracting, transforming, cleansing, and loading data into data warehouses or data lakes.
• Optimize ETL jobs for performance and scalability within Very Large Database (VLDB) environments exceeding 20TB.
• Identify and resolve data quality issues, ETL job failures, and performance bottlenecks.
• Develop test scenarios and execute functional testing to ensure data consistency and accuracy.
• Maintain technical documentation for ETL designs, artifacts, and environments.

Required Skills

• 2-3 years of experience with AbInitio or Informatica.
• Strong proficiency in SQL and Oracle.
• Experience working in Linux/Unix environments.
• Hands-on experience with shell scripting.
• Proven experience with Very Large Database (VLDB) and Data Warehouse implementations (20+ TBs).
• Ability to work with data models to ensure appropriate structure for target systems.
• 5+ years of overall professional experience.
• Bachelor's degree or equivalent graduation.

Key Skills

Education

Any Graduate