Description

Design and implement end-to-end ETL and ELT data processing pipelines within an AWS environment.

Responsibilities

• Develop data ingestion pipelines from databases and delimited files into S3.
• Build Glue mappings and maintain the Glue Data Catalog.
• Implement and manage Athena for data querying and analysis.
• Design and execute complex data transformations and loading processes.
• Optimize Informatica workflows for improved performance.

Required Skills

• 5+ years of experience in software development and data warehouse systems.
• Hands-on experience with AWS DMS, AWS Glue, and Athena.
• Strong proficiency in SQL for data analysis.
• Deep understanding of ETL/ELT processes and data warehousing concepts (ODS and Marts).
• Practical experience with AWS cloud data technologies and architecture.
• Knowledge of Big Data and cloud computing principles.

Preferred Skills

• Familiarity with AutoSys job scheduling and Master Data Management (MDM).
• Experience with Data Governance and the Insurance domain.
• Basic understanding of data visualization tools like SAS VA or Tableau.

Key Skills

Education

Any Graduate