Informatica ETL Developer

Informatica ETL Development

Employment Type : Full-Time

Locations :   Pittsburgh, PA

Work Model :   On-Site 5 Days Per Week

Role 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.

Required Qualifications

Skills

About Techstra Solutions

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.

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.