Job Description :
Role: Informatica Developer
Location: Plano, TX
Required Skills: 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

Looking forward to work with you