Note: The job is a remote job and is open to candidates in USA. JPS Tech Solutions is seeking a mid-level Informatica ETL Developer / Administrator to support the migration of ETL workflows from Informatica PowerCenter to Informatica Intelligent Data Management Cloud (IDMC). The role focuses on ETL migration, Informatica administration, Oracle database and stored-procedure support, testing, troubleshooting, documentation, and knowledge transfer.
Responsibilities
- Support migration of ETL workflows from PowerCenter to IDMC
- Analyze existing mappings and workflows to support rebuild or refactor in IDMC
- Assist with testing, validation, and troubleshooting of migrated workflows
- Support cutover and post-migration stabilization activities
- Support IDMC environment configuration and operations
- Perform system configuration activities to support hybrid legacy configuration
- Assist with job scheduling, monitoring, and error resolution
- Follow established operational procedures and escalation paths
- Support Oracle databases used by ETL and reporting systems
- Assist with analysis and troubleshooting of SQL and stored procedures
- Validate data transformations and outputs, particularly for Accountability Frameworks
- Contribute to migration and configuration documentation
- Document changes made during migration to support operational continuity
- Participate in knowledge transfer to IMS staff as requested
- Accelerate PowerCenter to IDMC migration
- Reduce load on permanent IMS staff
- Support Oracle/stored-procedure–based Accountability Frameworks during transition
Skills
- 8+ years of hands-on Informatica ETL experience
- Experience with Informatica IDMC / Informatica Cloud or PowerCenter with migration exposure
- Experience supporting or administering Informatica environments
- Strong SQL skills with Oracle databases
- Experience working with stored procedures and database-driven logic
- Experience supporting ETL testing, validation, and issue resolution
- Experience with Linux based operating systems and command line interface
- Prior PowerCenter → IDMC migration experience
- Familiarity with cloud or hybrid execution environments
- Experience or familiarity with Linux system administration activities
- Experience supporting regulated or audit-sensitive data systems
Benefits
- Remote work arrangement
Company Overview
Company H1B Sponsorship