Informatica Support 6-9 Yrs pune, Hyderabad - Capgemini

Capgemini

Verified Company

Hyderabad, India

1 week ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

Willing to work on shift and rotation shift on morning (6:00 AM-3:00 PM), Afternoon(2:00-10:30 PM), Night(9:30 PM-6:00 AM), Weekly Rotation shift

Excellent Communication and analytic skills
Techincal Skill in Informatica 10 PowerCenter components like PowerCenter Designer and Informatica workflow manager & Monitor to satisfy complex data integration needs.
Technical skills in Oracle PL/Sql, Unix, Scheduling tools Control-M,Autosys,Tivoli.
Good exposure on batch operations.
Strong trouble shooting and debugger skills.
Work closely with other teams DBA s, Network, Storage, Scheduling and User Admin to triage issues and resolve job abends.
Able to present the production issues to management and stake holders in NOC calls.
Experience with advanced PL/SQL Procedures, Triggers, Constraints, Cursors, Functions
Perform initial analysis of tasks, perform effort estimations based on Guardian standards, assign and monitor work queues.
Provide Review, Testing support and production deployment and postproduction (warranty) support for work deliverables
Ensure adherence to Guardian Security, Compliance and Development Standards for work deliverables.
Coordination with the Guardian SME s and participate in knowledge transition sessions
Establish, maintain, and enforce ETL design principles, techniques, standards, and best practices
Good knowledge of SQL and understanding level for pl/sql to troubleshoot such issues.
Clarity of thought and ideas for implementation of hotfixes/break fixes during production outage.

C1/C- Design and Develop the ETL process to performed Type1 and Type2 Dimensional table load and Integrate the multiple systems using Informatica Tools.

Develop and program UNIX shell scripts for validating and automating data quality rules and schedule batch jobs.
Create complex PLSQL packages, stored procedures, functions, Triggers, Views and exception handling for retrieving, manipulating, checking and migrating complex data sets in Oracle.

Primary Skills

Informatica

Secondary SkillsCompetencies