ETL Developer/Administrator

Cloud Analytics Technologies, LLC; Pittsburgh (Allegheny County); On-site; USD 80,000 - 110,000; Full time

Job summary

A leading cloud analytics firm in Pittsburgh is seeking a skilled Informatica ETL Administrator with over 5 years of experience. The ideal candidate has expertise in Informatica PowerCenter and integration with mainframe systems. Strong SQL skills and a collaborative mindset are essential. This position offers a chance to work within a diverse team in a dynamic environment, ensuring efficient ETL processes for clients. Competitive compensation and benefits are included.

Qualifications

• 5+ years of hands-on experience with Informatica ETL Administration.
• Proven expertise with Informatica PowerCenter and PowerExchange.
• Strong experience integrating with Mainframe systems.

Skills

Informatica ETL Administration

Informatica PowerCenter

Web Service Hub (WSH)

Mainframe systems integration

Oracle integration

Salesforce integration

SQL optimization

Communication skills

Problem-solving

Education

Educational background in Computer Science

Bachelor’s degree in Computer Science

Tools

AWS Glue

Job description

Required Skills & Experience (Must-Have)

• 5+ years of 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.

Preferred Skills & Experience (Nice-to-Have)

• Experience with AWS Glue.
• Experience with Informatica version upgrades and migration from on-prem to Informatica Cloud (IICS).
• Background in financial 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.

CLOUD ANALYTICS 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. CLOUD ANALYTICS 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 CLOUD ANALYTICS 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.

Equal Opportunity Employer

CLOUD ANALYTICS 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. CLOUD ANALYTICS 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 CLOUD ANALYTICS 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.

Some of our Business Ventures - Knowledge Analytics

Do restrictive necessities, your capability for advanced analytics or your business model need custom-made applications and infrastructure configurations? Opt for our hosted managed services to urge comprehensive analytics solutions supported by Cloud Analytics Technologies, LLC, delivered by the Cloud Analytics Technologies, LLC consultants. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you.