Azure Data Factory Engineer in GeeksForLess

We are currently seeking a Sr. Data Engineer to work on a stable project (fintech, Canada)

Remote, full-time

Working Schedule: close to EST

Requirements:

• Datawarehouse Design Skills: The Focus area includes exceptional skills in data design and management
• Strong Experience with data warehousing ETL process design/development/support (Azure Data Factory, Informatica, ODI).
• ETL Process Skills: Strong Knowledge of ETL Processes and SQL Query expertise.
• Proven experience working with REST APIs and bringing data from REST APIs from multiple sources.
• Extensive experience in SQL/PLSQL, Logical SQL Queries and Performance Tuning
• Excellent understanding of star/snow-flake schema, SCDs and de-normalized operations
• Design, model, document, and guide the logical and conceptual relationship of data and database changes for BI applications.
• Experience in leading requirements gathering, gap analysis and creating user requirements documentation.
• Experience with Microsoft Analytics stack and a solid exposure to varied databases such as Snowflake, RedShift, Oracle DW etc.
• Experience working with ERP systems data such as Oracle EBS/Fusion (Purchasing, Order Management, Manufacturing and/or Financials modules).
• Experience working with agile methodologies using CI/CD techniques in a DevOps environment using Azure DevOps and Git.
• Experience with machine learning (Python, R, Azure ML, etc.) is a plus.

Responsibilities:

• Participate in the design, implementation, and support of a data warehouse and analytics platform
• Design and develop robust ETL / ELT processes, primarily using tools like Azure Data Factory (ADF) and Informatica Cloud (IICS).
• Perform proof of concepts for innovation and continuously improve and enhance the capabilities of the data analytics platform.
• Train and educate internal team members as well as partner consultants about best practices in data engineering and governance.