About the Role
Austin Community College is seeking highly skilled Data Integration developers to support their new enterprise information management strategy. You will have the opportunity to build a new data integration hub from the ground up to support a robust business intelligence platform.
Responsibilities
- Designing, developing, and unit testing 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 for 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.
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.
- Reliable transportation for local Austin area travel.
- Work is performed in an office environment.
- Subject to standing, walking, sitting, bending, reaching, pushing, pulling and at some times stooping, crawling, and climbing.
- Occasional lifting of objects up to 30 pounds.
- 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.
Skills
- Data integration
- ETL/ELT processes
- Data modeling
- Informatica
- Salesforce
- Workday
- SQL
- SOAP API
- XML
- Web services (SOAP/REST)
- WSDL
- Java
- JavaScript
- .Net
- Relational SQL Databases
- NoSQL Databases
- ODBC
- JDBC
- AWS
- Google Cloud
- Azure
- Oracle
- SAP
- Hadoop Ecosystem
- Netapp
- Coupa
- Siebel
- Python
- APIs
- Scripting
- Independent work
- Self-motivation
- Commitment
- Detail-orientation
- Organizational skills
- Planning skills
- Communication skills
- Interpersonal skills
- Prioritization
- Automation
Location
- Austin, TX
Work Type
- Full-time
- Onsite
Experience Level
- Two (2) years related 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.
Education Level
- Bachelor's degree
- Additional related work experience may be substituted for bachelor’s degree requirement.
Salary/Compensations
- $88,465 - $110,581
Benefits
- Medical
- Dental
- Life insurance
- Short- and long-term disability
- Retirement plans
- AD&D
- Teacher Retirement System of Texas (TRS)
- Optional Retirement Program (ORP-Faculty and Administrators Only)
- ACC Money Purchase Plan (ACCMPP)
About the Company
- 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 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.
- ACC is looking for people who value open, responsible exchange of ideas, individuals committed to integrity and exemplary standards, and candidates that value personal and professional ownership that generates accountability.
- ACC offers career employment opportunities as staff, administrators, full-time faculty, and adjunct faculty.
Equal Opportunity
- Austin Community College (“ACC” or “College”) is an equal education and equal employment opportunity employer and prohibits discrimination in employment at the college and access to its programs or activities on the basis of race, color, religion, sex (including gender identity, sexual orientation, marital status, and pregnancy), national origin, age (40 and older), veteran status or military service, disability, genetic information or any other basis prohibited by local, state, or federal law.
- This includes the prohibition of discrimination, including harassment, against any employee, applicant for employment, student, or applicant for admission.
- ACC will take steps to ensure that the lack of English language skills will not be a barrier to admission and participation in all educational and vocational programs.
