Experience 4- 8 Years
Bachelor’s degree in computer science or computer engineering or equivalent;
4+ years of experience working with MS SSIS to design, develop and troubleshoot data integration processes;
Strong development experience with MS SQL;
Strong understanding of relational and dimensional data modelling;
Excellent knowledge and experience with Data Warehouse and Operational Datastore concepts, ETL strategies and best practices;
Strong analytical skills;
Strong understanding of RESTful APIs;
Very good knowledge of Microsoft BI stack (SQL, SSIS, SSRS, Power Platform);
Good experience with Power BI and DAX queries;
Knowledge or experience with Agile methodology and tool (Azure devops);
Good interpersonal and communication skills at the business and technical levels;
Flexibility in organizing work;
Resourcefulness in problem-solving;
Experience with Azure Data Factory (an asset);
Deep Experience of SQL,PL / SQL technologies preferably on MS SQL database
Hands-on experience in building and supporting enterprise data warehouses
Has good knowledge of DW architectural principles
Understand integration Architecture and Design patterns, designing and developing high quality implementations while adhering to the best practices and guidelines communicated by the project.
Design, develop, debug, deploy and maintain integration processes between applications across cloud and/or on premise using SQL and various ETL tools
Develop multi source integration processes across data sources like Salesforce, NetSuite, MS Dynamics and others using cloud based and desktop based tools
Define process interfaces, data models, and integration points across disparate, complex cloud applications.
Perform development, scripting updates, data preparation, target schema and related processes as required for data loads.
Develop and execute quality assurance System Testing/Validation tasks with troubleshooting
Proactively propose and implement process improvements and automation to enhance team effectiveness and efficiency, thus increasing efficiency and process quality.
Identify recurring issues, propose solutions and contribute to the knowledge base.
Developing features from idea to implementation.
Working with stakeholders to help refine requirements and develop to those requirements.
End to end project implementation and delivery.
Work with new technologies and multiple ETL tools.