Job Description :

Location: On-site Palo Alto,CA

Job Type: Contract (Long term)

Job brief

Informatica Technical Specialists In the project take end to end ownership of the project and you will do this by:

· Analyzing the data migration method from legacy application data format to distributed database formats and recommendations for processing.

· Analyzing the method of transforming existing data into a format for the new environment and the loading of this data into other database structures

· Developing, implementing, and optimizing stored procedures and functions using SQL

· Reviewing and recommending for improving the performance of the migration process

· Making necessary changes and supporting documentation

Responsibilities

  •  In-depth experience in Informatica Power Centre

  •  Design and develop PLSQL processes to perform complex ETL processes.

  • Should have the experience with snap logic

  •  Develop UNIX and Perl scripts for data auditing and automation.

  •  Responsible for database builds and change requests.

  •  Identify architecture gaps that can improve availability, performance, and security for both production systems and database systems and work towards resolving those issues.

  • Work closely with Engineering, Architecture, Business, and Operations teams to provide necessary and continuous feedback.

  • Automate all the manual steps for the database platform.

  • Deliver solutions for access management, availability, security, replication, and patching.

Requirements and skills

  • Should be willing to learn Oracle BI Apps concepts and other related tools.

  • Experience in other ETL technologies i.e. Talend. Pentaho

  • Experience in-stream data acquisition technologies i.e. Kafka, Spark, etc.

  • Exposure to Cloud analytics native services i.e. Azure, AWS, etc.

  • Working knowledge of any visualization tool like Tableau etc.

Note:  ** No Freshers, Candidates who are willing to do zoom call only apply**

Candidates need to be local and should go onsite upon needs

 



Client : Stanford University

             

Similar Jobs you may be interested in ..