KGS | MC | K-Tech | SSIS

Job description

Roles and Responsibilities

• Work with Tech lead to design solutions based on Business requirements

• Develop and test SQL and Stored procedures code utilizing SQL Server 2016

• Develop and test ETL packages utilizing SSIS

• Create and text SQL Agent jobs

• Optimize performance of sql queries

Qualifications and Skills

• Extensive hands on Application development experience with one of Databases (MS SQL Server, Oracle, DB2, etc). Microsoft SQL Server is preferred.

• Experience with developing complicated SQL, stored procedures etc.

• SSIS ETL experience

• Cube building using SSAS and Report Generation using SSRS.

• Clear understanding of Data Warehousing concepts. Work experience building Data Warehouses is a plus

• Data sourcing experience, including data error handling and data quality is a plus.

• Strong analytical skills.

• Working Knowledge on Alteryx is good to have.

Experience and Background


• Good to have understanding of Collibra for Data governance.

Education / professional qualifications

- Degree in IT (Management Information Systems) s), Engineering or MBA

- Candidates with certifications in Database, Business Intelligence or Data Analytical will be a great addition

Education / professional qualifications:

Prior Experience:

- 2-4 years of experience in relevant technologies mentioned