SSIS Developer - Software IT Engineer

Job Description

Overview

About Clean Harbors:

Clean Harbors Inc. (www.cleanharbors.com) is a NYSE listed US based $4.8 billion company. Clean Harbors was founded in 1980 near Boston by Mr. Alan S. McKim, who today remains the company’s Chairman and CEO.

Everywhere industry meets environment, Clean Harbors is on-site, providing premier environmental, energy and industrial services. Clean Harbors employs a dedicated workforce of 25,000 employees and has over 450 service locations across the U.S., Canada and Mexico. Beyond addressing the environmental needs of its more than 300,000 customers, the Company has been on the front lines of addressing some of the largest emergency response events in North America of the past several decades including the BP Oil Spill in the Gulf of Mexico, the anthrax attacks in New York, the 2015 avian flu outbreak that devastated the poultry industry, Hurricanes Katrina, Rita and Sandy, and the oil pipeline breaks that affected the Yellowstone and Kalamazoo rivers, along with other major chemical releases into the environment.

Clean Harbors India has been strategically established as the Global Capability Center (GCC) to serve our parent company. We take pride in serving some of the most tech savvy business stakeholders at Clean Harbors. The GCC employees form part of our globally integrated teams that provide cutting-edge IT solutions and production support across platforms. Our shared services teams work seamlessly with their global counterparts in providing critical 24x7 support in various functions including Finance, HR, Procurement, IT and Operations. Our aggressive growth plans open significant career advancement opportunities for our employees.

​​​​​​​We are operating from Skyview, Hitech City Hyderabad (http://www.theskyview.in/) And Smartworks Baner, Pune and Bangalore. Clean Harbors has substantially invested in the GCC to support its growth plans. The Company is celebrating its 43rd anniversary and is counting on the GCC to be a part of extending that track record of success.

Title: SSIS Developer

Experience: 5 to 9 Years

Location: Hyderabad - Hybrid 

Working Hours: 12.00pm to 9.00pm

Must have skills: SQL, SSIS, Power BI

• Must have 4 -8 years of experience in Designing database objects.
• Good Hands-on T-Sql.
• Design & deploy ETL, ELT jobs to curate, transform and aggregate data to create source models for end user analytics use cases.
• Design, deploy and maintenance of the SSIS packages with Task Factory components.
• Collaborate with business stakeholders to identify and meet data requirements.
• Experience with SQL server with different versions (2012,2017)
• Expert level in ETL development using SSIS.
• Expert level in Task Factory components for SSIS.
• Good to have working knowledge with DTS package.
• Good experience with Data warehousing
• Proficiency in SQL Server database and skills in one or more languages like SQL, T-SQL with knowledge of DDL, DML, stored procedures, triggers and performance tuning Strong experience in Design and develop SSIS/SSRS package and solutions and working knowledge with DTS package.
• Should be able to analyze and understand complex data.
• Familiarity with workflows in programming concepts
• Bug Fixing and Maintenance activities for existing ETL packages.
• Working knowledge and have exposure working complex SQLs on SQL Server Eg UDFS, Stored Procedures, SQL Agent Jobs Working knowledge on transformations in Azure Data factory pipelines.
• Working knowledge on how to execute SSIS packages through Azure Data factory pipelines.
• Working knowledge on SSIS packages and different transformations on Dataflow Working knowledge on Migrate SQL Server Integration Services packages to an Azure SQL Managed Instance.

Join our team today!  To learn more about our company, and to apply online for this exciting opportunity, visit us at www.cleanharbors.com/careers

Clean Harbors is the leading provider of environmental, energy and industrial services throughout the United States, Canada, Mexico, and Puerto Rico.  Everywhere industry meets environment, Clean Harbors is one-site, providing premier environmental, energy and industrial services. We are solving tough problems through innovation and proven methodology – come be part of the solution with us.

We thank all those interested in joining the Clean Harbors team; however only those that complete the online application and meet the minimum job qualifications will be considered for this role.