Client Technologies

V2Soft ( www.v2soft.com ) is a global company, headquartered out of Bloomfield Hills, Michigan, with locations in Mexico, Italy, India, China, and Germany. At V2Soft, our mission is to provide high-performance technology solutions to solve real business problems. We become our customer's true partners, enabling both parties to enjoy success. We are committed to promoting diversity in the workplace and believe it has a positive effect on our company and the customers we serve.

Experience:

• At a minimum, we are seeking a candidate with at least 6 to 8 years of advanced experience as an Informatica administrator with informatica developer skills with Oracle skills.

• The selected candidate will be responsible for Informatica Administration activities which will include administering Power center & Power Exchange/CDC (Change Data Capture).

• The candidate should be able to install any other software or tool based of the new tasks/ projects.

• This position will also be working as an administrator for Test Data Management (TDM) tool.

Responsibilities:

• Installation and configuration and patching of Informatica Power Center, Power Exchange and other related products.

• Managing the non-prod and prod environments with High Availability and GRID setup.

• Perform Informatica Power Center 10.x System Administration and Power Exchange 10.x System Administration.

• Experience with setting up access roles and privileges, code page setups, appropriate ETL migration activities, and scheduling jobs.

• Work with Systems Administrators, UNIX, Network and DBAs, scheduling and implementing software patches and upgrades.

• Experience in automation of monitoring Informatica environments using UNIX, pmrep, pmcmd and other Informatica command-line language.

• Support development teams with performance tuning, troubleshooting issues, and identify the root cause analysis for ETL job failures/Data issues raised by the business.

• Experience in handling Informatica deployment activities in various forms/methods

• Scheduling and Monitoring Informatica repository backups.

• Review of Informatica ETL design documents and working closely with development to ensure standards are followed.

• Knowledge of handling OLTP, real-time data synchronization activities, troubleshooting methods

• Installation and configuration and patching of Test Data management tool used for data masking.

• On-Call Support for Informatica as required during the weekends and off-hours.

• Scheduling real-time system jobs.

• End of Life system verification and upgrades.

• Perform regression testing and approve the overall upgrade or setup. In addition to Informatica experience candidates are required to have skills and experience in the following areas:

• Experience in working with Oracle databases

• Experience working in UNIX operating system with shell scripting

• Ability to work independently and to resolve complex issues

• Ability to effectively diagnose, isolate, and resolve complex problems pertaining to data infrastructure

• Ability to write SQL, PL/SQL, Oracle Stored Procedures, Functions, Packages and Database Triggers

• Ability to Tune Oracle SQL and PL/SQL performance

• Experience in logical database design and data models

• Advanced experience with ETL and data transformation solutions

• Experience working with Batch Processing

• Experience working with Test Data Management tool.

Preferred KSA's:

• Experience working Informatica, Oracle & Linux

• Take charge, can-do attitude

• Facilitation skills

V2Soft is an Equal Opportunity Employer ( EOE).

https://www.v2soft.com/careers - to view all of our open opportunities and to learn more about our benefits.