Data Engineer

at  Incepta Solutions

Incepta Solutions is an award-winning digital transformation company, Certified Great Place to Work, operating with leading-edge technologies in IT and high-tech industries to provide premier automation and integration solutions to globally recognized brands and enterprises. We modernize legacy applications and create new digital products to help our clients solve complex problems and digitally transform their operations.

REQUIRED SKILLS AND QUALIFICATIONS :

• Proven experience as a Data Engineer, with strong expertise in Azure Data Factory and Informatica (including Informatica Cloud).
• Hands-on experience in data integration with systems like Anaplan, PSM/PRM, Essbase, Exceedra, or A&PO.
• Proficiency in working with Azure Databricks, SQL Server, and building ETL/ELT workflows.
• Solid understanding of data warehousing concepts and techniques, including data modeling and schema design.
• Advanced SQL skills with the ability to write complex queries and optimize database performance.
• Familiarity with cloud platforms (Azure preferred) and tools for data integration and processing.
• Excellent problem-solving and analytical skills with attention to detail.
• Strong communication skills, with the ability to collaborate effectively with technical and non-technical stakeholders.
  Job Type: Full-time
  Work Location: Hybrid remote in Toronto, ON (M5X

• Design, develop, and maintain data pipelines and ETL/ELT workflows using Azure Data Factory, Informatica, and Informatica Cloud.
• Support data warehouse development, ensuring scalability, performance, and data integrity.
• Develop and manage integration processes for downstream systems, including Anaplan, PSM/PRM, Essbase, Exceedra, and A&PO.
• Leverage tools such as Azure Databricks, Azure Data Factory, and SQL Server Integration Services (SSIS) to implement efficient data solutions.
• Perform data modeling and ensure optimal design for data storage and retrieval in cloud and hybrid environments.
• Monitor and troubleshoot data pipelines to address issues and ensure seamless operations.
• Collaborate with business teams and stakeholders to understand data requirements and translate them into technical solutions.
• Optimize and automate processes to improve efficiency and reduce operational overhead.
• Ensure compliance with data governance standards, security policies, and best practices.