SQL Server Developer Jobs In Noida

SQL Server Developer Jobs for a leading client In Noida

• Mandatory  SQL server, Erwin, visual studio SSDT, Azure, Jira, data warehousing, data modelling, ETL (SQL server, reporting) , XML
• Exp– 7-10 years
• Shift- evening (12.30 to 9.30)
• Primary Skills– SQL Server Developer
• Secondary Skills– Data Analyst, Data Warehousing, SQL Server developer, XML

Tools & Technologies:

• Database: 1) SQL Server 2) Oracle
• Tools: 1) Visual Studio SSDT 2) Microsoft Azure 3) JIRA 4) ERWIN
• Programming: 1) SQL
• MS SQL Server
• Datawarehousing
• Data modelling
• MSBI
• Azure
• ETL

 Jobs In Noida

Responsibilities :

1. Primarily, Responsible to analyze existing database and come up with design and development for the Data warehouse to support the business process.
2. Generally, Create a Data Mapping document after each Source to Target assignment and write the transformation rules for each field as applicable.
3. Likewise, Responsible to provide accurate metadata, which allows a full understanding of the project data components.
4. Similarily, Designing logical, physical data models and generate DDL (Data Definition Language) for creating Tables, Views, Indexes, data partitions using ERWIN tool for all new Datawarehouse projects.
5. Mandatorily, Identify the level of granularity each business module is needed and work on normalized/de-normalized table structures in dimensional modelling and created aggregate tables using data warehousing concepts according to each module/system.
6. Particularly, Use Erwin for reverse engineering to connect to an existing database to create graphical representation in the form of Entity-Relationships Diagram and elicit more information.
7. Besides, Responsible to create Data Dictionary for all the Data elements with proper Definition, type, null or not null, foreign Key and Primary Key, Business name, Technical name.
8. Necessarily, Excellent communication skills ( written and verbal )
9. Nevertheless, Should be able to work independently.
10. Firstly, Strong logical and Analysis Skill.
11. ETL Development and remediation activity.
12. Responsible to draw data from various sources including flat files, XML, SQL Server for analytical reporting.
13. Responsible for all ETL design and architecture activities Including data extraction, profiling,
14. Implement various transformations, loading, error handling, Audit and archiving data in a data warehouse with historical and delta load strategy.
15. Responsible to implement performance tuning based on the volume of data.
16. Responsible for ETL mapping and transformation logic coding including document all database schema, table names and roles.
17. Coordinate with the users and facilitate the user acceptance testing Responsible for executing the test cycles and data availability.
18. Responsible to enter, update, and close defects/change requests in JIRA.

Jobs In Noida Helpline

Send resumes to

samjhana@bssrecruit.com,
admin@bssrecruit.com,
jobs@bssrecruit.com,
hr@bssrecruit.com,
chandana@bssrecruit.com,

Jobs-related Helpline

• • Ms.Karina – 7348829534
  • Ms.Chandra Kala – 7846875473
  • Ms.Samjhana 76248 96763

Recruitment Consultancy in Bangalore

Tagged as: SQL, SQL Server Developer, SQL Server Developer Jobs In Noida