Location: On-site Palo Alto,CA
Job Type: Contract (Long term)
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
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.
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