Senior Integration Consultant

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.

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.

Responsibilities

• 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.

Requirements

• 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.

Skills

SQL, SSIS, ETL, Data Warehousing, Data Modeling, Data Analysis