Top 1 Data analyst/data modeler Jobs in Portland, Me

Software Developer
RitePros —Portland, ME
- Azure
- Computer Science
- Mid-level

Explore jobs in cities nearby

Check out jobs in cities near your current location, Columbus

Data Warehouse Sr. Manager
Huntington Bank —Columbus, OH
Understand and translate the technical design from the Data Architect team into implemented physical data models that meet data governance, enterprise…
6d

I want to receive the latest job alert for data analyst/data modeler in portland, me

By signing in to your account, you agree to SimplyHired's Terms of Service and consent to our Cookie and Privacy Policy.

Explore jobs in more locations

data analyst/data modeler jobs near portland, me

Software Engineer jobs in Portland, ME

Robotics Engineer jobs in San Diego, CA

Software Engineer jobs in Albany, NY

Software Engineer jobs in Mcallen, TX

Software Engineer jobs in Roanoke, VA

Software Engineer jobs in Tri Cities, WA

Software Engineer jobs in California

Software Developer

RitePros
Portland, ME

Apply Now

Job Details

Qualifications

Data integrity assurance
Data model design
Commercial use (data warehousing systems)
Systems integration
Data replication
Defect resolution root cause analysis
Requirements design
Cloud data warehouses
Data validation techniques
Defect analysis
Implementing cloud migration projects
IT system monitoring
Software implementation
UNIX
Application deployment
Software installation
Schema design
Server updates
SQL
ETL process automation
Patch management
Data integrity process (data warehousing)
Implementation (software development lifecycle)
Integration Platforms (Enterprise solutions)
Server installation
User acceptance testing
Agile software development
Application Maintenance
Systems & applications support
Analysis (software development lifecycle)

Full 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 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.
Should 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.
565 Congress St, Suite # 305
Portland, ME 04101.

Email: [email protected]

Apply Now

Refine Your Search

data analyst/data modeler jobs in portland, me

Software Developer

Explore jobs in cities nearby

I want to receive the latest job alert for data analyst/data modeler in portland, me

Explore jobs in more locations

Job Seeker Tools

Employer Tools

Browse

Stay Connected