KGS | MC | K-Tech | SSIS
INDIA IT development
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