Harish Gubber Email & Phone Number

Bengaluru, Ka, In

Bengaluru, Karnataka, India

• Plan, coordinate, develop and support EDW development including architecting table structure, building ETL process, documentation, and long-term preparedness • Analyze, design, develop, implement and maintain technical solutions in Informatica using data warehouse technologies, MS SQL, Oracle and ETL solutions • Develop ETL solutions to send/receive feed to/from Financial Institutions and Integrations with Informatica Power Center and MS SQL server. • Develop cross validation rules to ensure data accuracy • Shares in the technical supervision of a small team of onshore/offshore development and quality assurance resources to insure timely delivery of all ETL solutions • Define technical approach documents (define calculated logic, process flow) • Meet business requirements of the projects as new data sources are added • Provide production support of existing ETL processes and Integration Solutions. • Document steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production • Provide regular project updates to Information Analysts and management as needed • Communicate issues, risks, and concerns proactively to management and engage colleagues while working in a hybrid Agile/Scrum process • Document ETL process thoroughly to allow peers to assist with support as needed • Provide technical supervision and task delegation to a flexible team of staff engineers, consultants and interns in close coordination with team Managers and Directors

Bengaluru, Karnataka, India

• Understanding & mapping client’s requirements to the project, Provided Technical Solutions during the process of creating new mappings to the Dev team, Created Informatica Mappings, Sessions and Workflows.• Performed Impact Analysis and provided solutions for the changes which were suggested by the Business.• Review of the Mappings, Session and Workflow as per the client Standards developed by the team. • Analyzed the existing mapping logic to determine the reusability of the code• Develop and maintain UNIX shell scripts for ETL job automation process.• Involved in performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.• Created Stored Procedures, Triggers, Views and Packages using PL/SQL• Worked with the testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project, and also fixed the defects before moving the jobs into production.• Performing ETL & database code migrations across environments• Documented the process for further maintenance and production support

Bengaluru Area, India

 Designing & developing high performance ETL solutions and performance management Active participation during the requirements analysis and proposal  Extracted data from salesforce (SFDC), Teradata, MS SQL, Oracle database and files and staged into a single place and applied business logic to load them in the central Teradata database Used Informatica Power Center 9x for extraction, transformation and load (ETL) of data in the data warehouse Parameterized the mappings and increased the re-usability Used Informatica Power Center Workflow manager to create sessions, workflows, and tasks