JPC-221628 - MS Sql
Job Posted: May 14, 2024 | Total views: 1

Job Description:

• Job Description

   

   

   

  Note :: Please look for experience into both MS SQL and Singlestore DB Knowledge (Formerly Memsql) mandatory for this role.

   

   

   

  MSSQL and SSIS Responsibilities :(6-8 Yrs )

   

  •             6+ years of experience with SSIS ETL  designing, developing and implementing SSIS using Microsoft Solutions (.Net)

   

  •             Experience using SSIS for ETL handling file loads ,email task, map drive , script task etc.

   

  •             SQL agent Jobs.

   

  •             7+ years of experience with Strong technical skills using SQL Server and TSQL.

   

  •             Knowledge in MSSQL metadata querying.

   

  •             Responsible for data profiling SQL and database objects tuning / optimization.

   

   

   

  Singlestore (Former MEMSQL):

   

  •             3+ Working experience in MEMSQL as a developer .

   

  •             Experience is using Toad .

   

  •             Should be well versed with SQL Objects ,querying ,debugging and data profiling in MemSQL.

   

   

   

  Others:

   

  •             Demonstrated experience working with client.

   

  •             Experience in guiding team member technically.

   

  •             Experience is gathering requirements ,provide solutioning and  efforts estimates(SDLC).

   

  •             Good understanding on data pipe lines .

   

  •             Experience in working with distributed development teams.

   

  •             .Net C# programming Knowledge awareness.

   

   

   

  Good to have not  mandatory:

   

  •             Powershell , Shell script.

   

  •             Service now incident and change management.

   

  •             Understanding of Tivoli scheduling .

About Company :
Purview is a leading Digital Cloud & Data Engineering company headquartered in Edinburgh, United Kingdom having a presence in 14 countries India (Hyderabad, Bangalore, Chennai and Pune), Poland, Germany, Finland, Netherlands, Ireland, USA, UAE, Oman, Singapore, Hong Kong, Malaysia and Australia.

We have a strong presence in UK, Europe and APEC, providing services to Captive Clients (HSBC, NatWest, Northern Trust, IDFC First Bank, Nordia Bank etc) in fully managed solutions and co-managed capacity models. Also, we support various top IT tier 1 organisations (Capgemini, Deloitte, Wipro, Virtusa, L&T, CoForge, TechM and more) to deliver solutions and workforce/resources.

Company Info: