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
Develop and maintain ETL workflows using Snowflake and AWS.
Implement data ingestion processes for AWS external file storage.
Utilize Snowpipe for automated data ingestion and processing.
Configure and maintain ETL workflows with Informatica IDMC.
Manage batch scheduling and workflow execution using Control-M.
Ensure efficient data movement between AWS and Snowflake.
Collaborate with teams to understand data requirements and ETL solutions.
Participate in Agile development activities and sprint planning.
Benefits
Opportunity to work with cutting-edge technologies like Snowflake and AWS.
Collaborative work environment with cross-functional teams.
Engagement in Agile development practices.
Professional growth opportunities in data engineering.
Access to advanced tools and methodologies in ETL development.
Full Job Description
Job Summary: We are seeking an ETL Developer with hands-on development experience in Snowflake and AWS. The role focuses on developing and maintaining data ingestion and integration workflows, 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, Informatica Intelligent Data Management Cloud (IDMC), and Control-M for batch scheduling, along with experience working in Jira/Agile environments.
Key Responsibilities: • Develop and maintain ETL workflows using Snowflake and AWS. • Implement data ingestion processes 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, configure, 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 implement appropriate ETL 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.