Description: 

·       Gather requirement, Analysing, Technical Solution design, Plan and Estimate of Enterprise application integrations, and automation processes for ETL Design and Business Intelligence solutions. 

·       Troubleshooting the ETL code error and finding out the Root Cause Analysis and providing the Break fix for the same, Monitoring the ETL Loads on daily basis. 

·       Coordinate with Business Application, Business Analyst, Functional and Technical Team on Functional, Technical Development, Plan, Estimate, Testing, Solution and manage day to day operations. 

·       Ad-hoc Support to business users for OBIEE reports/dashboards issues /implementation/solution issues. 

·       Code migration from one environment to other environment and User Acceptance Testing support and Production migration release management. 

·       Lead the technical team and provide timely and effective solutions to address user’s requirements. 

·       Developed extremely complex reports as per the customer’s requirements using different -different function to address business requirements. 

·       Developed report using Combining two subject areas and using Union, Intersect and Union All Operator. 

·       Monitoring ETL Loads if any issues occur during the ETL Process execution then resolving it.  

·       Conference Call with the Business Users, IT team, Business Analyst, and other Team members. 

·       Creating Mappings and Job plans in Matillion for loading data from Source system to Target system. 

·       Creating Master Job plans in Matillion which will trigger all the child components for data load execution. 

·       Creating meta data layer by creating sisense cube as per the reporting requirements. 

·       Creating Widgets/dashboards in Sisense as per the business requirements.