Etl Architect And Sr Informatica Developer
Current• Gather requirements from the users (Drilling & Completion Engineers) to build dashboards and reports out of the IDW (Integrated Data Warehouse) for the EagleFord business unit to track various metrics such as costs, duration, optimum mud utilization, productivity and other KPIs during the various phases of Drilling and Completion of the wells• Analyze the data and build QA/QC reports to highlight the data quality issues within the source system (WellView)• Write specifications to map data out of source system into the target data warehouse (IDW), build the Informatica(ETL) code to extract and load the data into the IDW(Teradata database)• Build database views to denormalize the data for building several Spotfire reports and dashboards• Support users with their queries and errors within the reports• Integrate sensor data from external vendors into Teradata