Senior IT Technologist - Snowflake

Job Description:

Responsibilities

• Design, develop, and optimize ETL workflows using Informatica PowerCenter to ingest and process data from SAP and other enterprise systems.
• Perform advanced data extraction from SAP modules such as APO, R/3, and GTS, ensuring high data quality and performance.
• Maintain and support existing ETL pipelines running on Oracle backends, ensuring availability and minimal downtime.
• Drive and support the transition to Databricks, modernizing ETL pipelines and contributing to architecture evolution.
• Collaborate with business stakeholders, data architects, and BI developers to define data requirements and deliver scalable data solutions.
• Implement and monitor job scheduling using Tivoli and Airflow.
• Troubleshoot and optimize Unix shell scripts involved in data movement and job orchestration.
• Ensure compliance with data governance, quality, and security policies.

Expeirence

• 7+ years of IT experience with a bachelor’s degree in Engineering, MCA, or MSc.
• ETL Tools: Informatica PowerCenter (advanced)
• 4+ years experience in snowflake and IICS.
• Databases: Oracle (strong SQL), basic understanding of Delta Lake (Databricks)
• Cloud/Data Platforms: Databricks (preferred or willingness to learn)
• SAP: Strong understanding of SAP APO, R/3, and GTS data structures
• Scheduling Tools: Tivoli Job Scheduler, Airflow
• Scripting: Basic Unix shell scripting