RitePros - Software Developer

Developer is needed in Portland, United States.

Client: RitePros

Location: Portland, ME

Contract: undefined

Job Description

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, ensure functionality remains the same for both on-premises and cloud-based systems.
• 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 load it 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.

Requirements

Work experience required for the position:

• At least 3+ years of 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.
• Strong understanding of IICS Data Integration service, Monitor, Application Integration, and Administrator services.
• Working knowledge of IICS Mapping Tasks, Data Synchronization, and Data Replication Tasks.
• Experience collaborating with cross-functional teams, including data engineers, architects, and business analysts to understand business requirements.
• Ability to translate business needs into technical design documents.
• Hands-on experience with Server Maintenance, Deployment, Connection creation, and Access Management in Informatica Administrator.
• Experience in installing and configuring Informatica software and performing system upgrades, including patches.
• Problem-solving skills with troubleshooting, incident root-cause analysis with development teams, and vendor issue resolution.
• Good knowledge of SQL - Oracle/SQL Server/Postgres SQL/AWS Redshift and expertise in Linux shell scripting and/or Python.
• Strong understanding of Relational and dimensional Data modeling concepts and experience with 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 performing data profiling, data mapping, data validation, data manipulation, and data analysis.
• IDQ deployments and UAT/QA validations experience following the SDLC process.
• Qlik Replicate experience in creating new connections and replication tasks, debugging, and performance monitoring.
• Experience with job scheduling using Autosys, Control-M, Stonebranch platforms, or other 3rd parties.
• Experience working in an Agile framework with hands-on experience in Agile development processes, 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

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