Sr Integration Consultant

Role: Sr Integration Consultant (Int 3.0,pyspark, Delta lake

Mandatory Skills

• o9 INT3.0
• PySpark
• Delta Lake
• SQL
• Data Integration & ETL
• Azure Data Lake Storage (ADLS)

Experience Required

• 8–12 years of total IT experience.
• Minimum 3+ years of hands-on experience with o9 Solutions INT3.0.
• Strong experience in PySpark-based data engineering and Delta Lake implementation.
• Experience with large-scale data integration and transformation projects.
• Immediate joiners or candidates currently serving notice period preferred.

Location

• Remote (must be flexible to travel to Bangalore whenever required).

Education

• Bachelor's or Master's degree in Engineering, Computer Science, Information Technology, Supply Chain, Operations, or a related field.

Key Responsibilities

• Design, develop, and support integrations using the o9 INT3.0 platform.
• Build scalable data pipelines using PySpark and Delta Lake.
• Develop and maintain inbound and outbound integrations between enterprise source systems and o9.
• Design and optimize ETL/ELT processes for large datasets.
• Work with Azure Data Lake (ADLS) and Delta Lake architecture to ensure reliable data storage and processing.
• Develop complex SQL queries, stored procedures, and data validation routines.
• Perform data extraction, transformation, cleansing, and loading from multiple source systems.
• Configure and monitor integration pipelines, batch jobs, and data workflows.
• Collaborate with business, functional, and technical teams to understand requirements and deliver integration solutions.
• Troubleshoot integration, performance, and data quality issues.
• Support deployment, testing, production releases, and post-go-live activities.
• Ensure adherence to data governance, security, and best practices.

Required Skills & Qualifications

• Strong hands-on experience with o9 INT3.0 Integration Framework .
• Expertise in PySpark for data transformation and processing.
• Strong knowledge of Delta Lake , including Delta tables, optimization, partitioning, and data versioning.
• Advanced SQL and data modeling skills.
• Experience with ETL/ELT design and implementation.
• Experience working with Azure Data Lake Storage (ADLS) .
• Understanding of Data Warehousing and Lakehouse architectures.
• Familiarity with Supply Chain Planning processes (Demand Planning, Supply Planning, S&OP).
• Strong debugging, troubleshooting, and problem-solving abilities.
• Excellent communication and stakeholder management skills