Veeresh Hatte Email & Phone Number

San Jose, California, Us

Vélizy-Villacoublay, Fr

Burlington, Ma, Us

Experience with Informatica ETL Tool, AWS, Cloudera1. Installed Informatica Server and Clients in the AMAZON WEB SERVICES CLOUD NETWORK for the training activity in the company.2. Configured Informatica and SQL Server for Domain Configuration Repository, Repository, User and Login information, Role and Security of Users.3. Worked partly on an internal financial project of NetSuite and OpenAir Integration.4. Worked with a client called ViroPharma in Pharmaceutical Industry for automating the detection of new and changed RAVE WebSite Serious Adverse Event Reports and sending them through email to the Safety Team.5. Upgraded Informatica 9.1.0 Server to 9.5.1.6. Configured Model Repository, Content Management, Data Intgeration and Analyst Services for Informatica Data Explorer, Data Quality.7. Documented the steps of upgrade of Informatica Server, Creation and Configuration of Informatica Data Quality Services.8. Imported and Created Data Domains to be used in Informatica Data Quality/Explorer.9. Installed Twitter and Facebook plug-ins.10. Created mapping to retrieve the Twitter keywords i.e. Entry and user data into SQL Server Database tables.11. Created mapping to retrieve the Facebook posts into SQL Server Database tables.12. Configured Cloudera CDH 4.2.0 on CentOS Linux version 5.9 using Oracle Virtual Box.13. Configured services HBase, HDFS, MapReduce, Flume, Oozie, Hive, Impala and Hue to stream Twitter data by connecting to my personal Web Based Twitter Application to my Hadoop Distributed File System.

Pune, Maharashtra, In

Responsible for Applying Concepts in Coding for the business CR’s, Metrics Report and the Source Team Report. Metrics Report has detail level counts of data elements reflecting source data and target data. Source Team Report has detail level information of successful records that migrated to target and failed records in the staging area. Thus, reports the number of successful and failed record to source team.Handled complex file generation and file reading problems in Informatica and implemented them successfullyWorked on UNIX Shell Scripting and wrote one Program as POC which reads a source file and creates readable and formatted source file as an input for project. Apart from being a Developer also involved in the following duties:Informatica 8.6.1 Administrator for One (1) Month for Non-Treasury Management Credential Migration Project. Executed a complete cycle of Enrollment Migration project from setting up an environment, Oracle Cleanup, Microsoft SQL Cleanup, loading sources such as flat files, oracle dumps, execution of INFORMATICA solution, generating target files and target tables. Documented complete cycle of enrollment migration project; currently stands as guide for step-by-step project execution.

Worked on 8.6.1 version.Used various transformations llike Source QualifierNormalizerTransaction ControlUpdate StrategyAggregatorConnected Look-UpUn-Connected Look-UpSQL TransformationRouterFilterExpressionSequence GeneratorRank TransformationWorked on many PoC's(Proof of Concept) through out the project and applied those in the project for various purposes.Worked as ADMIN for 1 month on Informatica 8.6.1.Written complex SQL queries.Used PL/SQL procedures, packages, functions to bring the commonality of processing logic in one shell. Thus, making reuse of the PL/SQL objects efficiently.Worked on performance improvement and SQL tunning part of PL/SQL and SQL queries.