KingswaySoft Data Integration Consultant

• Hands-on experience with KingswaySoft SSIS Integration Toolkit;
• Experience with data flows, control flows, connection managers, and package parameterization;
• Knowledge of integration with Microsoft Dynamics 365 and/or Dataverse;
• Experience with mappings, lookups, incremental loads, and upsert operations;
• Knowledge of error handling, logging, reconciliation, and performance optimization of ETL processes;
• Ability for data analysis and collaboration with functional and technical teams;

• Experience with SSIS Catalog, SQL Server Agent, and scheduling tools is valued;

• Proficiency in English, oral and written, for collaboration and technical documentation.

We are looking for a Data Integration Consultant with experience in KingswaySoft and SQL Server Integration Services (SSIS) to integrate a technological transformation project for a reference client in the energy sector.
The professional will participate in the analysis and adaptation of existing ETL processes, with a particular focus on integrations with CRM systems, ensuring data consistency, the adequacy of business rules, and the continuity of flows between applications.

• Inventory and document SSIS packages, KingswaySoft components, and dependencies between sources and destinations;
• Develop and adapt ETL flows, mappings, and data transformation and validation rules;
• Reconfigure connections, parameters, credentials, and data filters by entity or business context;
• Implement incremental loads and insert and update operations, preventing duplications;
• Ensure error handling, logging, and record reprocessing;
• Execute tests and reconciliations between systems, in coordination with the teams responsible for the CRM;
• Support deployment, production execution, stabilization, and knowledge transfer.