KingswaySoft/SQL Developer (3-5 yrs)

KingswaySoft + SQL Developer

Experience : 3+ Years

Location : Remote

Shift Timings : 1 PM-10 PM IST

Job Description :

Requirements :

- KingswaySoft mandatory.

- 3-5 years of experience in KingswaySoft for ETL development and SQL database management.

- Proficiency in SSIS, SQL query optimization, and relational database design.

- Strong problem-solving skills and a collaborative mindset.

- Bonus : Experience with Azure SQL, Dynamics 365, or data visualization tools like Power BI.

Key Responsibilities :

ETL Development using KingswaySoft :

- Design, implement, and manage ETL processes using KingswaySoft within SSIS (SQL Server Integration Services).

- Develop data integration solutions to extract, transform, and load data between diverse systems and databases.

- Troubleshoot and resolve data integration issues, optimizing performance for ETL workflows.

SQL Database Management :

- Write, optimize, and manage complex SQL queries, stored procedures, and functions.

- Design and maintain database structures to support business requirements.

- Ensure data accuracy, consistency, and security across systems.

Collaboration and Support :

- Work closely with business analysts and other stakeholders to understand data requirements.

- Provide technical support for data-related issues and recommend improvements.

- Collaborate with cross-functional teams to integrate data-driven insights into workflows.

Documentation and Reporting :

- Maintain detailed documentation for ETL workflows, database designs, and processes.

- Create reports and dashboards as needed using SQL queries or other BI tools.

Qualifications and Skills :

Technical Expertise :

- Proficiency in KingswaySoft for ETL development.

- Advanced knowledge of SQL, including query optimization and database design.

- Experience with SSIS (SQL Server Integration Services).

- Familiarity with other ETL tools or frameworks is a plus.

Experience :

- Minimum of 3-5 years of experience in ETL development using KingswaySoft and SQL.

- Hands-on experience in managing relational databases and data migration projects.

Preferred Qualifications :

- Experience with cloud-based systems like Azure SQL or AWS RDS.

- Knowledge of CRM systems such as Dynamics 365 or Salesforce.

- Familiarity with data visualization tools (e., Power BI, Tableau) is an added advantage.