ETL Developer

Horizontal Talent - Eagan, MN

Full-time

Eagan, MN

About the position

The position involves designing, developing, and maintaining scalable data pipelines using SnapLogic, ensuring seamless data integration and exchange with external systems. The role requires collaboration with cross-functional teams to gather requirements and deliver optimized data solutions while maintaining data quality and integrity throughout the data life cycle.

Responsibilities

• Design, develop, and maintain scalable data pipelines using SnapLogic.
• Implement integration solutions for seamless data exchange with external systems and trading partners.
• Collaborate with cross-functional teams to gather requirements and deliver optimized data solutions.
• Troubleshoot, optimize, and ensure the performance, scalability, and reliability of the data pipelines.
• Maintain data quality and integrity throughout the data life cycle.
• Model, design, and maintain a database including table structures, stored procedures, views, and functions.
• Streamline the existing data processes and new requirements for various projects to ensure that the approach delivers the best value for the organization.
• Assure quality, security and compliance requirements are met for supported projects.

Requirements

• Minimum of 6 years of experience with SnapLogic in building data integration pipelines.
• Strong understanding of ETL processes, data transformation, and data quality management.
• Proficiency in Snap Logic components, snaps, pipelines, transformations, and API integrations.
• Experience with JSON, XML, REST API, and authentication protocols.
• Strong problem-solving, troubleshooting, and documentation skills.
• Excellent communication skills and ability to work with cross-functional teams.
• Experience in full stack development using AWS, Java, Python etc.
• Good experience in advanced PL/SQL.
• Exposure to Unix and shell scripting.