Data Integration Developer Jobs (NOW HIRING)

Job Posting Closing Times: Job postings are removed from advertising at12:00 A.M.on the closing date e.g., at midnight on the day before the closing date.

Austin Community College employees are required to maintain a domicile in the State of Texas while working for the college and throughout the duration of employment. - AR 4.0300.01

If you are a current Austin Community College employee, please click this link to apply through your Workday account.

Austin Community College is a public two-year institution that serves a multicultural population of approximately 41,000 credit students each Fall and Spring semester. We embrace our identity as a community college, as reflected in our mission statement. We promote student success and community development by providing affordable access, through traditional and distance learning modes, to higher education and workforce training, including appropriate applied baccalaureate degrees, in our service area.

As a community college committed to our mission, we seek to recruit and retain a workforce that:

• Values intellectual curiosity and innovative teaching

• Is attracted by the college's mission to promote equitable access to educational opportunities

• Cares about student success and collaborates on strategies to facilitate success for populations including; first generation college students, low-income students, and students from underserved communities.

• Focused on student academic achievement and postgraduate outcomes

• Welcomes difference and models respectful interaction with others

• Engages with the community both within and outside of ACC

Job Posting Title:

Job Description Summary:

Job Description:

Description of Duties and Tasks

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

Knowledge

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

Skills

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

Required Work Experience

• Two (2) years related work experience.

Preferred Work Experience

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

Required Education

• Bachelor's degree.

Additional related work experience may be substituted of bachelor's degree requirement.

Special Requirements

• Reliable transportation for local Austin area travel.

Physical Requirements

• Work is performed in an office environment.

• Subject to standing, walking, sitting, bending, reaching, pushing, pulling and at times stooping, crawling, and climbing.

• Occasional lifting of objects up to 30 pounds.

Safety

• Supervise safe operation of the unit. Facilitate safety inspections.

• Take reasonable and prudent actions to eliminate identified hazards.

• Ensure employees receive appropriate safety training and foster a workplace safety culture.

Salary Range

$88,465 - $110,581

Number of Openings:

Job Posting Close Date:

As required by the US Department of Education, employees are required to report violations under Title IX and, under the Jeanne Clery Campus Safety Act (Clery Act), select individuals are required to report crimes. If this position is identified as a Campus Security Authority (Clery Act), you will be notified, trained, and provided resources for reporting.

Austin Community College produces an Annual Security Report as required by the Clery Act. This report includes statistics from the previous three years concerning reported crime that occurred on campus; public property adjacent to and accessible from campus; and in certain non-campus buildings/property owned or controlled by ACC. The report includes institutional policies concerning campus security and other safety information.

For direct access to the current Annual Security Report, visit www.austincc.edu/asr . You may obtain a hard copy by contacting the Clery Compliance Officer ( CleryComplianceOfficer@austincc.edu ). For an overview, see ACC's Clery Act website.

The above description is an overview of the job. It is not intended to be an all-inclusive list of duties and responsibilities of the job, nor is it an all-inclusive list of the skills and abilities required to do the job. Duties and responsibilities may change with business needs. ACC reserves the right to add, change, amend, or delete portions of this job description at any time, with or without notice. Employees may be required to perform other duties as requested, directed, or assigned. In addition, reasonable accommodations may be made by ACC at its discretion to enable individuals with disabilities to perform essential functions of the job.