Iics Informatica Jobs in California (NOW HIRING)

About Us

Company Overview

Foundation Building Materials (FBM) is a leading construction materials distribution company serving the commercial and residential construction markets across United States and Canada. In conjunction with Unified Door & Hardware Group (UDHG), a premier provider of commercial door, frame, and hardware solutions, FBM supports a broad range of construction and architectural projects nationwide.

Together, FBM and UDHG's 8,000+ Team Members are committed to operational excellence, innovation, and employee development. By combining scale, specialty expertise, and a customer-first mindset, we deliver high-quality products and services to contractors, builders, and project teams across diverse markets. As the organization continues to grow and evolve following the recent acquisition by Lowe's, we are investing in strong, forward-thinking talent to support our long-term success.

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: talent@myfbm.com and reference job #71747.00017.

Statements

Equal Opportunity Employer

Foundation Building Materials is an Equal Opportunity Employer and is committed to providing equal employment opportunities to all individuals. We value diversity and inclusion and are dedicated to creating a workplace where all employees feel respected and empowered. All employment decisions are made without regard to race, color, religion, sex, pregnancy (including childbirth, breastfeeding, or related medical conditions), sexual orientation, gender identity or expression, national origin, age, disability status, genetic information, veteran status, or any other characteristic protected by federal, state, or local law.

In accordance with the Americans with Disabilities Act (ADA) and applicable state and local laws, we provide reasonable accommodations to qualified individuals with disabilities to help them perform the essential functions of their job. If you need assistance or an accommodation during the application process or while employed, please contact Human Resources at Talent@myfbm.com.

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.