The Role
The Informatica ETL Developer designs, develops, and maintains ETL solutions for data integration, focusing on performance tuning and effective stakeholder communication.
Summary Generated by Built In
Informatica ETL Development
Employment Type: Full-Time
Locations: Pittsburgh, PA
Work Model: On-Site 5 Days Per WeekRole Overview
The Informatica ETL Developer plays a key role in designing, developing, and maintaining data integration solutions that support the organization’s data platforms and reporting environments. This role is responsible for extracting, transforming, and loading data from multiple source systems into various target platforms, as well as enhancing and maintaining existing ETL mappings. Working closely with leadership, engineering, and cross-functional teams, the Informatica ETL Developer contributes to the implementation of efficient, scalable, and reliable data integration solutions aligned with business and technical requirements. The role requires strong technical expertise in Informatica and ETL best practices, along with effective communication, time management, and collaboration skills to support successful project delivery.Key Responsibilities
Techstra Solutions helps leading organizations unlock the value of Digital and Talent Transformation. We combine business strategy, technology, and talent to guide clients through complex transformation journeys—from strategy through execution. We deliver our expertise through consulting, innovative staffing solutions, and software development, always focused on measurable outcomes and long-term impact.
Employment Type: Full-Time
Locations: Pittsburgh, PA
Work Model: On-Site 5 Days Per WeekRole Overview
The Informatica ETL Developer plays a key role in designing, developing, and maintaining data integration solutions that support the organization’s data platforms and reporting environments. This role is responsible for extracting, transforming, and loading data from multiple source systems into various target platforms, as well as enhancing and maintaining existing ETL mappings. Working closely with leadership, engineering, and cross-functional teams, the Informatica ETL Developer contributes to the implementation of efficient, scalable, and reliable data integration solutions aligned with business and technical requirements. The role requires strong technical expertise in Informatica and ETL best practices, along with effective communication, time management, and collaboration skills to support successful project delivery.Key Responsibilities
- Perform data movement processes and advanced ETL development using Informatica, PL/SQL, Oracle Database, SQL, and other technologies.
- Analyze data structures in existing legacy systems to design ETL processes and data warehouse structures.
- Design, implement, test, and maintain ETL components for multiple applications.
- Modify existing ETL mappings and develop new ones from scratch.
- Plan and conduct Informatica ETL unit and development tests.
- Develop and manage ETL configurable artifacts (code, configuration files, documentation).
- Provide data analysis to support project design, troubleshooting, and issue resolution.
- Work independently or as part of a team to deliver ETL projects.
- Follow established standards and best practices and contribute to process improvements.
- Maintain large-scale, multi-terabyte 24/7 data warehouse applications.
- Communicate effectively with stakeholders, providing documentation, updates, and recommendations.
- Demonstrate strong attention to detail and accuracy in all deliverables.
- Bachelor’s degree in Computer Science, Information Systems, or a related field.
- 5+ years of experience with Informatica PowerCenter and other ETL tools.
- Strong expertise in ETL development and Informatica best practices.
- Experience with Unix Shell Scripting and SQL.
- Experience in OLAP environments and data warehouse development lifecycle.
- Skilled in source systems analysis and extraction from flat files, Oracle, and other heterogeneous data sources.
- Ability to create complex mappings using various transformations and develop ETL strategies.
- Knowledge of dimensional modeling, repository management, and administration.
- Performance tuning experience for sources, transformations, targets, mapplets, mappings, worklets, workflows, sessions, and batches.
- Ability to gather business requirements, define metadata, and support design, development, production, testing, and user training.
- Strong analytical, problem-solving, and organizational skills.
- Excellent verbal and written communication skills.
- Ability to work independently or collaboratively in a fast-paced environment.
- ETL Development & Data Integration
- Data Warehousing & Dimensional Modeling
- SQL & Unix Scripting
- Performance Tuning & Optimization
- Technical Requirements Analysis
- Cross-Functional Collaboration
Techstra Solutions helps leading organizations unlock the value of Digital and Talent Transformation. We combine business strategy, technology, and talent to guide clients through complex transformation journeys—from strategy through execution. We deliver our expertise through consulting, innovative staffing solutions, and software development, always focused on measurable outcomes and long-term impact.
Top Skills
Informatica Powercenter
Oracle Database
Pl/Sql
SQL
Unix Shell Scripting
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
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).
