Data Integration Developer

Austin Community College • Austin, TX

1d

About The Position

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. You will have the unique opportunity to have a hand in building a new data integration hub from the ground up to support a robust and meaningful business intelligence platform that serves the whole college.

Requirements

• 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 design and apply process and integration design patterns.
• Willingness to learn new tools and processes to improve efficiency.
• Ability to automate manual processes to reduce time and errors.
• Two (2) years related work experience.
• Bachelor's degree.
• Additional related work experience may be substituted of bachelor’s degree requirement.
• Reliable transportation for local Austin area travel.

Nice To Haves

• Six (6) years of experience with data management, integration systems, iPaaS, cloud-based enterprise tools, etc., Informatica IICS or IDMC.
• Eight (8) years of experience with ETL tools, Informatica Power Center preferred or any equivalent ETL tools.
• Twelve (12) years of experience in writing SQL queries, DB triggers and procedures.
• Four (4) years of experience in writing and implementing the SOAP APIs on Informatica cloud platform.

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.

Benefits

• Full-time faculty and staff employees who work in full-time and/or part-time positions at the college are eligible for ACC medical benefits effective the first of the month after their first 60 days of employment.
• Benefits include medical, dental, life insurance, short- and long-term disability, retirement plans, and AD&D.
• ACC does not participate in Social Security.
• ACC participates in the Teacher Retirement System of Texas (TRS) and the Optional Retirement Program (ORP-Faculty and Administrators Only).
• Hourly employees participate in the ACC Money Purchase Plan (ACCMPP) as a retirement program required by federal law.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 1,001-5,000 employees