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

Auto req ID
146551BR

Contract Type
Permanent

Job Level
Associate/team member

Region
EMA

Service Line
IT Advisory

Full Time / Part Time
Full Time

Sub Region
EMA (no sub-region)

Location.
Bangalore