Description

Manage ELT pipelines for sales, finance, and commissions domains using WhereScape RED, Snowflake, and AWS.

This role is on-site.

Responsibilities

• Design and implement ELT pipelines to extract data from SQL Server and CSV files into Snowflake on AWS.
• Build near-real-time data processing pipelines from transactional systems into Snowflake.
• Optimize existing ELT jobs to improve performance and modify processes for business logic changes.
• Own production support, including bug fixes, ticket resolution, production reruns, and troubleshooting data lineage queries.
• Collaborate with architects to implement data quality, access, and security principles while maintaining design documents and SOPs.

Required Skills

• 5+ years of professional experience in data engineering.
• 3+ years of hands-on experience with WhereScape RED ELT tool.
• 3+ years of experience with Snowflake, including DDL, DML, and stored procedures.
• Experience with Pebble scripting within the WhereScape RED environment.
• Proficiency in data orchestration and pipeline automation using WhereScape RED.
• Experience working with SQL Server and AWS cloud environments.
• Ability to manage release management and change approval processes.

Key Skills

Education

Any Gradute