Senior Informatica Architect – Data Integration Lead (Flexible)

Trinzic; Houston (TX); On-site; USD 105,000 - 165,000; Full time

Job summary

Trinzic is seeking a Senior Informatica Developer to design, develop, and support enterprise data integration, data warehouse, and BI solutions. You will partner with stakeholders and IT teams to deliver reliable data pipelines and optimize processing workflows.

The role requires deep Informatica expertise, strong SQL and data modeling skills, and experience with Oracle and MS SQL Server in enterprise environments. U.S. citizenship is required.

Qualifications

• Bachelor's degree in CS/IT or related field; equivalent experience may be considered.
• 7+ years ETL/data integration with Informatica PowerCenter.
• 5+ years with IDMC Data Integration.
• Experience with enterprise data warehouse and BI solutions.
• Experience with Oracle and MS SQL Server in enterprise environments.
• Must be a U.S. Citizen.

Responsibilities

• Design, develop, enhance, and support enterprise ETL processes and data integration solutions using Informatica.
• Partner with business users and IT teams to translate requirements into technical solutions.
• Develop and maintain data models supporting reporting and analytics.
• Build and support data warehouse, data mart, and BI solutions.
• Perform data analysis, impact assessments, and troubleshooting for projects.
• Develop and optimize SQL queries, stored procedures, and data processing workflows.
• Coordinate data development initiatives and improve data accessibility and efficiency.
• Support data governance and ensure compliance with standards.
• Collaborate with teams on releases, deployments, testing, and change management.
• Provide mentoring and drive continuous improvement in the data engineering function.

Skills

Informatica PowerCenter

Informatica IDMC

Data warehousing

Data modeling

SQL development

Python

PowerShell

Data governance

Education

Bachelor's degree in Computer Science or related field

Tools

Toad

SQL Developer

Job description

Trinzic is seeking a Senior Informatica Developer to design, develop, and support enterprise data integration, data warehouse, and BI solutions. You will partner with stakeholders and IT teams to deliver reliable data pipelines and optimize processing workflows.

The role requires deep Informatica expertise, strong SQL and data modeling skills, and experience with Oracle and MS SQL Server in enterprise environments. U.S. citizenship is required.