Ab Initio, Informatica, - Matillion

Introduction:

This position requires hands-on experience with Matillion (preferred) or strong expertise in Ab Initio, Informatica, or DataStage. The successful candidate will be responsible for designing, developing, and implementing ETL processes to extract, transform, and load data from various sources into data warehouses or operational systems using Matillion. They will collaborate with business analysts and data architects to understand data requirements and translate them into technical solutions.

Responsibilities:

• Design, develop, and implement ETL processes using Matillion
• Collaborate with business analysts and data architects
• Optimize ETL workflows for performance, scalability, and reliability
• Perform data validation, quality checks, and troubleshooting of ETL jobs
• Maintain documentation for ETL processes and data mappings
• Support production ETL jobs and resolve issues promptly
• Work with relational databases and write complex SQL queries

Requirements:

Required Skills:

• 3-6 years of experience in ETL development and data integration
• Hands-on experience with Matillion (preferred) or strong expertise in Ab Initio, Informatica, or DataStage
• Strong SQL skills and experience with relational databases (Oracle, SQL Server, etc.)
• Knowledge of data warehousing concepts and dimensional modeling
• Experience with scheduling tools and job monitoring
• Strong problem-solving and analytical skills

Preferred Skills:

• Familiarity with cloud platforms (AWS, Azure, or Google Cloud Platform)
• Experience with scripting languages (Python, Shell) and knowledge of big data technologies (Hadoop, Spark)