Senior Informatica ETL Architect - Data Pipelines & SQL

techstrasolutions; Pittsburgh (Allegheny County); On-site; USD 110,000 - 160,000; Full time

Job summary

Techstra Solutions in Pittsburgh, PA is seeking a Senior ETL Developer to design, develop, and execute complex ETL workflows using Informatica, focusing on robust data movement for banking operations.

You will lead technical design reviews, optimize SQL-driven transformations, and guide engineering peers while ensuring data quality and security in enterprise data environments.

The role emphasizes collaboration with stakeholders and adherence to risk management standards.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• 6+ years IT experience with 5+ years specializing in enterprise ETL design, data movement, and database optimization, preferably in a large banking / financial institution environment.
• Proven expertise in Informatica (Workflow creation, workflow management, data movement, and data integration).
• Strong advanced SQL skills (complex joins, aggregations, window functions, and query optimization/filtering).
• Experience working with enterprise relational databases (Oracle, SQL Server, or PostgreSQL).
• Understanding of data pipelines, staging mechanisms, and error-handling routines in ETL design.
• Process Improvement
• Release Management
• Software Solutions and Design
• Application Development
• Design and architecture familiarity/experience
• Business and Team Management
• Group Problem Solving
• Customer Engagement and Solutions Oriented

Responsibilities

• Technical Troubleshooting - Subject Matter Depth and Breadth
• Application Delivery Process - Extensive Experience
• Application Design, Architecture - Subject Matter Depth and Breadth
• Application Development Tools - Subject Matter Depth and Breadth
• Application Testing - Extensive Experience
• Packaged Application Integration - Subject Matter Depth and Breadth
• System Development Lifecycle - Extensive Experience

Skills

Informatica Workflow

Advanced SQL

ETL Design

Data Pipeline Expertise

Education

Bachelor's degree

Tools

Oracle

SQL Server

PostgreSQL

Informatica

Job description

Techstra Solutions in Pittsburgh, PA is seeking a Senior ETL Developer to design, develop, and execute complex ETL workflows using Informatica, focusing on robust data movement for banking operations.

You will lead technical design reviews, optimize SQL-driven transformations, and guide engineering peers while ensuring data quality and security in enterprise data environments.

The role emphasizes collaboration with stakeholders and adherence to risk management standards.