ETL Developer/Administrator

Ethereum Technologies LLC; Pittsburgh (Allegheny County); On-site; USD 110,000 - 150,000; Full time

Job summary

Ethereum Technologies LLC in Pittsburgh is seeking a senior data integration engineer with deep Informatica expertise to lead ETL development and system integration across on-prem and cloud environments.

The ideal candidate will design robust data workflows, optimize SQL performance, collaborate with large teams, and translate business requirements into technical solutions, while maintaining high standards of communication and problem-solving.

Qualifications

• 5+ years’ experience with Informatica ETL administration 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).
• Database concepts with Oracle and Salesforce integration.
• Advanced proficiency in writing and optimizing complex SQL queries.
• Excellent debugging and problem-solving skills.
• Ability to understand and translate business/functional requirements.
• 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.

Skills

Informatica ETL

Informatica PowerCenter

PowerExchange

Web Service Hub (WSH)

Mainframe integration (VSAM, Db2)

Oracle

Salesforce

SQL

Debugging

Problem solving

Requirements gathering

Team player

Education

Computer Science degree

Bachelor's degree in Computer Science

Tools

Informatica PowerCenter

PowerExchange

Web Service Hub (WSH)

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.

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