Sr Data Engineer

Coimbatore, India

Full Time Senior-level / Expert USD 58K - 109K * ^est.

Fulcrum Digital

Fulcrum Digital is at the forefront of digital transformation services, offering advanced digital engineering and acceleration solutions to drive business growth

View all jobs at Fulcrum Digital

Apply now Apply later

Posted 11 hours ago

Who are we
Fulcrum Digital is an agile and next-generation digital accelerating company providing digital transformation and technology services right from ideation to implementation. These services have applicability across a variety of industries, including banking & financial services, insurance, retail, higher education, food, healthcare, and manufacturing.

Key Skills: Azure Data Analytics, Azure Data Factory, Synapse, Data Lake Gen2, CICD, DevOps. SQL Server DB, SQL Server Data Warehouse

Role & Responsibilities:

Develop and optimize complex SQL queries in Oracle and SQL Server to ensure efficient data retrieval.
Improve query performance using indexing, partitioning, materialized views, and query rewriting techniques.
Identify and resolve performance bottlenecks in SQL queries, ensuring optimal execution plans.
Develop and optimize data models to support analytical and operational reporting.
Ensure best practices for normalization and denormalization.
Perform query execution plan analysis to reduce resource consumption.
Work closely with data architects, business analysts, and reporting teams to define requirements.
Provide technical guidance on SQL best practices, indexing strategies, and performance tuning.
Conduct knowledge transfer sessions to upskill teams in SQL optimization and DSS best practices.
Ensure data security by implementing role-based access control (RBAC) and encryption