We provide IT Staff Augmentation Services!

Informatica Administrator Resume

4.00/5 (Submit Your Rating)

MD

SUMMARY:

  • More than 11 years of experience in software development and maintenance with an earned reputation of meeting deadlines and delivering mission critical solutions. Excellent experience in Business requirement analysis, development, testing, documentation and followed SDLC
  • Experience in Autosys Scheduling Tool and UNIX, SQL, Java and PL/SQL, Oracle and Sybase.
  • Highly skilled in Development, Administration/Architecture, System Infrastructure, and Prod/Non - Prod Env Support
  • Working excellence on successfully implementing various complex projects in PowerCenter, IDQ, Cloud, ILM, and MDM etc.
  • Technically proficient to implement and support advance n critical requests for ETL, Cloud, IDQ, ILM, TDM, MDM and various other application n softwares
  • Experience in SharePoint Development for creating list with different features.
  • Experience in Agile Methodology and ITIL and got certifications in Scrum Master and ITIL
  • Certified AWS Associate Developer
  • Job responsibilities include Requirements Gathering, Analysis, Design, Coding, Code Reviews of other related modules, Unit Testing, Deploying applications, Defect Fixing, Performance Optimization.
  • Highly dedicated to produce professional work with highest quality and creativity.
  • Experience in client side programming using HTML, Java script, JSP, CSS, XML etc.
  • Excellent exposure in Banking and Finance.
  • Ability to work with Cross-Functional teams such as Business Analyst, Architects and Development Team etc.
  • Excellent communication and interpersonal skills, capability to quickly learn new technologies and assume any responsibilities.

TECHNICAL SKILLS:

Database: Oracle 12/10g/9i, MS SQL Server, PL/SQL, Sybase and Netezza.

Languages: HTML, CSS, DHTML, Java and Cold Fusion

Reporting Tools: iXP, WCC, CA Workload Automation

Operating Systems: Windows 8/2008/2000/XP, UNIX, AIX

IDEs: Text Pad, MS Visio, MS Excel, WASD 5.0 and RAD 6.0

Tools: Oracle Toad, Putty, Informatica Powercenter 9.6, Power Exchange 9.6.1, MDM 10.1, TDM, ILM, Informatica Cloud, SFG, Datastage, Teradata SQL Assistant, F-Secure SSH Client, Maximo, Splunk, Solution Manager, WINSCP, Sybase Central, Aginity Workbench for Netezza, Hummingbird, Remedy, Trident, RapidSQL, WebLogic, Apache Tomcat and Sharepoint 2010 and 2013

Change Management: ClearCase6.0, SVN and VSS

Scheduling Tool: Autosys and crontab

Bug Tracking Tool: Solution Manager and Remedy

PROFESSIONAL EXPERIENCE:

Confidential, MD

Informatica Administrator

Responsibilities:

  • Administration of Informatica Repository servers/services and Integration services/servers
  • Responsible to Lead the Admin box Activities and manage 5 resources for completing any requests coming from ETL Users/Business within 2 hours SLA time
  • Implement and maintain Infrastructure for PowerCenter, Cloud, MDM, IDQ and ILM
  • Maintenance of Metadata/ETL Shared Objects in different environments
  • Supporting Informatica upgrades. 9.1.0 to 9.6.1
  • Querying repositories for Analysis and dependencies
  • Maintenance and Monitoring scripts for Informatica server like Backup, Start-up and stop service, logs etc.
  • Supporting Project Teams regarding Performance, Administrative and Coding Issues
  • Migrating Data maps from one environment to other
  • Installed and manage support for All World Address Validation,
  • Implemented and installed and supported Single Line Validation, Human Task, Population Override, ADM Client for IDQ
  • On-call support for trouble shooting and resolving issues in Production
  • Working on administrative tasks like migrating all the objects from one environment to other environments, creating connections, maintaining repositories for Informatica Data Quality.
  • Supporting all users and working the developers to meet the goals on IDQ.
  • Supporting the jobs, creating the jobs and upgrades for Informatica Cloud.
  • Installing Informatica Lifecycle management (ILM) tool and supporting the tool.
  • MDM 10.1 - Administration like user addition, Migration from different environments, maintaining repositories and deployment of BDD.
  • Supporting IDD users and application support for MDM.
  • Involved in the analysis and providing inputs to the new jobs and its behavior
  • Involved in file transfers from production servers to other development servers
  • Involved in providing plans for maintenance activities in production and creates a plan for the team members to follow
  • Working very closely with Informatica Support for critical bugs and issues
  • Involved in providing knowledge transfers to the new team members
  • Deployment of releases, controlling access for the users
  • Maintaining JAWS application and creating reports for users as per the requirements
  • Develop Autosys jobs as per the requirements and code and test the same in the lower environments
  • Maintain server space and works on scripts for periodic cleanup
  • Point of Contact for Creating lists in SharePoint for all the artifacts and creating different views for the management

Environment: UNIX, Informatica 9.6.1, Informatica 9.1, IDQ 9.6.1, MDM 10.1, ILM, TDM, Cloud, Autosys R11, JAWS, Excel, MS Visio, Remedy, SharePoint, Textpad, WinSCP, Oracle 12 and PL SQL

Confidential, VA

Loan Accounting Initiative - L2 Production Support

Responsibilities:

  • Analyze the job flow and provide sufficient information to the higher management to make the process more efficient and reduce time
  • Performed as Scrum Master by performing Sprints and Sprint cycle planning for any development or testing activities.
  • Monitoring the jobs and create reports for each day to make sure all jobs are running fine and if any issues happens escalate to the corresponding team and resolves the same
  • Involved in the analysis and providing inputs to the new jobs and its behavior
  • Involved in file transfers from production servers to other development servers
  • Involved in providing plans for maintenance activities in production and creates a plan for the team members to follow
  • Involved in changes which is required in the production jobs
  • Involved in providing knowledge transfers to the new team members
  • Supporting all development activities and creating work flow for the team to follow
  • Supporting development servers and maintain server space
  • Automate the manual work and provide inputs for improvement
  • Responsible for Level 2 and Level 3 production support (24x7) for the applications which included review of the logs and first level root cause analysis and fixes.
  • Incident management using the Remedy Tool and provide reports to senior management on the incidents per month
  • Responsible for the plan and support during upgrade of servers and downtime activities
  • Deployment of releases, controlling access for the users
  • Thorough with the application and business understanding, resolved many critical Production issues with a quick turnaround time

Environment: UNIX, AIX, Java, Enterprise Messaging Service, Informatica 9.6.1, Autosys R11, WCC, Excel, MS Visio, Remedy, SharePoint, Aginity WorkBench for Netezza, BOBJ Reports, Textpad, WinSCP, Oracle 12 and PL SQL

Confidential, VA

OOR Migration Support Lead

Responsibilities:

  • Leading the team of 12 members and Point of contact for Access request, Ticket creation, Test case approvals and execution and reporting to Senior Management.
  • Performed as Scrum Master by performing Sprints and Sprint cycle planning for testing activities.
  • Analyze the applications and create test cases for Disaster recovery and contingency environment
  • Checking the required access required for each application and creating a list for the same for the team members to raise it.
  • Involved in creating POC list for 263 applications so that team can check with corresponding teams for any issues
  • Point of Contact for Creating lists in SharePoint for all the artifacts and creating different views for the management
  • Involved in creating tickets for testing effort and also capture issues during testing phase.
  • Involved in providing knowledge transfers to the new team members
  • Supporting all development activities and creating work flow for the team to follow
  • Supporting development servers and maintain server space
  • Automate the manual work using QTP and provide inputs for improvement
  • Acted as lead and Quality anchor for the team for Standards of the code and process to be followed
  • Documented all the features so that team can reuse the same.
  • Incident management using the Remedy tool and provide reports to senior management on the incidents per month
  • Responsible for the plan and provides guidance for the team for new logic etc.
  • Controlling access for the users and revoking access for production environment once the testing effort is completed
  • Responsible for sending reports for the stakeholders every week.
  • With good application and business understanding, resolved many critical testing efforts with a quick turnaround time

Environment: UNIX, AIX, Java, Enterprise Messaging Service, Autosys, iXP GUI, Excel, MS Visio, Remedy, SharePoint, Text pad, WinSCP, WebLogic, Tomcat, QTP, Quality center, SQL, Oracle, Sybase, HummingBird and PL SQL

Confidential, NC

SAP-ECC Automation Developer

Responsibilities:

  • Leading the team of 4 members and Point of contact for Automation
  • Analyze the Business requirements and provide sufficient information to the higher management to make the process Automated using Autosys jobs.
  • Develop Autosys jobs as per the requirements and code and test the same in the lower environments
  • Involved in the Business Analysis and provided solution to the complex logic requirements
  • Involved in Connection settings from UNIX server to different other environments
  • Involved in providing Knowledge to the testing team and production team for the new changes and provides documentation for the same
  • Involved in Testing the codes in lower environments and worked with closely technical team to resolve issues if any
  • Involved in providing knowledge transfers to the new team members
  • Supporting all development activities and creating work flow for the team to follow
  • Supporting development servers and maintain server space
  • Automate the manual work and provide inputs for improvement
  • Acted as lead and Quality anchor for the team for Standards of the code and process to be followed
  • Documented all the features so that team can reuse the same.
  • Incident management using the Solution manager and provide reports to senior management on the incidents per month
  • Responsible for the plan and provides guidance for the team for new logic etc.
  • Deployment of releases, controlling access for the users
  • Thorough with the application and business understanding, resolved many critical requirements with a quick turnaround time

Environment: UNIX, Datastage 8.5, Autosys, iXP GUI, Excel, MS Visio, Solution Manager, SharePoint, Text pad, WinSCP, Maximo, Quality center, SQL and PL SQL

Confidential, NC

L2 Production Support Automation Lead

Responsibilities:

  • Leading the team of 15 members and Point of contact for the production
  • Analyze the job flow and provide sufficient information to the higher management to make the process more efficient and reduce time
  • Monitoring the jobs and create reports for each day to make sure all jobs are running fine and if any issues happens escalate to the corresponding team and resolves the same
  • Involved in the analysis and providing inputs to the new jobs and its behavior
  • Involved in file transfers from production servers to other development servers
  • Involved in providing plans for maintenance activities in production and creates a plan for the team members to follow
  • Involved in changes which is required in the production jobs
  • Involved in providing knowledge transfers to the new team members
  • Supporting all development activities and creating work flow for the team to follow
  • Supporting development servers and maintain server space
  • Automate the manual work and provide inputs for improvement
  • Responsible for Level 2 and Level 3 production support (24x7) for the applications which included review of the logs and first level root cause analysis and fixes.
  • Incident management using the Solution manager and provide reports to senior management on the incidents per month
  • Responsible for the plan and support during upgrade of servers and downtime activities
  • Deployment of releases, controlling access for the users
  • Thorough with the application and business understanding, resolved many critical Production issues with a quick turnaround time

Environment: UNIX, AIX, Java, Enterprise Messaging Service, WebLogic, Datastage 8.5, Autosys, iXP, Excel, MS Visio, Solution Manager, SharePoint, Textpad, WinSCP, Maximo, SQL and PL SQL

Confidential

SAP-ECC Automation Developer

Responsibilities:

  • Involved in the analysis of the data visualization with the clients
  • Responsible for the Data flow from various sources into Think map tool
  • Work with the Business analysts to understand the logic and flow.
  • Worked on setting connection between think map and different data sources to pull data to the tool
  • Worked on Automation of some of the tasks using Autosys.
  • Train and mentor the team members on workflows
  • Work with team members on the development and enhancement for the flows

Environment: Eclipse, Excel, VSS, Weblogic, Tomcat, Think Map Visualization Tool, Autosys, Java, UNIX, JSP, XML and SQL

Confidential 

SAP-ECC Automation Developer

Responsibilities:

  • Involved in Automation of Data Quality Testing
  • Team Lead and responsible for the Data Quality Testing.
  • Data quality check and development of transformation logic to perform data cleansing and standardization.
  • Involved in Data flow Diagrams and Mappings to the users.
  • Involved in Scheduling jobs in Autosys
  • Involved in finding the defects in code logic in Data quality
  • Interact with the key business users to perform requirements gathering, address issues, and provide information and analysis.

Environment: Teradata SQL Assistant 12.0, Excel, UNIX, Microsoft Visio and Autosys

Confidential

SAP-ECC Automation Developer

Responsibilities:

  • Involved in the enhancement phase of the Confidential Web access.
  • Involved in setting parsers for loading data from various platforms like Informatica and Mainframe into Confidential Server
  • Involved in the Report Generation for the data’s loaded and jobs scheduling using Autosys
  • Involved in retrieving information and loading data to Confidential from a Basic Teradata Query (BTEQ).
  • Training and Mentoring Junior team members.
  • Doing feasibility analysis and suggesting enhancements/Remediation.

Environment: WSAD, Weblogic, Tomcat, Excel, VSS, Java, UNIX, SQL, Autosys and JSP

Confidential

SAP-ECC Automation Developer

Responsibilities:

  • Responsible for development of New promotional pages for the Bank
  • Responsible for requirement analysis, enhancements
  • Code review and integration testing System testing and bug fixing
  • Analysis of Enhancement requests/New requirements, estimations and deployment to production
  • Training and Mentoring Junior team members.
  • Thorough with the application and business understanding, resolved many critical Production issues with a quick turnaround time
  • Defect fixing and logging the defects in the system for betterment of future work.
  • Properly Maintaining the trackers and Reusable Components for further use

Environment: Cold Fusion, XML, HTML, Java Script, CSS, SIMON, VSS, Clarity, WSAD, Weblogic, Apache Tomcat and SSH

We'd love your feedback!