Overview

Position Overview

Design, build and test business application to application data transfer/data integration processes using Informatica; meet with business users to gather business requirements; meet with source System experts to identify appropriate targets, conduct detailed Target system analysis and processes to create data analysis report and Gaps analysis; data validation, process tuning and automation of interface/data transfer processes; design, develop and test application interfaces using application connectors between B2B applications; design data warehouse ETL processes using IICS; create detailed ETL specifications; work with offsite and offshore team members; assist in resolving issues identified by the project team; provide architectural recommendations to meet business requirements; participate in the design, development and maintenance of company websites, Mobile applications and B2B solutions; create collaterals/visual mock-ups for approved prototypes; manage design, development, testing, implementation, maintenance and support of organization-wide Web and mobile application solutions; manage activities to improve efficiency, stability, security and optimization of FBM's Information Technology environment; responsible for design, execution and effectiveness of system of internal controls. Bachelor's degree in Electronics Engineering or related field (or foreign equivalent). 2 years experience in job offered or as Engagement Lead, Team Lead.

Responsibilities and Qualifications

2 years experience (can be gained concurrently with the above experience) in:

• Design, development and implementation of complex data warehouse and business intelligence solutions using Informatica (IICS), Azure Synopsis, Power BI, DAX, SSIS, SSAS, SSRS, T-SQL
• Data modeling in at least three of the following areas: Sales, Purchasing, Finance, Inventory, GA, CRM
• Application integration using Infor CSD, SAP S4 Hana, SAP Ariba, Blackline, Vistex, UltiPro, Dayforce, Microsoft Dynamics 365
• Working with telematics data sourcing from Trimble and Samsara
• Design, develop and implement complex data warehouse and business intelligence solutions using Informatica, Power BI and Tableau
• Sourcing data using application-delivered APIs
• Azure SQL Data Warehouse
• Azure Data Lake
• Azure Data Factory
• Azure Analysis Services
• Google's Big Query

Must have working knowledge of API behavior, security and paging

Compensation and Benefits

Employer will accept any suitable combination of education, training, or experience. Employer: Foundation Building Materials, LLC. Job location: Santa Ana, CA. Qualified applicants email resume to: [redacted] and reference job #[redacted]7.

Posting Period

This job will be posted for at least 5 days, starting on the initial post date reflected above.

Salary Range

Min: USD $102,232.00/Yr., Max: USD $145,000.00/Yr.