Data Acquisition Engineer (Informatica/ETL) Job in Irvine 92620, California Us

As new data sources are acquired and existing data sources migrated to the appropriate data environments according to the Data Acquisition plan, this position will be key in developing the means for moving, processing and analyzing the data utilizing the recently acquired Informatica PowerCenter toolset.

Position responsibilities:

* Create and maintain stored procedures, triggers, views and constraints to support systems and databases.
* Review the requirements to assess and estimate the work effort.
* Create test plans and scenarios for validation.
* Work with peers to carry out design and code reviews of new development.
* Assist in designing, developing and maintaining the data acquisition framework and its ETL/ELT packages using Data Integration Technologies, including Informatica, Netezza, and SSIS.
* Contribute to architecture and design activities.
* Contribute to the development and implementation of the Data Acquisition process.
* Develop queries and stored procedures involving simple to complex database structures.
* Document new design, development procedures or test plans as needed.

Essential skills, knowledge and abilities:

* Minimum of 6 years industry experience in Software Engineering / Database Engineering / Data Integration Engineering, meeting deadlines, and performing software development duties.
* Strong experience developing enterprise level Data Integration Framework and its packages using Informatica product suite (PowerCenter, PowerExchange, Netezza Pushdown).
* Ability to coach and mentor others on the design, development, and usage of Informatica product suite.
* Must be capable of understanding complex data objects and data models.
* Experience developing relational data models, stored procedures and software with multi-layer architecture using SQL Server and/or Netezza.
* Experience and preference developing ETL/ELT packages using Data Integration Technologies such as Informatica, Netezza, and SSIS.
* Experience with object-oriented design and development principles.
* Experience with XML DTDs and XML Schemas.
* Experience developing workflows involving various network protocols (e.g., FTP, HTTP, web services).
* Ability to work in a fast-paced, team oriented environment.
* Ability to complete the full lifecycle of software development and deliver on time.
* Ability to work with end users to gather requirements and convert that to working documents.
* Strong interpersonal skills with a heads-up programming attitude.
* Experience with Informatica product suite.
* Strong experience with SQL Server and/or Netezza.
* Experience developing workflows involving various network protocols (e.g., FTP, HTTP, web services).

Non-essential skills, knowledge and abilities:

* Experience with Agile and Scrum development process is a plus.
* Experience with Informatica Data Quality is a plus.
* Experience developing C# applications within a .NET framework is a plus.
* Experience with automobile information is a plus.