Developer/Analyst - Data Integration

Date:  Nov 20, 2019
Property:  101 INNOVATION (0008)
Location: 

Irvine, CA, 92617

Division:  Innovation Technology (IT)
Req ID:  30925

Position Summary:

This position is responsible for supporting and developing data integrations for Irvine Company application systems using Dell Boomi & SQL Server Integration services. The primary focus of the role will be providing development, technical and integration administration support and related systems integration including designing, coding, and modifying applications and/or related web platforms. Technical scope spans process integration, data integration, cloud systems, systems engineering, database activities and scripts.

Job Duties:

● Develop code to build and modify integration jobs using Dell Boomi Integration tool and SQL Server Integration Services.  
● Develop complex integrations with Salesforce, SAP, SuccessFactors,ADP, SAP Hana etc
● Assist in troubleshooting and optimizing SQL Server Analysis Services cubes.
● Design data mart and develop complex ETL solutions using SSIS with diverse data sources/targets including SQL Server, SAP HANA, Flat files, etc.
● Assist in troubleshooting, monitoring and resolving production issues.
● Develop complex stored procedures and user defined functions in SQL Server, SOQL queries in Salesforce.
● Design and develop data mart using SAP hana studio.
● Provide cloud data integration support (development, installation, configuration, data mapping) and architecture for business operations systems, working with product vendors as needed.
● Establishes design patterns and best practices for integration using REST, XML, JSON, SOAP technologies
● Design and develop integrations to SAP using web service and iDoc.
● Develops reusable code and connectors,APIs using Java,Java scripts,Groovy etc Identification and implementation of improvements to existing systems environments including any technical process improvements.
● Resolution of production issues involving operations systems technologies, working with support leadership to ensure incidents are addressed in a timely and high quality fashion.
● Continually demonstrate high quality customer service and communication skills.
● Perform other projects or duties as assigned.

Additional Accountabilities:

● Dell Boomi
● Salesforce
● SAP

● SuccessFactors
● ADP
● SQL Server
● HANA
● SSAS

General Requirements:

Demonstrate initiative, personal awareness, professionalism, positive attitude, and integrity; exercise a high quality of customer service and leadership in all areas of performance. Project a professional image and demeanor. Understand, apply, and comply with all company policies and procedures.

Supervisory/Management/Leadership Responsibilities

May oversee the work of others for adherence to policies, procedures, budget, and timelines. May assist in the training/mentoring of assigned staff. Assist in driving the achievement of key initiatives.

Problem Solving:

Develop and provide solutions for a variety of problems based on established precedents and policies.

Minimum Qualifications / Other Expectations:

● Master’s Degree in Computer Science
● 4+ years of Data Integration experience
● 2+ years of integration experience using Dell Boomi tool
● 2+ years of experience working with SAP,Salesforce,Successfactors etc
● 2+ years of development experience with Databases like SQL Server,Oracle etc
● 2+ year working with XML and APIs Ability to program in Java, JavaScript, C#, .NET, SQL
● Strong passion for technology and ability to learn new technologies quickly
● Strong interpersonal and communications skills.
● Excellent analysis and design skills
● Strong attention to detail and ability to multi-task and take direction from several people.
● Excellent troubleshooting and problem resolution skills
● Exceptional follow through skills, flexible and capable of working in a fast paced, high energy environment.
● Team player and must be willing to "pitch-in" and assist whenever and wherever needed.

Nature & Extent of Supervision Provided to Job:

Direction is provided in terms of tasks and objectives. Work is reviewed upon completion on how well objectives have been met.

Other Qualifications - Preferred Experience:

Experience working with SAP Process Integration(PI),HCP (IS),Data Services etc

Equipment Used

Computer and related network equipment (including VM and RDP). Telephone, copy machine.

Language Skills

Ability to communicate clearly and effectively in English.

Physical Requirements

Frequent sitting with use of a computer and telephone.


About Us:
Irvine Company is a privately held real estate investment company and master-planner committed to creating and sustaining communities that thrive for generations.

Irvine Company is respected for its master planning and environmental stewardship of the Irvine Ranch in Orange County, including diversified operations throughout coastal California. Irvine Company brings to life neighborhoods and sustainable communities with a full range of housing, jobs, retail centers, schools, parks and open space.

We take as much pride in our employee community as we do the communities we create. It’s an environment populated with talented and experienced people, a collaborative spirit and abundant opportunities.

Apply today to join our employee community, and learn more about Irvine Company, our legacy and our guiding principles.


Irvine Company is committed to providing equal opportunity in all of our employment practices, including selection, hiring, promotion, transfer, compensation, termination, and training, without regard to race, religion, color, sex, sexual orientation, gender, gender identity, national origin, ancestry, citizenship status, marital status, pregnancy, age, medical condition, genetic information, military and veteran status, disability, or any other basis protected by federal, state, and local law. Reasonable accommodation is available for qualified individuals with disabilities, upon request.


Nearest Major Market: Irvine California
Nearest Secondary Market: Los Angeles

Job Segment: Engineer, Systems Engineer, Real Estate, Engineering, Sales