Job Description :
Role: Informatica Developer
Location Plano, TX

Required Technologies Informatica, PL/SQL, control M, Autosys
Job Description: • Supporting production operations of ETL data warehouse by continuously monitoring the Scheduled Daily, Weekly and Monthly Mart load jobs.
· Fixing the production ETL job failures within the defined SLA.
· Working closely with App Dev Teams on the changes/fixes being implemented.
· Taking care of Incident Management, Problem management, Change Management for the team.
· Troubleshooting production issues that involves analysis from Application perspective and Leading P1 incidents.
· Performing root cause analysis for the production issues.
· Producing daily batch status reports to stakeholders.
· Communicating end users of the Mart tables status whenever batch processing gets delayed. Supporting end users requests and queries.
· Creates and knowledge base articles and CMDB to reflect accurate information related to system functionality and troubleshooting
· Configures and recommends configuration changes to improve system stability and performance
· Works with all teams within IT to implement changes in various systems
· Provides hands-on installation and support for deployed solutions in accordance to the transition book requirements. (remote, phone and email)
· Point of technical escalation for Tier 2 support team and act as Tier 3 support to root cause ongoing issues within systems and software
· Assists with IT projects as needed
· Adheres to organizational ITIL and ITSM standards as appropriate to Bank’s technology framework
· Ensures adherence to, and maturity of fundamental operations processes such as Incident and Problem Management
· Attends and participates in regularly scheduled team meetings.
· Available for on-call and emergency response as needed.
· Identifies and escalates business and technical opportunities as appropriate.

Experience with Database, SQL scripting
Experience with PowerShell scripting

Years of Experience Required 7+