What are the responsibilities and job description for the SnapLogic Expert with Snowflake position at Ampstek?
Job Summary:
We are seeking an experienced SnapLogic Expert with Snowflake to design, develop, and maintain robust data pipelines and integration solutions. The ideal candidate will have in-depth knowledge of SnapLogic's integration capabilities and expertise in optimizing and managing data workflows within the Snowflake ecosystem. This role involves working closely with cross-functional teams to ensure efficient data operations, high performance, and seamless integration across platforms.
Key Responsibilities:
- Data Integration and Pipeline Development:
- Design, build, and deploy SnapLogic pipelines to extract, transform, and load (ETL) data into Snowflake.
- Develop real-time and batch data integration solutions to meet business requirements.
- Ensure data accuracy, consistency, and security during the integration process.
Snowflake Management:
- Optimize Snowflake schema design, query performance, and storage.
- Implement Snowflake best practices for security, access control, and cost management.
- Monitor and troubleshoot data ingestion and processing issues in Snowflake.
Solution Architecture:
- Collaborate with data architects and business analysts to design scalable integration solutions.
- Define integration standards, patterns, and best practices for SnapLogic and Snowflake.
Automation and Performance Optimization:
- Automate recurring data workflows and optimize ETL processes for efficiency.
- Conduct performance tuning of SnapLogic pipelines and Snowflake queries.
Collaboration and Communication:
- Work with stakeholders to gather requirements and translate them into technical solutions.
- Provide support and training to team members on SnapLogic and Snowflake functionalities.
Documentation and Reporting:
- Maintain detailed documentation of integration processes, pipelines, and configurations.
- Generate reports and dashboards for monitoring data pipeline performance.
Required Skills and Qualifications:
Technical Expertise:
- 3 years of experience with SnapLogic, including building complex pipelines.
- Strong hands-on experience with Snowflake, including data modeling, performance optimization, and administration.
- Proficiency in SQL, data warehousing concepts, and ETL processes.
- Experience integrating Snowflake with various source systems and APIs.
Analytical Skills:
- Strong problem-solving skills to identify and resolve data issues.
- Ability to analyze complex requirements and develop efficient solutions.
Other Tools and Technologies:
- Familiarity with cloud platforms such as AWS, Azure, or Google Cloud.
- Knowledge of scripting languages (e.g., Python, JavaScript) for automation and advanced data manipulation.
- Experience with version control systems like Git.
Soft Skills:
- Strong communication skills to interact with technical and non-technical stakeholders.
- Ability to work in an agile environment and manage multiple priorities.
Preferred Qualifications:
- Experience with other ETL tools (e.g., Informatica, Talen
