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.
- 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)
Job Summary
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
- 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.
Top Skills
What We Do
Targray is an international leader in the sourcing, transportation, storage, financing and supply of sustainable materials & commodities for the renewable fuels, solar, battery, carbon trading and agricultural commodities sectors. From solar glass and lithium-ion cells, to bio-based fuels, our material solutions help reduce the world’s carbon footprint while enabling technology providers to create more efficient, better performing products for consumers. SOLAR Targray is a major international provider of PV materials and supply chain solutions for solar manufacturers, EPCs, installers, contractors and project developers. BIOFUELS & FEEDSTOCK Supported by a dedicated rail fleet and terminal network, our Biofuels business is one of the largest suppliers of biodiesel fuel and feedstock in North America and Europe. COTTON Our sustainable cotton business connects raw cotton suppliers, traders and end users around the globe through integrated sourcing, logistics, sales and distribution activities. BATTERY MATERIALS Targray is a leading supplier to the battery manufacturing and R&D sector. The company's extensive battery materials portfolio is a trusted source for customers in over 50 countries. ENVIRONMENTAL COMMODITIES Targray’s Environmental Commodities business engages in the trading and supply of carbon credits, carbon offsets and renewable energy certificates (RECs) for compliance and voluntary carbon markets around the world. ABOUT Targray is a diversified multinational Canadian corporation founded in 1987 in Montreal, Canada, and headquartered in the nearby city of Kirkland since 2008. The company’s footprint spans the globe with offices in Switzerland, Czech Republic, Germany, Dubai, India, China, Brazil and Australia
