ETL Developer/Administrator

Robotics Prcocess Automation, LLC; Pittsburgh (Allegheny County); On-site; USD 90,000 - 120,000; Full time

Job summary

A technology solutions company in Pittsburgh is seeking an experienced professional with over 5 years in Informatica ETL Administration. The ideal candidate will have strong skills in SQL and database integration, specifically with Oracle and Salesforce. This role involves developing ETL workflows and requires excellent debugging and problem-solving abilities. A bachelor's degree in Computer Science or a related field is preferred. The company promotes an equal opportunity employment environment.

Qualifications

• 5+ years of hands-on experience with Informatica ETL Administration.
• Proven expertise with Informatica PowerCenter and PowerExchange.
• Solid understanding of database concepts and integration with Oracle and Salesforce.

Responsibilities

• Install, configure, and provide support for Informatica ETL.
• Develop ETL workflows and solve complex issues.
• Collaborate within a large team structure and adjust to multiple tasks.

Skills

Informatica ETL Administration

Informatica PowerCenter

Web Service Hub (WSH)

Mainframe integration (VSAM, Db2)

Database concepts integration

Complex SQL queries

Debugging and problem-solving

Understanding business requirements

Education

Educational background in Computer Science

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.

ROBOTIC PROCESS AUTOMATION 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. ROBOTIC PROCESS AUTOMATION 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 ROBOTIC PROCESS AUTOMATION 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