ITONICS Integration Engineer

ITONICS Integration and Data Migration Engineer with 6–7 years of experience in enterprise integrations, backend development, and data migration. Skilled in API integration, ETL, data transformation, validation, reconciliation, and production cutover, with experience migrating data from Java-based applications and delivering scalable, reliable integration solutions.
Key Responsibilities:
• Assess the iPipe Java application, database, interfaces, scheduled jobs, attachments, user records, audit history, and dependent systems.
• Design the integration architecture between ITONICS and the client enterprise applications and identity services.
• Work with ITONICS to confirm supported APIs, import and export formats, authentication mechanisms, integration limits, and error-handling patterns.
• Implement single sign-on using supported SAML or OIDC standards.
• Integrate ITONICS with Active Directory, CIDM, and supported user-provisioning mechanisms.
• Define and implement user, group, and role-mapping rules with the IAM and ITONICS configuration teams.
• Develop API-based, file-based, or scheduled integrations between ITONICS and approved internal applications.
• Implement secure authentication, authorization, certificate management, secrets handling, logging, monitoring, and exception management.
• Profile source data and identify completeness, duplication, quality, relationship, attachment, and compatibility issues.
• Define source-to-target mappings for ideas, campaigns, evaluations, users, comments, status history, reference data, and attachments.
• Build and execute extraction, cleansing, transformation, loading, and migration utilities.
• Perform mock migrations and production migration cycles, including restart, rollback, and exception-handling procedures.
• Develop automated reconciliation covering record counts, key fields, relationships, attachments, and rejected records.
• Maintain migration logs, exception reports, control totals, and evidence required for business approval.
• Support historical-data archiving, backup, retrieval, retention, and legacy-application retirement activities.
• Conduct integration, migration, security, and performance testing and support production cutover and hypercare.
• Prepare interface specifications, data mapping documents, technical runbooks, deployment procedures, and operational support documentation.
Required Experience and Skills:
• Strong enterprise SaaS integration and data-migration experience.
• Experience with REST APIs, JSON, OAuth 2.0, API authentication, and secure integration patterns.
• Hands-on knowledge of SAML, OIDC, single sign-on, Active Directory, identity management, and user provisioning.
• Strong SQL and relational-database skills, including data profiling and complex extraction.
• Experience developing ETL or migration solutions using Java, Python, cloud integration services, or enterprise ETL tools.
• Experience migrating attachments, relationships, status history, audit information, and reference data.
• Ability to design automated data-quality validation, reconciliation, exception reporting, and migration controls, with knowledge of encryption, certificates, secrets management, logging, monitoring, and secure file transfer.
• Experience with integration testing, performance testing, defect resolution, production deployment, and rollback planning.
• Strong technical documentation, stakeholder coordination, and troubleshooting skills.
• Experience with ITONICS APIs, bulk imports, exports, or identity integration.
• Experience extracting data from custom Java applications and legacy relational databases.
• Experience in pharmaceutical or life-sciences technology environments.
• Familiarity with CIDM, enterprise identity governance, privacy controls, and security assessments.
• Experience with compliant archiving, records retention, legal holds, and audit evidence.
• Experience with cloud platforms, CI/CD pipelines, API gateways, and enterprise monitoring tools.
Experienced in Key Deliverables:
• Integration architecture and interface inventory
• SSO, Active Directory, CIDM, and user-provisioning integration
• Source-to-target data mapping and migration design
• Data extraction, transformation, and loading utilities
• Mock and production migration execution
• Migration reconciliation, control totals, and exception reports
• Archive and legacy-retirement implementation support
• Technical cutover, rollback, operations, and hypercare runbooks

Work arrangement
Yes