Apply on Employer Site

Austin Community College · 1 month ago

Data Integration Developer

Highland Campus

Full-time

Onsite

Entry, Mid Level

$88K/yr - $111K/yr

2+ years exp

Austin Community College, the 6th largest community college in the nation, is looking for multiple Data Integration developers to help support their new enterprise information management strategy. We are seeking highly skilled developers with a strong background in data integration, ETL/ELT processes, and data modeling to join our dynamic and growing BI team.

Higher Education

No H1B

Responsibilities

Designing, developing, and doing unit testing of complex integration processes

Developing data integrations using ETL and Informatica Real Time process integration components

Developing application integrations using Informatica connecting to platforms such as Salesforce, Workday, and other enterprise applications

Making design decisions and selecting optimal technology strategies and patterns to support varied application integration use cases

Working closely with other BI and IT teams to maintain an accurate and efficient information ecosystem

Writing complex SQL queries, stored procedures and DB triggers

Designing and developing SOAP API components on Informatica Cloud

Writing technical design documents, mapping documents and unit testing documents

Other duties as assigned

Qualification

ETLInformaticaSQLData IntegrationAPIsData ModelingCloud IntegrationCommunication SkillsOrganizational SkillsDetail-oriented

Required

Two (2) years related work experience

Bachelor's degree

Reliable transportation for local Austin area travel

Demonstrated knowledge of SOA and enterprise architecture, including underlying SOA and BPM standards such as XML, web services (SOAP/REST), WSDL etc., experience in Java, JavaScript, .Net, and related tool chains

Demonstrated experience with both data integrations and application integrations

Demonstrated experience working with different relational SQL and NoSQL Databases, ODBC, and JDBC

Experience with cloud, on premise, and hybrid integrations, e.g. AWS, Google Cloud, Azure, Oracle, SAP, Hadoop Ecosystem, Workday, Salesforce, Netapp, Coupa, Siebel, etc

Understanding of service interface design principles, Core ETL abstractions, and design best practices

Ability to design and apply process and integration design patterns

Knowledge of the tools and technologies used in ICS and ICRT Cloud Platform

Working knowledge of data warehouses, data marts and dimensional modeling

Working knowledge of ETL/ELT, SQL, Python, APIs, scripting and data modeling

Ability to work independently and be self-motivated, committed, and detail-oriented

Maintaining an established work schedule

Effectively using organizational and planning skills

Excellent communication, written and verbal, and interpersonal skills

Prioritizing multiple tasks, projects, and demands

Ability to automate manual processes to reduce time and errors