Senior SQL Developer
Gurugram, Haryana, India
Full Time
Experienced
Company Overview
Targray is a diversified multinational commodity and specialty materials company that markets a broad range of products and solutions for high-growth energy sectors. Established in 1987 in Montreal, Canada, our organization is a leading international provider of materials for solar and energy storage companies, and one of the largest physical traders and distributors of Biodiesel fuel in North America.
Targray has operations in 11 countries and over $1B USD in annual sales. In 2019, the company made its debut appearance on the FP500, Financial Post’s ranking of the top 500 corporations in Canada by revenue.
Benefits
Diversity & Inclusion
Diversity and inclusiveness are at the heart of who we are and how we work. We are committed to fostering an environment where differences are valued, policies and practices are equitable, and our people feel a sense of belonging. We welcome and embrace the diverse experiences, abilities, backgrounds, and perspectives that make our people unique and help guide us. When people feel free to be their authentic selves at work, they bring their best and are empowered to build a better working world.
For more information about our company, please visit https://www.targray.com/#LI-Hybrid.
Targray is a diversified multinational commodity and specialty materials company that markets a broad range of products and solutions for high-growth energy sectors. Established in 1987 in Montreal, Canada, our organization is a leading international provider of materials for solar and energy storage companies, and one of the largest physical traders and distributors of Biodiesel fuel in North America.
Targray has operations in 11 countries and over $1B USD in annual sales. In 2019, the company made its debut appearance on the FP500, Financial Post’s ranking of the top 500 corporations in Canada by revenue.
- Great Place to Work® | Best Workplaces in Quebec (2020)
- Deloitte | Best Managed Companies (2019 - 2022)
- EY Canada | Quebec Entrepreneur of the Year (2016)
- HSBC | International Business Award (2012)
- Profit 100 Fastest-Growing Companies in Canada (2006, 2009)
As a part of our continued expansion, Targray requires the services of a Senior SQL Developer, to join our Risk and Data Technology Team based at our India Office Gurgaon, Haryana. The scope of this position extends to Targray applications and application infrastructure worldwide.
Responsibilities
Responsibilities
- Developing and maintaining complex SQL queries/logic for Risk calculations, data manipulation, transformation that cover SQL stored procs, queries, functions, views
- Perform physical and logical data modelling and database designs required to build the Transactional and data warehouse solution.
- Tune/optimise queries and DB objects for performance, efficient resource usage and re-usability.
- Manage, deploy the database artefacts in the different SQL Server environments.
- Building relationships and cleaning data between different systems to align the data to get accurate reports.
- Developing, debugging, and modifying the SSRS Reports/SSIS Packages used in ETL, data ingestion pipelines.
- Ability to take ownership and lead development related to key data projects in the data team
Requirements
- University degree (B.Tech./MCA) in computer science or computer application.
- Minimum of 5 years proven experience managing multiple MS SQL Server 2016 / 2017 databases and SQL development.
- Excellent analytical, troubleshooting, organizational, written, and oral skills along with a positive attitude.
- Experience and knowledge of handling large datasets, especially optimised data processing techniques in handling large volumes of data, merging aggregating data across different data sources, remote/linked data access as well as data replication.
- Advance knowledge in SQL Query optimization, writing complex SQL queries, functions, procedures, triggers, and RDBMS data modelling.
- Advance level knowledge on T-SQL, SSIS, SSRS, and stored procedures.
- Data warehouse concepts (Implementation of ETL pipelines, data integration components (SSIS)
- Adhere to timelines and quality of the assigned task.
- Strong experience in SDLC processes in developing, testing, managing, deploying and supporting complex SQL code, objects and artefacts covering SQL queries, views, functions, configurations
- Ability to work under pressure on multiple assignments
- Must have excellent English oral and written communications skills.
- Must have the ability and desire to thrive in a fast-paced, service-oriented environment.
Benefits
- A competitive remuneration plan and an excellent working environment in a growing multinational organization.
- Beautiful, spacious and modern workplace environment.
- Flexible work arrangement policy.
- Generous company-wide profit-sharing plan.
- Off-site Team Building and experiential development.
- Life Insurance and Accidental Insurance for Self.
- Free Medical Insurance for Self and Family.
- Weekly Team Lunches.
- Gym Benefits.
- Corporate Team Fun Activities.
Diversity & Inclusion
Diversity and inclusiveness are at the heart of who we are and how we work. We are committed to fostering an environment where differences are valued, policies and practices are equitable, and our people feel a sense of belonging. We welcome and embrace the diverse experiences, abilities, backgrounds, and perspectives that make our people unique and help guide us. When people feel free to be their authentic selves at work, they bring their best and are empowered to build a better working world.
For more information about our company, please visit https://www.targray.com/#LI-Hybrid.
Apply for this position
Required*