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:

• Work closely with cross-functional teams, comprising Data Engineers, Technical Architects, and
  Business Analysts to understand business requirements.
• Create/Update Data Model, Prepare Data Mapping and Technical Design documents as per
  business requirements, and obtain approval from technical architects and business analysts before
  proceeding with development.
• Implementation of Informatica PowerCenter, IDQ, and IICS mappings, tasks, rules, profiling, and
  unit testing from end to end, and provide ongoing support.
• Perform Administrative activities such as installing and configuring software, conducting system
  upgrades including patches, managing users and groups, and monitoring domain objects and logs
  using tools like Informatica, Stonebranch, and Qlik Replicate.
• Analyze and work on migration of Informatica PowerCenter objects to IICS. On Migration of
  objects make sure the functionality runs on on-premises and cloud-based systems remains same.
• Perform data profiling and collaborate with Data Stewards to identify data anomalies. Design and
  implement data quality rules and cleansing processes to correct and standardize data. Integrate
  data quality processes into ETL workflows and set up data quality monitoring alerts.
• Extract data from Flat files, XML/JSON files, Oracle using Informatica PowerCenter, Power
  Exchange, IICS and loaded into multiple target systems like PostgreSQL, Amazon S3, MS SQL
  Server.
• Integrate cloud-based and on-premises applications using IICS connectors and APIs. Develop
  Informatica Cloud solutions for cloud-based application integration, including data
  synchronization, data Replication, and mapping configuration.
• Create new connections and develop Full load and Change Data Capture (CDC) tasks utilizing
  Qlik Replicate to extract data from multiple source systems and load it into target systems such as
  Amazon S3, Oracle, and Postgres SQL.
• Perform code migration across environments like DEV, TEST, QA, and PROD, ensuring
  seamless deployment and consistency throughout the software development lifecycle.
• Create, schedule, and manage jobs using Stonebranch, ensuring timely execution and monitoring
  of critical tasks across the infrastructure.
• Perform upgrades for Stonebranch Controllers and Agents, as well as Qlik Replicate, ensuring
  minimal downtime and seamless transition.
• Implement Single Sign-On (SSO) for Stonebranch and Informatica PowerCenter, as well as
  establish a Disaster Recovery (DR) setup.
• Troubleshoot intricate issues, identify root causes and implement effective solutions to minimize
  downtime.

Work experience required for the position:

• ETL/Data Development experience in Informatica technology (Powercenter, IDQ, IDMC, IICS).
• Data migration experience with any cloud databases using IICS (Azure, AWS, GCP).
• Good working exposure in implementing end-to-end Data warehousing solutions
  using Informatica and Informatica cloud migration projects.
• Should have good understanding of IICS Data Integration service, Monitor, Application
  Integration, Administrator services.
• hould have working knowledge on IICS Mapping Tasks, Data Synchronization, Data
  Replication Tasks.
• Work closely with cross-functional teams, including data engineers, architects, and business
  analysts to understand business requirements.
• Translate business needs into technical design documents.
• Hands-on experience on Server Maintenance, Deployment, Connection creation, Access
  Management in Informatica Administrator.
• Install, configure Informatica software and Perform system upgrades, including patches.
• Troubleshooting, incident root-cause analysis with development teams and Work with vendor on
  issue resolution.
• Good knowledge of SQL - Oracle/SQL Server/Postgres SQL/AWS Redshift and Expertise in
  Linux shell scripting and/or python.
• Good understanding of Relational and dimensional Data modeling concepts and experience
  in Data Modeling tools (e.g. Erwin or SQL Data Modeler).
• Strong IDQ experience (specifically with IDQ 10.4.x and IDQ 10.5.x).
• Experience in performing data profiling, data mapping, data validation, data manipulation, data
  analysis.
• IDQ deployments & UAT/QA validations experience following SDLC process.
• Qlik replicate: Experience in creating new connections and replication tasks, debug and resolve
  performance issues, monitoring.
• Should have working experience in job scheduling using Autosys, Control-M, Stonebranch
  platforms or other 3rd parties.
• Experience working in Agile framework and hands on experience using Agile development
  process, e.g., JIRA.

Environment / Technologies involved:
Informatica 10.5.3, Informatica Intelligent Cloud Services (IICS), Informatica Power Exchange 10.5.3,
Oracle 12c/19c, Postgres SQL, MS SQL Server, Erwin, Unix, Stonebranch 7.x, JIRA, Confluence,
ServiceNow, Qlik Replicate, AWS, Redshift.

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.
564 Congress St, Suite # 305
Portland, ME – 04101.
E-Mail: [email protected]