ETL Developer/Administrator

Artifintech; Pittsburgh (Allegheny County); On-site; USD 95,000 - 135,000; Full time

Job summary

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC in the United States is seeking an experienced Informatica ETL Administrator to install, configure, and support ETL processes, and to develop complex workflows.

The ideal candidate brings hands-on PowerCenter/PowerExchange expertise, strong SQL skills, and a proven ability to collaborate within a large team while translating business requirements into reliable data solutions.

Qualifications

• 5+ years hands-on experience with Informatica ETL Administration (installation, configuration, support) and ETL workflow development.
• Proven expertise with Informatica PowerCenter and PowerExchange.
• Experience with Web Service Hub (WSH) for workflow exposure.
• Strong experience integrating with Mainframe systems (VSAM, Db2).
• Solid understanding of database concepts and hands-on integration experience with Oracle and Salesforce.
• Advanced proficiency in writing and optimizing complex SQL queries.
• Excellent debugging and problem-solving skills.
• Demonstrated ability to understand and translate business/functional requirements.
• Proven experience as a collaborative team player within a large team structure.
• Outstanding interpersonal, written, and oral communication skills.
• Ability to adjust to changing priorities and manage multiple tasks.

Responsibilities

• Install, configure, and support Informatica ETL environments.
• Develop and optimize ETL workflows.
• Integrate with Mainframe systems and external data sources.
• Collaborate with cross-functional teams to deliver data solutions.
• Translate business requirements into technical design and implementation.

Skills

Informatica ETL Admin

ETL workflow development

PowerCenter

PowerExchange

Web Service Hub

Mainframe integration

Oracle

Salesforce

SQL

Debugging

Requirements translation

Team collaboration

Communication skills

Education

Bachelor's degree in Computer Science

Educational background in Computer Science

Job description

Required Skills & Experience (Must-Have)

5+ yearsof hands-on experience withInformatica ETL Administration(installation, configuration, support) andETL workflow development.

Proven expertise withInformatica PowerCenterandPowerExchange.

Experience withWeb Service Hub (WSH)for workflow exposure.

Strong experience integrating withMainframe systems (VSAM, Db2).

Solid understanding of database concepts and hands-on integration experience withOracleandSalesforce.

Advanced proficiency in writing and optimizingcomplex SQL queries.

Excellentdebuggingandproblem-solvingskills.

Demonstrated ability to understand and translate business/functional requirements.

Proven experience as a collaborativeteam playerwithin a large team structure.

Outstandinginterpersonal, written, and oral communication skills.

Ability to adjust to changing priorities and manage multiple tasks.

Preferred Skills & Experience (Nice-to-Have)

Experience withAWS Glue.

Experience withInformatica version upgradesandmigration from on-prem to Informatica Cloud (IICS).

Background infinancial services, banking applications, and/or mortgage-backed securities.

Education & Certifications

Required:Educational background in Computer Science or a related field.

Preferred:Bachelor’s degree in Computer Science.

ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ARTIFICIAL INTELLIGENCE TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract