5-7 years of hands-on development experience with Snowflake and AWS.
Proven ability to land data in AWS external file storage before loading into Snowflake.
Strong expertise in Snowflake-native tools, especially Snowpipe.
Experience with Informatica Intelligent Data Management Cloud (IDMC) for ETL processes.
Proficient in using Control-M for batch scheduling and workflow management.
Familiarity with Jira and Agile methodologies.
Responsibilities
Design, develop, and maintain data solutions leveraging Snowflake and AWS.
Implement data ingestion workflows to transfer data to AWS external file storage and Snowflake.
Utilize Snowpipe for automated data ingestion and processing.
Develop and maintain ETL workflows using Informatica IDMC.
Configure and manage batch scheduling with Control-M.
Ensure efficient and scalable data movement between AWS and Snowflake.
Collaborate with cross-functional teams to gather data requirements and deliver solutions.
Participate in Agile development activities, including sprint planning and project tracking.
Benefits
Opportunity to work with cutting-edge technologies in data architecture.
Collaborative work environment with cross-functional teams.
Engagement in Agile development practices.
Professional growth opportunities in a rapidly evolving field.
Full Job Description
Job Summary: We are seeking a Data Architect with hands-on development experience in Snowflake and AWS. The role focuses on designing and implementing data ingestion and integration solutions, landing data in AWS external file storage before loading it into Snowflake. The ideal candidate will have strong expertise in Snowflake-native tools, including Snowpipe, IDMC for ETL, Control-M for batch scheduling, and experience working in Jira/Agile environments.
Key Responsibilities: • Design, develop, and maintain data solutions using Snowflake and AWS. • Implement data ingestion workflows to land data in AWS external file storage before transferring and loading it into Snowflake. • Utilize Snowflake-native tools, including Snowpipe, for automated data ingestion and processing. • Develop and maintain ETL workflows using Informatica Intelligent Data Management Cloud (IDMC). • Configure and manage batch scheduling and workflow execution using Control-M. • Ensure efficient, reliable, and scalable data movement between AWS and Snowflake. • Collaborate with cross-functional teams to understand data requirements and deliver appropriate data solutions. • Participate in Agile development activities, sprint planning, and project tracking using Jira.
Required Qualifications: • Hands-on development experience with Snowflake and AWS. • Experience landing data in AWS external file storage and subsequently loading it into Snowflake. • Strong knowledge of Snowflake-native data ingestion tools, particularly Snowpipe. • Hands-on experience with Informatica Intelligent Data Management Cloud (IDMC) as an ETL tool. • Experience with Control-M for batch scheduling and workflow management. • Familiarity with Jira and Agile methodologies.