Data Analyst

Job Description Visa Requirement: This position is open only to candidates authorized to work in the United States under the following visa categories: H4-EAD, Green Card Holder, GC-EAD, U.S. Citizen, L2s, L2-EAD. No other visa types are eligible for this role. Job Description:  Role Summary: ·         IMS 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). ·         This role is hands-on and execution-focused, providing development, administration, and database support during migration and stabilization efforts.  ·         The contractor will primarily focus on ETL Asset/ Workflow migration. The contractor will may also assist with Oracle database and stored-procedure–based systems, including components supporting Accountability Frameworks. ·         This position works under the direction of IMS technical leads and does not include platform ownership, architecture authority, or people management. Key Responsibilities Informatica IDMC Migration: ·         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. Informatica Administration (Execution-Level): ·         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.  Database & Stored Procedure Support: ·         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.  Documentation & Knowledge Transfer:  ·         Contribute to migration and configuration documentation.  ·         Document changes made during migration to support operational continuity.  ·         Participate in knowledge transfer to IMS staff as requested.  Required Skills & Experience: ·         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.  Preferred Skills: ·         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.  Engagement Objective  Provide targeted ETL and database expertise to: ·         Accelerate PowerCenter to IDMC migration  ·         Reduce load on permanent IMS staff  ·         Support Oracle/stored-procedure–based Accountability Frameworks during transition  Apply Online Your Name * Your Phone Number * Your Email Address * Job id What is your current U.S. visa or immigration status? * SelectU.S. Citizen (USC)Lawful Permanent Resident (Green Card holder)H1BF1-OPT/Stem-OPT/CPT EADH4-EADL-2SGC-EADOther Valid Visa Where are you currently located at? * W2 or C2C * SelectW2C2C How many years of total experience do you have? * How many years of relevant experience do you have? * Do you require H1B sponsorship? * YesNo Do you require sponsorship? * NoYes – H-1B transferYes – Green Card sponsorshipYes – Both H-1B transfer and Green Card sponsorship Upload Resume * Δ Visa Requirement: This position is open only to candidates authorized to work in the United States under the following visa categories: H4-EAD, Green Card Holder, GC-EAD, U.S. Citizen, L2s, L2-EAD. No other visa types are eligible for this role. Job Description:  Role Summary: ·         IMS 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). ·         This role is hands-on and execution-focused, providing development, administration, and database support during migration and stabilization efforts.  ·         The contractor will primarily focus on ETL Asset/ Workflow migration. The contractor will may also assist with Oracle database and stored-procedure–based systems, including components supporting Accountability Frameworks. ·         This position works under the direction of IMS technical leads and does not include platform ownership, architecture authority, or people management. Key Responsibilities Informatica IDMC Migration: ·         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. Informatica Administration (Execution-Level): ·         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.  Database & Stored Procedure Support: ·         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.  Documentation & Knowledge Transfer:  ·         Contribute to migration and configuration documentation.  ·         Document changes made during migration to support operational continuity.  ·         Participate in knowledge transfer to IMS staff as requested.  Required Skills & Experience: ·         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.  Preferred Skills: ·         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.  Engagement Objective  Provide targeted ETL and database expertise to: ·         Accelerate PowerCenter to IDMC migration  ·         Reduce load on permanent IMS staff  ·         Support Oracle/stored-procedure–based Accountability Frameworks during transition  [contact-form-7 id="ac31dcc" title="Job Apply Form"]