Sushanth V Email & Phone Number

Charlotte, Nc, Us

Foster City, California

Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across application and systems.Used Meta Data Manager to gather data from different applications and flat files for users to do impact analysis of the changes in the source systems.Unit testing and System Testing of Informatica mappings and Workflows. Developed ETL code, control files, metadata, and lineage diagrams for ETL… Show more Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across application and systems.Used Meta Data Manager to gather data from different applications and flat files for users to do impact analysis of the changes in the source systems.Unit testing and System Testing of Informatica mappings and Workflows. Developed ETL code, control files, metadata, and lineage diagrams for ETL programs.Created and configured Workflows, Worklets, and Sessions to transport the data to target using Informatica Workflow Manager.Generated UNIX Shell scripts for automated daily load processes. Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations. Show less

Created and monitored Denodo tools like Custom view and caching for their performance.Monitored and tuned views in Denodo and Oracle and MySQL with JDBC connection.Identify complex data issues and to communicate with team members about data modeling.Analyze components or modules of large or complex systems for significant phases of larger, complex assignments. Co-ordinated monthly roadmap releases to push enhanced/new informatica code to production.Developed and maintained ETL… Show more Created and monitored Denodo tools like Custom view and caching for their performance.Monitored and tuned views in Denodo and Oracle and MySQL with JDBC connection.Identify complex data issues and to communicate with team members about data modeling.Analyze components or modules of large or complex systems for significant phases of larger, complex assignments. Co-ordinated monthly roadmap releases to push enhanced/new informatica code to production.Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 8.6 to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.Created mappings using different look-ups like connected, unconnected and Dynamic look-up with different caches such as persistent cache.Performed Impact Analysis of the changes done to the existing mappings and provided the feedback.Exposure and some development of the following: Enterprise Java Beans, Servlets, JSP, JSF, JavaScript, JQuery, Oracle, HTML, and CSS.Imported java function to denodo through java file. Show less

Used Informatica ETL extracts and load data from various investment applications (DB2, Flatfiles) into ORACLE.Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.Participated in the design of logical and physical Power Exchange data map.Managed all indexing, debugging, optimization and performance tuning using SQL Profile… Show more Used Informatica ETL extracts and load data from various investment applications (DB2, Flatfiles) into ORACLE.Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.Participated in the design of logical and physical Power Exchange data map.Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent.Developed database triggers and stored procedures using T-SQL cursors and tables.Designed, developed, and tested stored procedures, views and complex queries for Reports distribution. Show less