Build a Trustworthy Workforce Who can take you to the top

Developing trust within the workforce is always discussed by the top level management in an enterprise.

read more

SCTL-2017/TECH019

Position Name

:

DATABASE SCIENTIST – MS SQL (My SQL, SQL Server)

Job Code

:

SCTL-2017/TECH019

Experience

:

4 - 7 Years

Job Location

:

Bhubaneswar

Job Description

    Roles & Responsibility:
  • Data Scientist Job Responsibilities:
  • Designing and implementing processes and layouts for complex, large-scale data sets used for development, modeling, data mining, and research purposes. He/she will be also responsible for business case development, planning, coordination/collaboration with various internal and vendor teams, project managing the lifecycle of an analysis project, and interface with business sponsors to provide periodic updates.
  • Data Scientist Job Duties:
  • Develop and plan required analytic projects in response to business needs.
  • In conjunction with data owners and department managers, contribute to the development of data models and protocols for mining production databases.
  • Develop new analytical methods and/or tools as required.
  • Contribute to data mining architectures, modeling standards, reporting, and data analysis methodologies.
  • Conduct research and make recommendations on data mining products, services, protocols, and standards in support of procurement and development efforts.
  • Work with application developers to extract data relevant for analysis.
  • Collaborate with unit managers, end users, development staff, and other stakeholders to integrate data mining results with existing systems.
  • Provide and apply quality assurance best practices for data mining/analysis services.
  • Adhere to change control and testing processes for modifications to analytical models.
  • Create data definitions for new database file/table development and/or changes to existing ones as needed for analysis.
  • Determine required network components to ensure data access, as well as data consistency and integrity.
  • Respond to and resolve data mining performance issues. Monitor data mining system performance and implement efficiency improvements.
  • Self-driven and ability to work with minimal direction and in a team to research innovative solutions to challenging business/technical problems.
  • Must be flexible and able to handle multiple projects simultaneously.
  • Able to work effectively with customers, and technical staff in analyzing situations and resolving issues. Must be able to work both independently and as part of a team.
  • Domain Knowledge on Human Resource Management/ Asset Management System/ Financial Management System/ Customer Relationship Management System/ E-commerce is added advantage. • Data Scientist Skills and Qualifications:
  • Knowledge of Data Management using SQL Server.
  • Good hands on experience on Databases, deep understanding of Database Structures, best practices.
  • Expert in SQL Server CRUD operations and in aggregation framework.
  • Excellent Communication skills / Abilities to interact with the client directly.
  • Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log issues, connectivity issues, security issues etc.
  • Good knowledge on IT Infrastructure solutions development.
  • Domain Knowledge on Human Resource Management/ Asset Management System/ Financial Management System/ Customer Relationship Management System/ E-commerce is added advantage.

Key Skills:

  • Data Analysis & Normalization, Data modeling & database design, Data Integrity, Procedural skills, & Storage management techniques.

Desired Profile:

  • Designation: DATABASE SCIENTIST - SQL (My SQL, SQL Server)

Preferred Skills:

  • Self-driven and ability to work with minimal direction and in a team to research innovative solutions to challenging business/technical problems.
  • Must be flexible and able to handle multiple projects simultaneously.
  • Able to work effectively with customers, and technical staff in analyzing situations and resolving issues. Must be able to work both independently and as part of a team.
  • Domain Knowledge on Human Resource Management/ Asset Management System/ Financial Management System/ Customer Relationship Management System/ E-commerce is added advantage.

Mandatory Skills:

  • Importing, cleaning, transforming, validating or modeling data with the purpose of understanding or making conclusions from the data for decision making purposes.
  • Presenting data in charts, graphs, tables, designing and developing relational databases for collecting data and in some organizations it also includes building or designing data input or data collection screens.
  • Write Data Definition Language or Data Manipulation Language SQL commands, be responsible for improving data quality and for designing or presenting conclusions gained from analyzing data using statistical tools.
  • Should have knowledge in technology, information management, relational database design and development, business intelligence, data mining or statistics.

Personal Traits:

  • Excellent written and oral communication skills.
  • Excellent problem solving skills..
  • Should be excellent in Time Management, Planning Skills & Organizing Skills.
  • Should be a team player.

Education & Experiences:

  • B.E/ B.Tech /MCA & above or equivalent.
  • Minimum 04-07 years and above in software development related experience.
  • Equivalent combination of education and experience.
Apply Now