ETL Developer/Administrator

Robotics Technologies LLC; Pittsburgh (Allegheny County); On-site; USD 80,000 - 100,000; Full time

Job summary

A technology firm in Pittsburgh is seeking an experienced professional for ETL Administration. The role requires 5+ years in Informatica administration and proficiency in SQL, with strong integration experience to Mainframe systems. An educational background in Computer Science is essential, and a Bachelor’s degree is preferred. The ideal candidate will have excellent interpersonal and problem-solving skills, adjusting to changing priorities effectively. This position promotes an inclusive environment and offers opportunities for diverse candidates.

Qualifications

• 5+ years of hands-on experience with Informatica ETL Administration.
• Proven expertise with Informatica PowerCenter and PowerExchange.
• Strong experience integrating with Mainframe systems (VSAM, Db2).
• Solid understanding of database concepts and integration experience with Oracle and Salesforce.

Skills

Informatica ETL Administration

Informatica PowerCenter

Informatica PowerExchange

Web Service Hub (WSH)

Mainframe systems (VSAM, Db2)

SQL optimization

Problem-solving skills

Interpersonal communication

Education

Educational background in Computer Science or a related field

Bachelor’s degree in Computer Science

Tools

AWS Glue

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.

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