Choisissez votre région et votre langue

Menu

MS SQL server Data Engineer

At Hitachi Energy our purpose is advancing a sustainable​ energy future for all. We bring power to our homes, schools, hospitals and factories. Join us and work with fantastic people, while learning and developing yourself on projects that have a real impact to our communities and society. Bring your passion, bring your energy, and be part of a global team that appreciates a simple truth: Diversity + Collaboration = Great Innovation

Business Information:

Our Indian Operations Centre (INOPC) is a competence center with around 2000+ skilled engineers who focus on tendering, engineering, planning, procurement, functional system testing, installation supervision, and commissioning. Over the last decade, INOPC has evolved to become the largest engineering hub serving more than 40 countries across different energy sectors. The team caters to the four business units—Transformers, Grid Integration, Grid Automation, High Voltage and has successfully executed engineering and commissioning for projects in more than 80 countries.

Mission Statement:

Hitachi Energy, High Voltage Products is implementing Digital solutions to improve efficiency and quality. These are cloud-based solutions that will be used by all manufacturing units within the business unit.

Your responsibility:

  • Strong experience on Microsoft SQL Server and developing T-SQL (Transact SQL) Stored Procedures, Functions and Triggers, SSIS packages.

  • Skilled in writing complex SQLs/stored procedures/functions/triggers etc.

  • Skilled in optimization and query tuning of complicated SQL statements/stored procedures.

  • Experience with performance monitoring tools to identify and address bottlenecks.

  • Strong understanding of various types of Indexes, constraints,

  • Knowledge of database security best practices, including encryption, access controls, and auditing.

  • Experience in implementing security measures to protect sensitive data.

  • Understands different data models like normalized, de-normalized, stars, and snowflake models.

  • Skill in designing and implementing data integration solutions, including ETL (Extract, Transform, Load) processes.

  • Ability to design and implement scalable and highly available database architectures.

  • Knowledge of clustering, replication, and sharding techniques.

  • Living Hitachi Energy’s core values of safety and integrity, which means taking responsibility for your own actions while caring for your colleagues and the business.

Your background:

  • Degree in Software Engineering, or a related field.

  • A minimum of 5 years' experience in delivering and supporting enterprise grade applications, preferably in the manufacturing industry.

  • Strong knowledge of cloud computing and custom software development processes.

  • Proficiency in Microsoft Technology Stack like Azure Data Factory, Net Core, Azure DevOps, SQL Server / and Entity Framework. 

  • Strong track record maintaining and optimizing complex T-SQL solutions.

  • Experience with Enterprise Service Bus integrations (MuleSoft is a plus)

  • Excellent problem-solving and troubleshooting skills.

  • Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.

  • Attention to detail and a commitment to delivering high-quality digital solutions.

  • Nice to have: MuleSoft Development experience and MS SQL Server Certifications.

  • Scripting skills in languages like SQL, Python, or PowerShell for automation and routine tasks.

Lieu Chennai, Tamil Nadu, India
Type d'emploi Full time
De l'expérience Experienced
Fonction du poste IT, Telecom & Internet
Contrat Regular
Date de publication 2024-05-09
Numéro de réference R0045892
More about us

Hitachi Energy is a global technology leader that is advancing a sustainable energy future for all. We serve customers in the utility, industry and infrastructure sectors with innovative solutions and services across the value chain. Together with customers and partners, we pioneer technologies and enable the digital transformation required to accelerate the energy transition towards a carbon-neutral future. We are advancing the world’s energy system to become more sustainable, flexible and secure whilst balancing social, environmental and economic value. Hitachi Energy has a proven track record and unparalleled installed base in more than 140 countries. Headquartered in Switzerland, we employ around 40,000 people in 90 countries and generate business volumes of approximately $10 billion USD. www.hitachienergy.com