Description

Key Skills: Data Warehousing, SQL, AWS, AWS Cloud Computing, NoSQL, Dimensional Modeling, Star Schema, Snowflake Schema, ETL, ELT, Informatica, AWS RDS, EC2, AWS Lambda, AWS Step Functions, S3, Data Modeling, Database Optimization, Workflow Orchestration

Roles & 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
• Support efficient database design and optimization for enterprise data warehouse environments
• Configure and optimize AWS RDS databases for performance and scalability
• Manage EC2 instances and support cloud infrastructure activities
• Develop serverless data workflows using AWS Lambda and Step Functions
• Handle S3 data push/pull operations and cloud-based data integration processes
• Support workflow orchestration, scheduling, and automation of data pipelines
• Work with structured and NoSQL data environments to support analytics and reporting needs
• Troubleshoot data pipeline, database, and cloud infrastructure issues
• Collaborate with cross-functional teams to ensure data quality, reliability, and scalability

Experience Required:

• 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
• Strong analytical, debugging, and problem-solving skills

Education: Any Graduation

Key Skills

Education

Any Graduate