ETL Developer/Administrator

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

Job summary

Cloud Analytics Technologies, LLC is seeking an experienced Informatica ETL Administrator to join our data integration team in the United States. You will install, configure, support Informatica runtimes, develop workflows, and integrate with PowerCenter, PowerExchange, and mainframe systems (VSAM, Db2).

Strong SQL and debugging skills are required. 5+ years hands-on experience, excellent communication, and ability to work within a large team are highly valued.

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

Skills

Informatica ETL Admin

Informatica PowerCenter

PowerExchange

Web Service Hub

Mainframe VSAM

Db2

Oracle

Salesforce

SQL queries

Debugging

Collaboration

Communication

Education

Computer Science degree

Bachelor's 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.

Equal Opportunity Employer

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

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 industry-leading Cloud Analytics Technologies, LLC code - delivered by the Cloud Analytics Technologies, LLC consultants UN agency understand these solutions best. Through a mix of with-it technology and dedicated service and support, Cloud Analytics Technologies, LLC hosted managed services will facilitate you: