Description

Design and implement end-to-end ETL/ELT data processing pipelines on AWS.

This role is on-site.

Responsibilities

• Develop pipelines to ingest data from databases and delimited files into S3.
• Build Glue mappings and manage the Glue Data Catalog.
• Implement data processing using AWS DMS, Glue, and Athena.
• Execute complex data transformations and optimize Informatica for performance.
• Collaborate with business partners to design and deliver high-quality data solutions.

Required Skills

• 5+ years of experience in software development and data warehouse systems.
• Hands-on experience with AWS DMS, AWS Glue, and AWS Athena.
• Proven ability to design and implement end-to-end data processing pipelines.
• Strong proficiency in SQL for data analysis.
• Deep understanding of ETL/ELT processes and data warehousing concepts like ODS and Marts.
• Experience implementing and architecting data solutions using AWS components.
• Solid understanding of Big Data and cloud technologies.

Preferred Skills

• Familiarity with AutoSys, Master Data Management (MDM), and Data Governance.
• Knowledge of SAS VA, Tableau, or Insurance domain workflows.

Key Skills

Education

Not specified