Senior Integration Consultant.
This mandate is run by SYMPHONI HR, a Mumbai-based executive search firm, est. 2003. Applications are email-verified and reach the search team running the role — confidentially, always.
About the organisation.
Our client is a prominent, fast-growing management consulting firm known for delivering high-impact business solutions. They foster a culture of innovation and professional excellence, working with diverse clients to solve complex operational challenges. The firm provides a collaborative environment where consultants are empowered to drive meaningful change through data-driven strategies.
About the role.
The Senior Integration Consultant will play a pivotal role in designing and implementing robust data integration solutions. You will bridge the gap between business requirements and technical execution by building scalable data pipelines and warehouse models. This role is ideal for a data professional who thrives in a hybrid work environment and enjoys owning the end-to-end development lifecycle.
What you will do.
- Build and maintain data crawlers to extract information from diverse customer sources using ETL platforms.
- Design and construct efficient data warehouse models within columnar databases.
- Develop and optimize complex SQL scripts for high-performance data processing.
- Design, build, and deploy SSIS packages to validate, synthesize, and transform data for business planning.
- Collaborate with Solution Architects to translate complex business requirements into technical implementations.
- Perform deep-dive data analysis to support the development of cognitive applications.
- Own the end-to-end development and implementation workflow for data integration projects.
- Automate data loading and insight generation processes with intelligent quality checks.
- Create comprehensive test plans and document technical specifications to ensure sustained value delivery.
What you bring.
- Strong proficiency in SQL with the ability to write and optimize complex queries.
- Hands-on experience in designing and deploying SSIS packages.
- Proven expertise in ETL processes and data warehousing principles.
- Solid understanding of data modeling techniques for columnar databases.
- Demonstrated ability to perform complex data analysis and troubleshoot data loading issues.
- Excellent problem-solving skills with a focus on technical documentation and best practices.
- Ability to work effectively in a hybrid model based in Bengaluru.
Other open roles.
Integration Architect — Bengaluru · Hybrid
Head of Automation — Pune · Hybrid
Data Engineering Lead — Bengaluru · Hybrid