Integration Architect

As an Integration Architect, you will play a pivotal role in designing and deploying robust data integration frameworks. You will work closely with solution architects to translate complex business requirements into scalable technical solutions, ensuring seamless data flow and high-performance analytics. This role offers the opportunity to own the end-to-end development lifecycle in a hybrid work environment based in Bengaluru.

Our client is a prominent consulting firm known for delivering high-impact business solutions and strategic advisory services. They operate on a global scale, helping organizations navigate complex digital transformations and data-driven decision-making. The firm fosters a culture of innovation, continuous learning, and professional excellence.

Responsibilities

• Build and maintain data crawlers to extract information from diverse customer data sources using ETL platforms.
• Design and implement data warehouse models specifically optimized for columnar databases.
• Develop and optimize complex SQL scripts, stored procedures, and triggers to ensure efficient data processing.
• Design, build, and deploy SSIS packages to validate, synthesize, and transform data for business planning.
• Collaborate with solution architects to understand business needs and implement technical specifications.
• Perform deep-dive data analysis for complex use cases and document technical requirements for cognitive applications.
• Own the entire development and implementation workflow, from design to deployment.
• Automate data loading and insights generation processes with intelligent checks and balances.
• Create and execute comprehensive test plans to ensure data integrity and track issue resolution.

Requirements

• Mandatory proficiency in O9 and INT 3 platforms.
• Strong hands-on experience with Pyspark and end-to-end ETL processes.
• Expertise in SQL Server and MySQL, including advanced knowledge of MDX and T-SQL.
• Solid understanding of DDL, DML, stored procedures, triggers, and database performance tuning.
• Proven experience working with columnar databases.
• Familiarity with programming concepts and workflow automation.
• Excellent communication and presentation skills with experience in direct client interaction.
• Ability to work effectively in a hybrid model based in Bengaluru.