We are seeking a skilled ETL Developer with expertise in KingswaySoft for ETL processes and SQL for database management. The ideal candidate will have a solid background in designing, developing, and maintaining efficient data integration workflows, ensuring seamless data movement across systems. This role requires strong problem-solving abilities, analytical skills, and the ability to collaborate effectively with cross-functional teams to meet organizational data needs.

Key Responsibilities:

• ETL Development with KingswaySoft:
  • Design, implement, and manage ETL processes using KingswaySoft within SSIS (SQL Server Integration Services) to facilitate seamless data integration.
  • Develop data integration solutions to extract, transform, and load (ETL) data between various systems and databases.
  • Troubleshoot and resolve data integration issues, focusing on optimizing performance for ETL workflows.
• SQL Database Management:
  • Write, optimize, and manage complex SQL queries, stored procedures, and functions to meet data processing and reporting requirements.
  • Design and maintain database structures that support business requirements and ensure data consistency, accuracy, and security.
• Collaboration & Support:
  • Work closely with business analysts and other stakeholders to understand data requirements and deliver effective integration solutions.
  • Provide technical support for data-related issues and offer recommendations for process improvements.
  • Collaborate with cross-functional teams to integrate data-driven insights and optimize workflows.
• Documentation & Reporting:
  • Maintain detailed documentation for ETL workflows, database designs, and processes to ensure clarity and consistency.
  • Create reports and dashboards as needed using SQL queries or other BI tools.

Experience & Qualifications:

• Minimum 3-5 years of experience in ETL development using KingswaySoft and SQL.
• Strong hands-on experience with SQL Server Integration Services (SSIS) and related tools.
• Proficiency in query optimization, database design, and managing relational databases.
• Experience in data migration projects, working with complex data systems and large datasets.

Preferred Qualifications:

• Experience with cloud-based systems such as Azure SQL or AWS RDS.
• Knowledge of CRM systems like Dynamics 365 or Salesforce.
• Familiarity with data visualization tools (e.g., Power BI, Tableau) is an added advantage.

This role is ideal for a proactive and detail-oriented professional who enjoys working in a fast-paced environment, resolving complex data issues, and ensuring the smooth flow of data between systems while maintaining high standards of quality and performance.