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
- 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
About Techstra Solutions
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
Skills Required
- Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field
- 6+ years of overall IT experience
- 5+ years specializing in enterprise ETL design, data movement, and database optimization
- Expertise in Informatica workflow creation, workflow management, data movement, and data integration
- Advanced SQL skills, including complex joins, aggregations, window functions, and query optimization
- Experience with enterprise relational databases such as Oracle, SQL Server, or PostgreSQL
- Understanding of data pipelines, staging mechanisms, and ETL error-handling routines
- Experience with process improvement, release management, software solutions and design, application development, and system architecture
- Experience with business and team management, group problem solving, customer engagement, and solution-oriented delivery
- Banking experience
- Financial institution experience
- Understanding of regulatory and risk controls in enterprise data environments
What We Do
Techstra Solutions is a certified woman-owned consulting firm that provides strategy, technology and implementation support to large organizations undergoing digital and talent transformation. The rapid pace of technology innovation required to remain competitive, juxtaposed with the slow rate of change in many organizations, causes most to struggle. To be successful companies must drive new ways of working including the use of technology/analytics and new skillsets (hard/soft) deep into their culture so that they are able to rapidly and continuously react to change. They must also apply new approaches that empower their employees, ensuring its sustainability. At Techstra Solutions we focus on four key areas, otherwise known as the 4 A’s: Automation (Robotic Process Automation (RPA)/Intelligent Automation), Analytics (Reporting/Analytics/AI/ML), Application Modernization (Cloud, Mobility, etc), and Agile-based solutions (DevOps).
