JPC-2275 - DB Developer
Job Posted: May 14, 2024 | Total views: 1

Job Description:

• Job Description

   

   

   

   

   

   

   

   

   

   

   

   

   

   

   

   

   

   

   

   

   

   

   

  Technical Experience:

   

   

   

   

   

   

   

  ·         Good in understanding business requirement and relate it with database objects.

   

   

   

   

   

   

   

  ·         5+ Years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL objects in SQL Server 2014/2016.

   

   

   

   

   

   

   

  ·         Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML to facilitate efficient data manipulation and data consistency.

   

   

   

   

   

   

   

  ·         Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, User-defined Functions, Views and Cursors.

   

   

   

   

   

   

   

  ·         Support team in resolving T-SQL related issues.

   

   

   

   

   

   

   

  ·         Experience in importing/exporting data between different sources like CSV/Excel etc. using SSIS/DTS utility.

   

   

   

   

   

   

   

  ·         Expert in writing parameterized queries.

   

   

   

   

   

   

   

  ·         Defining data warehouse (star and snow flake schema), fact table.

   

   

   

   

   

   

   

  ·         Expert in analyzing, designing, developing, installing, configuring and deploying SSIS ETLs in SQL Server.

   

   

   

   

   

   

   

  ·         Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.

   

   

   

   

   

   

   

  ·         Skilled in error and event handling, precedence constraints, break points, check points and logging.

   

   

   

   

   

   

   

  ·         Experience in ETL processes involving migrations and in sync processes between two databases.

   

   

   

   

   

   

   

  ·         Transform data from one server to other servers using tools like SQL Server Integration Services, Data Transfer Wizard.

   

   

   

   

   

   

   

  ·         Experience in creating configuration files to deploy the SSIS packages across all environments.

   

   

   

   

   

   

   

  Good to have

   

   

   

   

   

   

   

  ·         JSON manipulation in SQL server.

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: