Contact us for help?

Contact with us through our representative or submit a business inquiry online.

Contact Us

Software Developer

Software Developer with Bachelor’s Degree in Computer Science, Computer Information Systems, Information Technology, or a combination of education and experience equating to the U.S. equivalent of a Bachelor’s degree in one of the aforementioned subjects.

Job Duties and Responsibilities:

  • Gathering/Understanding the requirements by constant interactions with onshore analyst and with the client architects.
  • Preparing data model, ETL mapping documents, ETL high level design documents and providing estimations based on work assignment.
  • Supporting other ETL developers, providing mentoring, technical assistance, troubleshooting and alternative development solutions.
  • Understand the business data relationships.
  • Extract source data from Oracle and Flat files using Informatica and loaded into Oracle or flat file targets.
  • Extract data from Flat files, XML/JSON files, Oracle using Informatica PowerCenter / IICS and loaded into PostgreSQL, Amazon S3 target systems.
  • Work on migration of Informatica PowerCenter objects to IICS.
  • Involves in the development of Informatica PowerCenter, IICS mappings & unit testing of mappings from end-to-end.
  • Create SCD Type 1 and Type 2 mappings to load dimension and fact tables.
  • Create Informatica mappings for initial load and delta loads. Involved in testing of Informatica mappings.
  • Fixing the invalid Mappings, Unit and Integration Testing of Informatica Sessions, Batches and the Target Data.
  • Troubleshooting the loading failure cases, including database problems.
  • Create IICS connections using cloud connectors in IICS administrator.
  • Work on Informatica Cloud - Data Synchronization, Data Replication, and mapping configuration during integration of Cloud-based applications.
  • Perform code migration using across environments like DEV, TEST, QA and PROD.
  • Create scheduling jobs using Stonebranch.
  • Involves in Stonebranch Controllers and Agents upgrade from version to
  • Involves in Qlik replicate upgrade from version November 2022 to May 2023.
  • Create Full load, CDC tasks using Qlik replicate to extract data from multiple source systems and loaded to target systems like Amazon S3, Oracle and Postgres SQL.

Skills / Knowledge required:

Environment / Technologies involved:

Informatica 10.5.3, Informatica Intelligent Cloud Services (IICS), Oracle 12c/19c, Postgres SQL, Oracle SQL Developer, Unix, Stonebranch 7.x, JIRA, ServiceNow, Qlik Replicate.

Work location is Portland, ME with required travel to client locations throughout USA.

Rite Pros is an equal opportunity employer (EOE).

Please Mail Resumes to:
Rite Pros, Inc.
565 Congress St, Suite # 305
Portland, ME 04101.