Description

You will design and develop scalable ETL/ELT pipelines using Informatica and AWS services to support enterprise data warehousing.

This role is on-site.

Responsibilities

• Design and develop scalable ETL/ELT pipelines using Informatica and AWS services.
• Perform data extraction, transformation, and analysis using complex SQL queries.
• Collaborate on data modeling initiatives including dimensional modeling, star schema, and snowflake schema design.
• Configure and optimize AWS RDS databases for performance and scalability.
• Develop serverless data workflows using AWS Lambda and Step Functions.

Required Skills

• 6 to 8 years of experience in Data Warehousing, SQL, and AWS Cloud technologies.
• Strong hands-on experience with ETL/ELT development using Informatica.
• Good understanding of dimensional modeling, star schema, and snowflake schema concepts.
• Experience with AWS services including RDS, EC2, Lambda, Step Functions, and S3.
• Knowledge of NoSQL databases and cloud-based data architecture.
• Ability to troubleshoot data pipeline, database, and cloud infrastructure issues.
• Experience with workflow orchestration, scheduling, and automation of data pipelines.

Preferred Skills

• Experience supporting cloud infrastructure activities on EC2 instances.
• Strong analytical, debugging, and problem-solving skills.

Key Skills

Education

Any Graduate