Informatica Administrator Resume Sample
Work Experience
- Senior level Informatica Admin with extensive experience in Informatica PowerCenter, Installation and configuration of Informatica Power Center
- Manage new installations, hot fixes, configuration, and troubleshooting of Informatica platform including hardware, and software
- Plan, test, and execute upgrades involving Informatica components; Assure Informatica platform stability and security
- Design, document, and implement administration producers, security model, backup, and failover / recovery operations for Informatica platform
- OS Level statistical monitoring and performance tuning
- Managing the DEV/QA/UAT/PROD environments with High Availability
- Provide troubleshooting and diagnostic support. Incident, problem and service outage management
- Understand and study new features released by Informatica, educate the ETL team by sharing the knowledge.
- Informatica Data Masking administration & configuration
- Experience with Informatica Monitoring & performance tuning tools
- Informatica High-Availability/redundant configurations
- Strong experience in administration and support of Informatica PowerCenter, Web services, Data Quality and PowerExchange-CDC in a Unix or Linux environment
- Experience in Architecture Assessment, Capacity Planning, System Architecture Design for High Availability and Load Balancing/Grid Configuration of Informatica
- Experience in administration of Informatica Developer, Informatica Data Analyzer and Web services
- Understanding of change control management and production support processes
- Able to prepare implementation and contingency plan for supported applications
- Experience managing offshore resources
- Proven strategic and critical analysis skills
- Informatica certified Expert designation desirable
- Opening Informatica SR’s (service requests) and working with INFA support to investigate/resolve issues
- Specific technical skills for an Informatica Administration
- Experience with Informatica Administration of Change Data Capture, Connectors, Cloud, PowerExchange, and Proactive Monitoring, Metadata Manager, and Data Quality
- Monitoring the Informatica environment
- Users and privileges administration
- Experience working in a hybrid environment (high mix of cloud and on premise systems and applications)
Education
Professional Skills
- Strong verbal and written communication skills with the ability to articulate issues during agile ceremonies (daily standups, retros, demos, etc.)
- Hands on experience in code promotions to various environments and sandboxes with multi domain and environment management skills
- Strong personal interaction, confidence, and verbal communication skills
- Excellent communication (verbal and written) and professional skills are required
- Three to Five years’ experience working with SharePoint Platform (with recent experience using MOSS 2007) in an administrative capacity
- Experience with various operating platforms, metadata management, and extensive experience with SQL and ETL
- Monitoring and troubleshooting experience with performance slow down and latencies related to servers, nodes etc
How to write Informatica Administrator Resume
Informatica Administrator role is responsible for integration, training, database, security, architecture, analysis, reporting, design, modeling, administration.
To write great resume for informatica administrator job, your resume must include:
- Your contact information
- Work experience
- Education
- Skill listing
Contact Information For Informatica Administrator Resume
The section contact information is important in your informatica administrator resume. The recruiter has to be able to contact you ASAP if they like to offer you the job. This is why you need to provide your:
- First and last name
- Telephone number
Work Experience in Your Informatica Administrator Resume
The section work experience is an essential part of your informatica administrator resume. It’s the one thing the recruiter really cares about and pays the most attention to.
This section, however, is not just a list of your previous informatica administrator responsibilities. It's meant to present you as a wholesome candidate by showcasing your relevant accomplishments and should be tailored specifically to the particular informatica administrator position you're applying to.
The work experience section should be the detailed summary of your latest 3 or 4 positions.
Representative Informatica Administrator resume experience can include:
- Significant experience with data quality, data profiling, data cleansing, metadata management and reporting
- Strong proficiency in SQL programming, query writing, query performance tuning, and database technologies
- Experience with Unix Shell Scripting including troubleshooting
- Experience managing and administering (not developing) the Informatica platform
- Good understanding of ETL/Database best practices and leading industry standards
- Involved in the validation of the OLAP Unit testing and System Testing of the OLAP Report Functionality and data displayed in the reports
Education on an Informatica Administrator Resume
Make sure to make education a priority on your informatica administrator resume. If you’ve been working for a few years and have a few solid positions to show, put your education after your informatica administrator experience. For example, if you have a Ph.D in Neuroscience and a Master's in the same sphere, just list your Ph.D. Besides the doctorate, Master’s degrees go next, followed by Bachelor’s and finally, Associate’s degree.
Additional details to include:
- School you graduated from
- Major/ minor
- Year of graduation
- Location of school
These are the four additional pieces of information you should mention when listing your education on your resume.
Professional Skills in Informatica Administrator Resume
When listing skills on your informatica administrator resume, remember always to be honest about your level of ability. Include the Skills section after experience.
Present the most important skills in your resume, there's a list of typical informatica administrator skills:
- Experience in Informatica ADMIN Skills
- Very good Unix/Linux scripting experiences and DB knowledge
- Good experience on Client facing role
- Role Specific Experience: 7+years of experience in Informatica Administration
- Good experience Business Object ADMIN
- Experience coordinating effective communication between teams
List of Typical Experience For an Informatica Administrator Resume
Experience For Senior Informatica Administrator Resume
- Experience with multiple database platforms including Teradata, Oracle and SQL Server. Working knowledge of Informatica Grid Environment
- Experience in Release Management Processes – Leveraging Informatica / and or 3rd Party Tools & Utilities
- Experienced in managing share (multi-users) Informatica environments
- Experienced in analytical reporting of job/workflow performance
- Experienced in BI/ visualization and reporting solutions Tools (BO, Tableau, Micro-strategy
- Experience as an Informatica Administrator (5-7 years)
- Experience with the CA-ESP scheduler
- Experienced in system & performance management (Unix/Linux/Database environment)
- Experienced in SQL, XML, Java, Web services
Experience For Informatica Administrator, Associate Resume
- Experience with Job Schedulers – such as Autosys / ESP
- Working knowledge of AD authentication models and LDAP integration to Informatica PowerCenter v10.x
- Coordinating downtime with the application support team to perform upgrades and install hot fixes
- Supporting current configuration of Unix and BTEQ scripts, Informatica objects and connections to multiple database platforms
- Understanding of database design concepts and best practices, and management techniques
- Informatica capacity planning and on-going monitoring (e.g. CPU, Memory, etc.) to proactively increase capacity as required
- Responsible for developing and implementing certain components within the Integration Solution projects
- Participate in all facets of projects, including planning, design, requirements, documentation, construction and implementation
- Provide answers to client inquiries concerning reporting and support
Experience For HBO Informatica Administrator Resume
- Document and provide support; resolve issues to ensure that the system is functioning according to specifications
- Perform data profiling and analysis using Informatica suite
- Monitor ETL workflows and logging, providing job reports and status as required
- Understand data access and data load processes for storing and retrieving data from relational databases and other file systems
- Documentation, and knowledge sharing
Experience For Lead Informatica Administrator Resume
- Involved with performance tuning of SQL
- Informatica Admin required for supporting the entire enterprise Informatica platform
- Help conduct technical research, testing, evaluation and documentation of tools and methodologies to ensure that tools are current and functional
- Work in partnership with system administrators and engineering groups to assist in the design changes to equipment
- Assist in performance tuning of ETL processes
- Manage the server by monitoring disk space, memory, CPU etc
- ETL code debugging and management
Experience For Informatica Administrator Lead Resume
- Provide Informatica system administration and improve the design of existing Informatica mappings
- Consult with users, management, vendors, and technicians sto assess computing needs and system requirements
- Provide educational/mentoring to project teams and others
- Architect environment with Informatica Product Suite following the best practices
- Configure and administrate BCPDR or Load Shift testing
- Deploy Informatica code by using team based development features
- Configure ODBC driver connection to Notes and Windows server using Informatica provided driver or third party driver
- Knowledge of PL/SQL stored procedures
Experience For Informatica Administrator Resume
- English fluency – written and verbal/spoken
- Take initiative and uncover opportunities for continuous improvement
- Manage all backup, restore, and disaster recovery processes and procedures. This includes understanding how to execute all procedures and meet all related SLA’s and/or RTO’s
- Communications with business stakeholders
- Installation and upgrade of data integration products, data quality, MDM
- Manage assigned resources per company’s methodology and processes
- Preference to have worked in recent versions of Informatica and upgrades
Experience For Senior Informatica Administrator Resume
- ETL professional with sound knowledge of Architecture and Administration of Informatica Product Suite
- Proficiency in security administration support with respect to users and privileges management with in the Informatica domains
- Lead or participate in sessions with consumers of data services to define their requirements with respect to access, logical structure, and accessibility
- Partner with other IT teams to deliver department and company initiatives
- Assist with estimates on costs and schedule for required changes to system baseline configurations
- Advise IT and business consumers on solution alternatives
- Learn applicable standards and best practices
Experience For Informatica Administrator, Associate Resume
- Work with development teams and designers to learn architectural requirements to ensure client satisfaction with product
- Help identify issues and suggest ways to help correct or tune performance issues
- Refer inquires as necessary to appropriate personnel
- Provide end user support related to access and software installation and maintenance
- Informatica and Oracle certification desired
- Install and configure Informatica environments
- Security implementation in both Native and LDAP domains
- Troubleshoot and resolve issues with Informatica application. Work with Informatica vendor support if required
Experience For HBO Informatica Administrator Resume
- Assist ETL users with issues related to access, configuration or any other infrastructure related issues
- Create and Manage repository and create folders for users, groups, assign rights and privileges
- Apply the correct ETL design to push data to required targets
- Refactor mappings and continued development of object-based Informatica environment to enable developers to easily create mappings that can be reused across multiple platforms
- Install and configure Informatica components for both Power Center and Big Data editions, including high availability; managing server activations and deactivations for all environments; ensuring that all systems and procedures adhere to organizational best practices
- Day to day administration of the Informatica Big Data Edition and Power Center suite of services
- Manage licensure on Informatica environments
- Work with other developers, testers, DBAs, project managers, and client business users and developers to develop specifications and resolve issues
Experience For Lead Informatica Administrator Resume
- Troubleshoot and support production processes
- Perform ETL failure recovery when required
- Familiarity with Kerberos v5.x configuration and integration to Informatica PowerCenter or Big Data Edition
- Install, Administrator Upgrade and Manage Informatica MDM platform – master data management (previously known as Siperian) including application servers for cluster and high availability needs
- Participates in administrative activities related to MDM platform including but not limited to MDM hub, Process Server, Active VOS, Provisioning and IDD
- Be able to configure MDM Hub Server according to specifications, including matching rules, SIF framework, and migrating components from one environment to other
- Participate in code reviews of application components developed by technology team other staff for standards adherence, efficiency and use of best practices
- Study and evaluate user problems and operations in order to produce operational and business continuity matrix
- Establish yourself as a trusted advisor with key internal and external stakeholders
List of Typical Skills For an Informatica Administrator Resume
Skills For Senior Informatica Administrator Resume
- Experience in setting up and tuning Powercenter Integration Services
- Extensive scripting experience withing Linux/Unix
- Experience in a healthcare setting and knowledge of medical coding systems, i.e. ICD9, CPT, HCPCS, ACGs is desirable
- Good in troubleshooting the complex reporting issues and Data discrepancy issues
- Good in troubleshooting the complex ADMIN reporting issues and Data discrepancy issues
- Experience upgrading Informatica when new versions are released
- Experience working as an Informatica Administrator
- Experience with data integration using Informatica
- Solid understanding of ETL best practices and industry standards
Skills For Informatica Administrator, Associate Resume
- Experience working on Informatica grid with multiple nodes
- Experience with ETL Code deployments (repository, folder, workflow and mapping level)
- Has at least 2 years of experience working on Informatica Administration
- Experience in the following areas below
- Experience supporting Informatica
- Informatica Master Data Management/Metadata Manager/Power Exchange/SQL Tuning experience
- Experience working with Informatica Power Center
- Experience with Linuix scripting required
Skills For HBO Informatica Administrator Resume
- Experience retrieving data from various database platforms, web service APIs, flat files, etc
- Relevant experience in the following technologies: J2EE, Java, SOAP based web services
- Two years relevant experience in the following technologies: J2EE, Java, SOAP based web services
- Experience with Tableau, SAS
- Experience with Military Heath System data
- Experience in BI Tools (Cognos, Business Objects)
- Experience with Informatica Cloud and Informatica PowerCenter
- Demonstrates ability to diagnose and resolve technical, management, and business issues and to recommend areas for process improvement or innovation
- Informatica 9.1 and above and Team Based Development experience
Skills For Lead Informatica Administrator Resume
- Informatica DataQuality experience
- Informatica PowerCenter experience
- Informatica, UNIX and ETL experience
- Hands on experience with OS patching, hot fixes and power center services management
- Hands on Experience with the Informatica PowerCenter v9.x and v10x Software Installation and Configuration
- Generally requires 5-10 years of experience
- Experience with AvePoint Tools
- Informatica administration with experience in multiple installations and upgrades
Skills For Informatica Administrator Lead Resume
- Experience in Informatica Administration
- Informatica administration experience
- Experience with Informatica connectors
- Three (3) to five (5) years of experience with BlueStack
- Three (3) to five (5) years of experience with Webshere and IIS
- Three (3) to five (5) years of experience in Software Development Life Cycle methods
- Experience in Informatica development
- Very good communication and attitude to take ownership and multiple responsibilities
- Experience with Informatica PowerCenter platform upgrades, installations and configuration
Skills For Informatica Administrator Resume
- Experience with Informatica connectivity to various data sources like sales force, web services, data bases etc
- Assist with development and integration efforts and the validation of associated work products
- Experience with Oracle or SQL Server RDBMS
- Informatica MDM experience required
- Demonstrated ability to work in a fast-paced, highly technical environment
- Good to have basic knowledge on Unix admin and database admin
- Experience with Informatica 9.5 or higher as an administrator
- SQL Server experience with T-SQL, SSIS, SSRS
Skills For Senior Informatica Administrator Resume
- Experience in a data warehouse and BI environment
- Experience with Oracle RDMS and associated tools/infrastructure
- Experience with installation and upgrade of Informatica PowerCenter 9.5 or higher
- Experience with relational databases (Microsoft, IBM, Oracle)
- Experience with Informatica & Power Center Administration
- Knowledge and/or Experience with administration of Informatica Enterprise Data Catalog
- Experience with administration of Informatica IDE/IDQ toolset
- Hands on experience with Informatica CDC Power Exchange setup
- Experience with installation in a Windows and Linux environment
Skills For Informatica Administrator, Associate Resume
- Firm understand ETL basic concepts of data flow, data enrichment, data consolidation, change data capture and transformation
- Experience with all phases of the Software Development Life Cycle (SDLC)
- Configuring/Maintaining/Testing Disaster Recovery environments
- Setting up Informatica environments, Installation and Configurations, configuring/maintaining ETL metadata repositories and Operational support
- Monitoring Informatica services and jobs in progress and managing user and group access in Informatica
Skills For HBO Informatica Administrator Resume
- Answering questions as needed and offering technical solution guidance
- Automating processes such as backups, monitoring
- Managing the overall stability of highly available Informatica infrastructure and applications
- Scheduling knowledge transfer sessions
- Administering Informatica on version 9.1 and above
- Working knowledge of the key elements & differentiators of PowerCenter V10.x and v9.6
- Working knowledge of Control-SA and AD authentication models and LDAP integration to Informatica PowerCenter v9.x/v10.x
- Understanding of SQl, Stored procedures, shell scripting, J2EE, JBOSS, XML, ETL, SOA, REST and Web Services technologies
Skills For Lead Informatica Administrator Resume
- Scripting (Bash, PowerShell, REST, SOAP) for task automation
- Troubleshooting and escalation
- Infrastructure resource governing, monitoring and reporting
- Provide dev, test, and production support (Break fix) by troubleshooting and fixing mapping/application issues
- Analyze and study data integration requirements to assist in designing, planning, and deploying needed capabilities
- Develop technical documentation for installation and configuration including networking and supporting data store
List of Typical Responsibilities For an Informatica Administrator Resume
Responsibilities For Senior Informatica Administrator Resume
- At least three years of experience using MDM tools, such as Informatica MDM
- Carry out consolidation of Informatica Platforms (2 or more) with Power Center
- IT administrator experience or its equivalent roles
- Experience in Informatica MDM Hub, Service Integration Framework on Informatica MDM platform
- Informatica PowerCenter - developer and administrator experience
- Informatica Master Data Management (MDM) - developer and administrator experience
- Experience performing Informatica upgrades and hot fix installations
- Experience with the Informatica security model, LDAP integration, and managing large ETL environments
Responsibilities For Informatica Administrator, Associate Resume
- Experience as an Informatica Administrator (6+ years)
- Good in Oracle PL/SQL
- Assist in troubleshooting and tuning data warehouse data and processes
- Promote data integration best practices and new features, while analyzing the impacts on existing modules/processes
- PowerExchange, metadata manager, connectors, and proactive monitoring
- Proficiency with Linux/Unix, coding complex SQL Logic and ability to write complex shell scripts
Responsibilities For HBO Informatica Administrator Resume
- Extensive UNIX scripting and administration background
- Nice to have exposure on Informatica/BOBJ reporting
- Provide recommendations regarding technology alternatives for the Enterprise Data Warehouse and Data Integration Layer
- Provide technical solutions to extend and enhance the Informatica service offering
- Operational support for 24 7 processing
Responsibilities For Lead Informatica Administrator Resume
- Co-Maintain the Enterprise Scheduling tool, Cisco Tidal
- Organization and updating all environment administrative documentation
- Management and monitoring of retention and backup processes
- Physical data modeling
- Installation and Configuration of the Informatica Product suite
- Configure Informatica components and assist infrastructure team on installation, upgrades and patches
- Daily tasks include: creating user accounts, ETL integrations/implementations/migrations, scheduling and monitoring jobs, performing root cause analysis for job failures and missed data loads, and providing server and database administrators with support for performance tuning
- Install, configure, upgrade, and apply EBF's with Informatica Suite - Power Center, Data Quality, Metadata Manager, Web Services, Jasper Soft, Complex Event Processing, Power Exchange with Oracle and Master Data Management
- Implement Informatica Products in platform migrations (IBM AIX to Red Hat Enterprise Linux or any other platform)
Responsibilities For Informatica Administrator Lead Resume
- Develop and foster a collaborative working relationship with the Business Intelligence and ETL teams, consultants, and project managers to develop processes, documentation, and solutions related to deployments
- Define tasks and estimate work effort for areas of responsibility
- Provide operational support for Informatica servers and recover servers in case of system failures
- Support migration of Informatica code (reports/models/ frameworks) from one environment to another
- Identify and investigate data quality/integrity problems, determine impact and provide solutions to problems
Responsibilities For Informatica Administrator Resume
- Analyze current application process and recommend improvements
- Maintain Informatica on IBM AIX and Linux Servers, keeping them in optimal health and taking necessary steps for better ETL performance, including but not limited to server parameters tuning
- Participate in the testing activities on the upgraded servers, proactively resolve environment related issues, find root causes, and take necessary steps to prevent them from happening again
- Extensive experience in gap analyses, and transition planning with Informatica Suite
- Platform support and supporting all project stakeholders with BI/DW project life cycle
- Work with Informatica technical support, when and if necessary
- Document processes and train team members within an onsite/offsite resource model
Responsibilities For Senior Informatica Administrator Resume
- Stay abreast of newer trends in tools and technologies
- Experience with Autosys/Tidal Scheduling, FeedHub, Tumbleweed File Transfer or related hardware and software applications, Informatica 9.6 Big Data Edition, Cloudera considered an asset
- Experience with Service Level Agreement (SLA’s), Change Management process and Informatica code migrations
- Develop processes that utilize reusable objects, repeatable design patterns and clear coding following project’s data integration standards and guidelines
- Pick new tools easily , teachability
- General Data Management knowledge-mainly data lineage and metadata management
- Expert knowledge of Informatica PowerCenter and PowerExchange 9.x or higher administration on Linux/Unix server platforms
Responsibilities For Informatica Administrator, Associate Resume
- ETL code deployment: 3 years
- Informatica Administration: 5 years
- Informatica PowerCenter: 4 years
- Data quality and reconciliation
- Understands Point of Sale data (e.g., Retail)
- Create complex SQL statements
Responsibilities For HBO Informatica Administrator Resume
- Lead for Admin stream
- Supporting the Production, UAT, QA and Development Informatica PowerCenter 10.1.x environments with responsibility for environment uptime and overall system performance
- Outlining best practices for Informatica repository usage, security controls, version control, code migration, Unix scripting, logging, and other development and deployment procedures
- Troubleshooting during system downtime to restore service (working with vendor if necessary), determining root cause and establishing procedures to avoid recurrence
- Supporting the system running on a Linux OS
Responsibilities For Lead Informatica Administrator Resume
- Complete understanding of code promotion activities and best practices
- Proficiency in Informatica Power Center 9.6/10.1x or higher (Designer, Workflow Manager, Workflow Monitor)
- Responsible for Informatica PowerCenter and MDM administration
- Work with the various functional and technical teams is responsible for data design, warehouse data architecture, metadata and assisting with the data integration layer’s repository creation
- Design and assists in developing complex data migration processes for the data warehouse