IntePros ยท 11 hours ago
ETL Developer
Pittsburgh, PA
Full-time
Onsite
Mid LevelIntePros is seeking an experienced ETL Developer with strong Informatica expertise to join their technology team. The ideal candidate will be responsible for managing Informatica environments, developing and supporting ETL workflows, and ensuring seamless data integration across enterprise systems.
ConsultingInformation TechnologyStaffing Agency
Responsibilities
Install, configure, and administer Informatica ETL environments, including production support and performance optimization
Design, develop, and maintain ETL workflows and data integration solutions using Informatica PowerCenter/PowerExchange
Integrate data across multiple systems, including Mainframe VSAM, Db2, Oracle, and Salesforce
Develop and maintain Web Service Hub (WSH) components to expose workflows as web services
Write and optimize complex SQL queries using advanced functions for ETL processing and validation
Debug and resolve issues in data workflows and integrations efficiently
Collaborate with business and technical teams to understand requirements and translate them into scalable solutions
Document processes, create technical designs, and communicate effectively with both technical and non-technical audiences
Support Informatica upgrades, migrations, and ongoing enhancements
Qualification
Required
Experience with Informatica ETL Administration and Development (installation, configuration, workflow creation, and support)
Expertise with Web Service Hub (WSH), PowerCenter, and PowerExchange
Strong understanding of Mainframe VSAM and Db2 integration in Informatica workflows
Proven experience with database integration across Oracle, Salesforce, and mainframe systems
Proficiency in advanced SQL and query optimization
Strong debugging, analytical, and problem-solving skills
Ability to work effectively in large teams and manage multiple priorities
Excellent written and verbal communication skills
Background in Computer Science or a related technical field
Preferred
Experience with AWS Glue and Informatica Cloud migrations (on-prem to cloud)
Familiarity with financial services, banking, or mortgage-backed securities domains
Experience performing Informatica version upgrades and environment migrations
Bachelor's degree in Computer Science or a related discipline
Company
IntePros
IntePros is an established, woman-owned, privately-held technology and business services consulting agency committed to building long-term relationships and helping more companies leverage the power of a more diverse workforce.
Founded in 1996
201-500 employees
H1B Sponsorship
IntePros has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (3)
2023 (6)
2022 (7)
2021 (6)
2020 (13)
Funding
Current Stage
Growth StageLeadership Team
Loren Kovalcik
CEO
Company data provided by crunchbase