Data Scientist - Level III

PriceSenz; Texas; Remote; USD 90,000 - 140,000; Full time

Job summary

An innovative firm is looking for a seasoned Informatica ETL & Data Warehouse Expert to lead the design and optimization of ETL pipelines. In this remote role, you will manage data flow across systems, ensuring high standards of data quality in a complex Oracle-based environment. Your expertise in data modeling and profiling will be essential as you collaborate with stakeholders to meet business needs. If you're passionate about data integration and quality, this is the perfect opportunity to make a significant impact in a dynamic setting.

Qualifications

• 8+ years of experience with Informatica ETL and data warehousing.
• Strong background in data modeling and data science principles.

Responsibilities

• Design and manage ETL processes for enterprise data warehousing.
• Implement data pipelines and ensure data quality across systems.

Skills

Informatica ETL

Informatica Cloud

Oracle

SQL Server

Data Warehousing

Data Modeling

Data Profiling

Data Validation

ETL Testing

Data Quality

AWS

Case Management Systems

Tools

Erwin

Job description

Job Title : Informatica ETL & Data Warehouse Expert

Location : Remote

Employment Type : Contract

Job Summary :

We are seeking an experienced Data Manager with deep expertise in Informatica ETL, enterprise data warehousing, and data integration . The ideal candidate will lead the design, development, and optimization of ETL pipelines and manage the flow of data across multiple systems using Informatica (including Informatica Cloud). This role involves data modeling, profiling, validation, and ensuring high standards of data quality across a complex, Oracle-based data warehouse environment.

Key Responsibilities :

Design, develop, and manage ETL processes using Informatica to support enterprise data warehousing.

Implement and maintain data pipelines from source systems to target warehouses (Oracle, SQL Server).

Perform data profiling, cleansing, transformation, and validation to ensure data accuracy and consistency.

Develop and maintain data models (relational and dimensional) for reporting and analytics.

Work with large datasets and apply data science principles to support modeling, error analysis, and insight generation.

Identify and resolve data mismatches and quality issues , particularly in case management systems .

Collaborate with stakeholders to gather data requirements and ensure data solutions align with business needs.

Utilize Informatica Cloud for cloud-based ETL deployments and integration tasks.

Support and enforce data quality standards and best practices .

Minimum Qualifications :

8+ years of experience with Informatica ETL tools and processes

8+ years of experience with data warehousing , including relational and dimensional modeling

8+ years of experience working with Oracle and / or SQL Server databases

8+ years of hands-on experience in data modeling

8+ years of experience in data science , data mining, or data analysis

8+ years working with Informatica Cloud

3+ years of experience identifying and resolving data mismatches in case management systems

Preferred Qualifications :

Experience working with multiple RDBMS platforms (e.g., DB2, SQL Server, Oracle)

Experience using Erwin or similar data modeling tools

Familiarity with Amazon Web Services (AWS) and cloud data services

Additional experience in case management system integration and troubleshooting

Key Skills :

Informatica ETL, Informatica Cloud, Oracle, SQL Server, Data Warehousing, Data Modeling, Erwin, Data Profiling, Data Validation, ETL Testing, Data Science, Data Quality, AWS, Case Management Systems