Description

You will act as an ELT Engineer managing data extraction, loading, and transformation processes across sales, finance, and commissions domains.

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 to accommodate 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