Job Description, Responsibilities & Requirements
About the Position
We are seeking a Senior Data Engineer specializing in SSIS and KingswaySoft to design, develop and implement integration solutions between enterprise platforms such as Dynamics 365, Salesforce, SharePoint and other SaaS/On-Premise applications. This role focuses on building robust ETL processes, optimizing data flows and ensuring seamless integration across systems.
Responsibilities
- Design and develop SSIS packages with KingswaySoft components
- Perform data migrations between enterprise platforms
- Integration of Dynamics 365 with external systems such as Salesforce and ERP
- Optimize ETL flows for large volumes of data
- Documentation of integration architectures and processes
- Troubleshoot and support integrations in production
- Collaborate with functional teams for data mapping
- Participate in gathering technical requirements
- Implementation of best practices in SSIS development
- Manage the deployment of packages in production environments
Requirements
- 3+ years of experience in data integration and ETL development
- Expertise in Microsoft SSIS including ETL package design, Control Flow and Data Flow
- Proficiency in error handling, logging, deployment and administration
- Skills in KingswaySoft SSIS Integration Toolkit, connectors and Dynamics 365 Productivity Pack
- Knowledge of Microsoft Dynamics 365 entities, data schema and Dataverse
- Familiarity with CRM, Sales and Customer Service modules
- Competency in SQL Server with advanced T-SQL, stored procedures and query optimization
- Understanding of SQL Server Agent
- Capability to diagnose complex errors in data flows and design logical integration architectures
- Flexibility to adapt to new versions and connectors while handling multiple integrations in parallel
- English proficiency at B2 level or higher
Nice to Have
- Knowledge of Azure Data Factory, Azure SQL and Azure Blob Storage
- Familiarity with Power Platform (Power Automate), Salesforce data structures and SharePoint Online
- Skills in REST APIs, JSON and C#/.NET for SSIS scripting
- Proficiency in Visual Studio/SSDT, Git and DevOps/CI/CD for SSIS
- Understanding of Postman for API testing
We Offer
- Hybrid work arrangement in Mexico
- Opportunity to work with cutting-edge technologies and tools
About the Company
EPAM Systems is a global software engineering and product development company, providing a range of services from custom software development to ongoing support and maintenance.