Activesoft - Charlotte, NC

posted 3 months ago

Full-time
Charlotte, NC

About the position

We are seeking an experienced ETL Developer with expertise in Informatica Intelligent Cloud Services (IICS) and Informatica Data Management Cloud (IDMC) to join our team in Charlotte, NC. This is a hybrid position requiring in-office attendance three days a week. The ideal candidate will have a strong background in ETL development, with a minimum of 9 years of experience in the field. The role involves designing and implementing ETL processes, understanding data models and data flows, and developing application integrations using SOAP and REST APIs. The candidate should be proficient in working with relational databases such as Oracle and SQL Server, including the ability to design and optimize complex SQL queries on large-scale data tables. In this role, you will be responsible for utilizing Informatica Cloud Services components, including Data Integration, Application Integration, Operational Insights, Data Quality, and Monitoring. You will also be involved in migrating from Informatica PowerCenter to Informatica Cloud, as well as exposing APIs using APIGee. The position requires hands-on development experience with Linux/Unix systems, including shell scripting. Additionally, experience in the banking industry and familiarity with Agile project methodologies will be considered a plus. The candidate should also have experience leading technical development teams and working with cloud integrations, particularly with Salesforce and Microsoft Dynamics CRM. This position is expected to last for 12 months, and candidates must be local to Charlotte, NC, and able to work on a W2 basis. If you are a motivated individual with a passion for ETL development and cloud technologies, we encourage you to apply.

Responsibilities

  • Design and implement ETL processes using Informatica IICS and IDMC.
  • Develop application integrations using SOAP and REST APIs.
  • Optimize complex SQL queries on large-scale data tables in Oracle and SQL Server.
  • Migrate ETL processes from Informatica PowerCenter to Informatica Cloud.
  • Expose APIs using APIGee for system integrations.
  • Utilize Informatica Cloud Services components such as Data Integration and Data Quality.
  • Collaborate with technical teams to lead development efforts and ensure project success.

Requirements

  • 9+ years of ETL development experience.
  • 3+ years of development experience with Informatica PowerCenter and IICS/IDMC.
  • Experience in designing and implementing ETL processes.
  • Strong understanding of data models and data flows.
  • Proficient in developing application integrations using SOAP/REST APIs.
  • Hands-on experience with relational databases (Oracle/SQL Server).
  • Experience with Linux/Unix systems and shell scripting.
  • Familiarity with Informatica PowerCenter to Informatica Cloud migration.

Nice-to-haves

  • Banking industry experience.
  • Experience with Agile project methodologies.
  • Experience leading technical development teams.
  • Experience with cloud integrations, preferably with Salesforce and Microsoft Dynamics CRM.
  • Working experience with Autosys.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service