Senior ETL Developer

Job Description

Description

Role - Senior ETL Developer

Location - Pune, India

About Optimas:

Optimas is a global distributor of integrated supply chain solutions, and engineering support focused on delivering fasteners, components, industrial and safety supplies to our diverse customers around the world. Our local, on-the-ground teams understand the nuances of every community we serve. This allows us to adapt with our customers and partners as needs evolve, leveraging our footprint to remain at your side while providing a highly personalized level of service and support no matter where you find yourself around the globe.

To learn more, please visit our website http://www.optimas.com/

Main responsibilities:

• Develop and maintain Optimas data warehouse and data integration solutions.
• Write clean, scalable code using SQL.
• Manage the orchestration and optimisation of ETL routines and solutions.
• Participate in requirements analysis.
• Collaborate with internal teams to produce ETL solution design and robust data architecture.
• Test and deploy ETL solutions.
• Revise, update, refactor and debug code.
• Develop documentation throughout the software development life cycle (SDLC).
• Serve as an expert on data warehouse and data integration and provide technical support.
• Support code reviews and system testing of ETL changes.
• Support the migration from on-premise to cloud data warehouse solutions.
• Work with the Optimas Business Intelligence team to provide agile and robust data reporting solutions.

Required Skills & Experience:

• BS degree. Information Systems/Technology is a plus.
• 5+ years’ experience with MSSQL and SSIS development.
• Significant experience with MSSQL Replication.
• Significant experience with Boomi ETL solutions.
• Experience with NetSuite ERP integration is a plus.
• Some exposure to MSSQL database administration is a plus.
• Experience of cloud-based data warehouse solutions is a plus.
• Experience of Tableau reporting solutions is a plus.
• Project management, system implementation and system integration experience.
• Ability to work independently with limited guidance in addition to working collaboratively with cross-functional teams that work virtually or from remote offices.
• Knowledges of GitLab repository administration and CI/CD configuration is a plus.
• Strong analytical, problem-solving and communication skills.
• Attitude & work ethic adaptable to change in a fast-paced work environment.

Requirements