Job location: Santa Clara, CA
Job duration: Permanent position, Full time
Job description: Reviewing mapping/requirement documents based on the discussions with business teams/clients. Analyzing requirement to come up with transformation logic required to develop Informatica mapping and Oracle SQL/PL SQL code. Creating Design end-to-end solution for the requirement. Analyzing programming logic to determine the strategy to retrieve data from multiple heterogeneous database system, transform data as per business logic from multiple heterogeneous system to Oracle database management system and load data into Oracle database management system. Data analysis to ensure there exists no data issues and data anomalies and the requirements adhere to the business needs. Analyzing and Troubleshoot production issue if any. Developing ETL mappings using Informatica. Working with SQL, PL/SQL procedures and functions, stored procedures, and packages within the mappings. Importing XML, test, csv file from different source system to Oracle database. Programming UNIX script for Deployment of code in all the environments (SIT/UAT/PROD) as per release plan. Tune Informatica mappings and sessions for optimum performance. Resolving queries and guide team members with the optimal technical and strategic solutions. Code review of the created objects in Database and Informatica level. Writing SQL queries to validate the target tables’ data adheres to the functional requirements. Testing target data to ensure business requirements are developed proper. Tracking all the defects raised in different environments (SIT/UAT/PROD) till closure. Maintaining the component list for all the releases. Code execution in all the environments (DEV/SIT/UAT) as per release plan. Manage the environment for data refresh/deployment/execution and send communication to all stake holders. Monitor job executions and timings in production.
Education & Experience required: Required Bachelors or foreign equivalent in Computer Science, Computer Applications, Computer Information Systems, MIS, Engineering (Any), or any related field + 2 years of experience with the same or similar job duties but given another designation. Must be able to travel/relocate to various client sites throughout the U.S.
To contact or to apply please send resumes to Associate General Manager-HR, 2055 Laurelwood Rd, Suite # 210, Santa Clara, CA 95054 . Ref:
Published date: 1 Feb, 2021