Job Summary: Seeking an Integration Consultant with hands-on experience in SSIS, PySpark, SQL, and Apache NiFi to support data integration, transformation, validation, and analytics initiatives. The role requires experience with the o9 platform, including its data model, table structures, and linkages, along with the ability to design effective data-loading processes and support integrated business planning and analytics use cases. Key Responsibilities: • Design, build, and deploy SSIS packages to validate, synthesize, and transform customer data for integrated business planning and analytics. • Understand the o9 platform, including its data model, table structures, linkages, and optimal designs for various planning use cases. • Review and analyze customer-provided data, including its technical and functional intent and interdependencies. • Participate in technical design and data requirements gathering activities. • Recommend best practices to address inaccurate, incomplete, or missing data. • Design and automate data-loading and insights-generation processes with appropriate checks and validations. • Create and execute test plans to validate data integration and transformation processes. • Document issues and track progress toward resolution. • Collaborate with technical and functional teams to support successful data integration and delivery. Required Qualifications: • 1+ year of hands-on experience with the o9 platform. • Strong experience with SSIS. • Strong experience with PySpark. • Strong SQL skills. • Hands-on experience with Apache NiFi. • Experience designing and implementing data integration and transformation processes. • Experience with data validation, testing, and issue resolution. • Strong understanding of data structures, data relationships, and data dependencies. • Strong analytical and problem-solving skills.