Informatica ETL Developer

techstrasolutions; Pittsburgh (Allegheny County); Sur place; USD 110 000 - 160 000; Plein temps

Résumé du poste

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

Responsabilités

• 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

Connaissances

Informatica Workflow

Advanced SQL

ETL Design

Data Pipeline Expertise

Formation

Bachelor's degree

Outils

Oracle

SQL Server

PostgreSQL

Informatica

Description du poste

Role Overview

The Senior ETL Developer role adds technical design, workflow creation, and data movement execution, complex problem resolution, guidance and support for engineering peers, code and data pipeline reviews, and use of modern principles, methodologies, and tools to advance enterprise data integration and streaming initiatives. Senior ETL Developer with deep expertise in Informatica workflow management and advanced SQL-driven data processing.

Creates and leads the technical design, development, and execution of complex ETL workflows, data integration pipelines, and high-performance data transformations using Informatica. Proposes & designs robust data movement solutions to address complex banking operational and analytical needs. Prepares technical data mapping specifications and procedural documentation required. Facilitates complex problem resolution across pipeline failures, performance bottlenecks, and database query tuning. Provides technical guidance and support to colleagues. Reviews coding, SQL scripts, testing plans, and documentation of data pipelines. Applies modern principles, methodologies and tools to advance data integration capabilities and system throughput.

Customer Focused - Knowledgeable of the values and practices that align data accuracy, downstream consumption, and stakeholder satisfaction as primary considerations in all business decisions, leveraging that information to build reliable data solutions.

Managing Risk - Assessing and effectively managing all of the risks associated with data movement, enterprise data quality, and security compliance to ensure they adhere to and support the company's Enterprise Risk Management Framework.

Key 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

Required Qualifications/ Skills

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field
• 6+ Years of overall 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

Preferred Qualifications

• Banking experience
• Financial institution experience
• Understanding regulatory and risk controls in enterprise data environments

Locations

Pittsburgh, PA

AboutTechstraSolutions

Techstra Solutions is a certified woman-owned (WBENC) management consulting firm specializing in strategy, technology, and implementation services for large organizations undergoing digital and talent transformation. Our experienced team partners with clients to co-create innovative solutions in applications, data, AI, and automation that accelerate measurable, sustainable change. From advisory consulting through technical execution, we are dedicated to driving world-class business solutions that fit your strategic requirements and deliver results. For more information: www.techstrasolutions.com

Equal Employment Opportunity Statement

Techstra Solutions is an equal opportunity employer. The Company makes its decisions on merit, and its policy of equal opportunity prohibits discrimination in all phases of the employment process, including, but not limited to, recruitment, hiring, promotion, selection, transfer, demotion, layoff, termination, compensation, benefits, and other terms and conditions of employment. The policy of equal opportunity applies without regard to race, color, creed, religion, gender, sexual orientation, gender identification, pregnancy, marital status, national origin, ancestry, age, disability that can reasonably be accommodated without undue hardship, military status, veteran status, genetic predisposition or carrier status, alienage or citizenship, domestic partnership status, arrest or conviction record, status as a victim of domestic violence, or any other protected categories under federal, state, or local law. The Company also prohibits discrimination or harassment based upon the perception that a person has, or is associated with a person who has, any of these characteristics.