We provide IT Staff Augmentation Services!

Informatica Administrator/team Lead Resume

DallaS

PROFESSIONAL SUMMARY:

  • Informatica Administrator/developer with 12 years of IT experience in Data warehousing, Business Intelligence.
  • In - depth knowledge with hands-on experience on a variety of Datawarehouse tools and technologies like Informatica, Oracle PL-SQL, Teradata SQL Assistant, Tara Gui and UNIX
  • Worked in various roles like Developer, Administrator, Systems Analyst, Module lead and Team Lead at different GE Businesses, NBC Universal Studio Business and AT&T/Amdocs Business
  • Proven ability to conceptualize, design and implement solutions
  • Thorough understanding of Software Development LifeCycle (SDLC) including requirements analysis, system analysis, design, development, documentation, testing, implementation and post-implementation review
  • Possess wide range of IT industry experience with Banking / Finance, Insurance, Invest Banking,Telecom etc.
  • Extensive experience with ETL tool Informatica in designing the Workflows, Worklets, Mappings, Configuring the Informatica Server and scheduling the Workflows and sessions using Informatica Power Center 9.5.1/9.1/9.0/8.6.1/8.5/8.1.1/7.1.3
  • Proficient in Extracting, Cleaning, Transforming and Loading the data using all the Transformations in the ETL tool Informatica
  • Vast experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
  • Experience with reading from Mainframe datasets and Cobol Sources using Informatica Power Exchange.
  • Configured Power Exchange connections for SAP, Sales Force applications.
  • Experience in integration of various data sources definitions like SQL Server, Oracle, Flat Files, XML and XSDs.
  • Installation and configuration of Informatica servers and client environments.
  • Involved in debugging and Performance tuning of targets, sources, mappings and sessions
  • Automated system health checks using shell scripts.
  • Strong experience in installation of Informatica on UNIX, Migration of repositories, and upgradation of repositories.
  • Involved in a role as an Informatica Administrator in upgrading the repository database and giving permission to various groups of users and testers
  • Good experience in maintaining Oracle, ODBC connections and installing and maintaining various new database connectivity software and Informatica plugins for respective softwares
  • Closely worked with the DBA in creating tables, migrating tables to different environments and obtaining permissions on various tables, Actively worked with Unix teams and Sys admins in rolling out the updates and hotfixes
  • Have good experience as informatica administrator in creating domains, repositories and folders, applying hotfixes and updating to new versions
  • Involved in preparing migration documents to move the mappings from development to production repositories
  • Good Knowledge on using scheduling tools to automate running of Informatica workflows
  • Involved in UNIX shell scripting, FTP and file management in various UNIX environments
  • Team player and self-starter with good communication skills and ability to work independently and as part of a team
  • Collaborated onsite teams, interacted and well managed various offshore teams.
  • Excellent communication and interpersonal skills, ability to learn quickly, good analytical skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica cloud, Informatica Power Center 9.5.1/9.1/9.0/8.6.1/8.5/8.1.1/7.1.3, Informatica Power exchange

Dimensional Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling

Project Management: Team Handling, Effort estimation, Client communication and reporting, Quality Assurance

Data Bases: Oracle7.x/8.1/8i/9i/10g, MS SQL Server 2000/2005/2008, Sybase, DB2, Teradata 12/13/14, Salesforce.com,Informix

Tools: Mercury Quality Center, Toad, Taragui, Teradata SQL Assistant, Erwin, PL SQL Developer,SQL Developer

Languages: SQL, PL/SQL, HTML, XML, Unix Shell Scripting

Operating Systems: Redhat Linux 5.1, 5.3,SunOS, AIX 5.3, Windows 2000/2003,XP,Window 7

Business Areas: Retail finance and banking, Investment Banking and Insurance, Media and Entertainment.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas

Informatica Administrator/Team Lead

Roles & Responsibilities:

  • ECR SIS call reviews (Emergency CR Deployments)
  • SIS call reviews (Weekend deployments)
  • CRs/ECRs/Batch only CR's deployments in production.
  • Informatica folder/Mapping/Workflow migration.
  • Informatica New connection creation(teradata,oracle )
  • Directory structure creation for Batch
  • Directory structure creation for Informatica
  • Unix file/Schedule migration, Unix file migrations using SVN
  • Compose Maestro schedulers,TWS activities, Modify Parameter, Modify Calender
  • Maestro Deployments
  • AOTS trouble tickets resolution, Webtrax WR tickets resolution.
  • DW BID Collection tables update.
  • Reporting activities (Deployment Plan, Issue report,Deployment statistics,Deployment Report)
  • Unlocking maping,workflow,session in informatica 8.x/9.x
  • Folder,User and Group creation in Informatica 8.6 admin console
  • Informatica Troubleshooting from Infrastructure side
  • Working with Informatica Support for patch implementation troubleshoot user issues
  • ODBC Setup
  • Application Retiring Process (Folder backup, repository, domain, filesystem etc)
  • Setup of informatica on Citrix
  • Performed Informatica upgrade from 8.6 to 9.1.
  • Participate in capacity planning and coordination with IT infrastructure engineers.
  • Keeps up-to-date on vendor license agreements and maintain license inventory.
  • Automated server health checks and file system memory management using shell Scripts.
  • Work with application teams to fulfill database tasks (creating databases, accounts, tables, etc.)
  • Creation and configuration of integration services to run on the Grid.
  • Installed and configured HA architecture to makes system available at any given point of time.
  • Created and configured Operating system profiles to maintain the security between the project teams.
  • Configured Teradata Loader connections, SAP, Sales Force application connections.
  • Backup and restore of domain and Repository services.
  • Automated System health checks and implemented alerting mechanism using Shell Scripts.
  • Worked with Network, Operating system teams for any system related performance issues.
  • Worked with Firewall Team for adding new system entries to Server.
  • Worked with release management teams for infrastructure related outages like Password change, Operating system patch, application upgrade activities.
  • Worked on installation of Informatica,HotFix,EBF,TPT API,TTU
  • DR Setup
  • UnixtoLinux Project implementation
  • Coordinated with different teams DBAs,storage ops,system admins,server ops etc.

Environment: Informatica 9.1, Informatica cloud, Oracle 11, Teradata 13/14,Redhat Enterprise Linux, Redwood enterprise scheduler, Putty,BMC Remedy

Confidential, Stamford

Lead Informatica Developer

Roles & Responsibilities:

  • Developed error handling strategy which was implemented enterprise wide as a standard to process data from all source systems, the process uses a re-usable Informatica code which uses custom SQL queries to populate the errors from source system
  • Lead a group of 10 or more junior and senior developers on a variety of development projects which involved moving data from different sources to Enterprise Data Warehouse
  • Extensively used mapping parameters and variables, created Informatica workflows to automate the creation of parameter files
  • Actively involved in standardizing Informatica code practices and documenting the standards followed enterprise wide
  • Part of Code review and design review boards responsible for making sure the codes adhere to the UPMC standards and signing off the Informatica solutions before development, respectively
  • Used deployment groups, repository queries and labels to actively deploy Informatica code from one environment to the other
  • Worked extensively on developing re-usable logics which are used in multiple projects
  • Developed ETL process which audit’s ETL loads, passes incremental parameters and deletes bad data in the case of partial runs
  • Work involved understanding the new business requirements in existing system and then designing the ETL architecture.
  • Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
  • Create mappings to build business rules to load data.
  • Various transformations (SQ, lookup, Router, aggregators, filters, SG and UPS) were used to handle situations depending upon the requirement.
  • Done performance tuning in Informatica. Implemented slowly changing strategy to manage the data in the dimension tables.
  • Responsible for creating reusable transformations and Maplets.
  • Prepare the Weekly Status Report and attend the weekly call with the Client.
  • Enhancement the existing Project as per requirement
  • Fixing the Bugs in existing system
  • Automation of existing scripts and Manual activities

Environment: Informatica 9.1hotfix2, oracle 11g, PL/SQL Developer, Informatica Power Center 8.xSQL, PL/SQL,PL SQL Developer,SQL Developer,HPSM,HPQC

Confidential, New York

Senior DW ETL Informatica Admin

Roles & Responsibilities:

  • Setting up and configuring enterprise Informatica Implementation with PowerCenter 8.X (8.6 and further preferable) on UNIX and Oracle 10g and greater
  • Extensively work in installing/configuring PowerExchange.
  • Using PMSTACK, truss to generate core dumps for Long running and hanging jobs to isolate the issue.
  • Automated creation of project related folders in both Informatica and Linux.
  • Create and maintain the software migration process, coordinator and implement improvements to the migration process.
  • Closely work with Informatica Corp for product issues, licensing and understanding product roadmaps
  • Maintaining security through effective management of users/groups
  • Working with off shore (India) team. .
  • Extensively worked in Implementation of patches and upgrades.
  • Implementation of maintenance activities like Power downs / Reboots etc
  • Performed server file handle checks to avoid any server related performance issues.
  • Extensively worked in Implementation of patches and upgrades.
  • Extensively worked in automation of deployments to Production from Test environment
  • Coordinating with internal clients / storage /UNIX / DBA teams to resolve issues
  • Providing technical support for the Informatica environment.
  • Automated process to update repository statistics and purge the repository logs, to improve the performance of the repository.
  • Automated repository and Domain related backups using shell scripts.
  • Worked on a POC for installing informatica 9.5
  • Collected Informatica logs from server and administrator tool and analyzed them along with Informatica technical support to determine the root causes in the cases of Informatica outages
  • Upgraded informatica environment from 8.6 Hotfix 4 to 9.1.0 Hotfix 5
  • Planned all the installation steps and documented the checklist during every hotfix/patch installs on Informatica servers
  • Actively involved in technical discussions and served as an informatica SME for most of the informatica related issues
  • Created new Informatica users for all the groups using PowerCenter and IDQ services, managed their permissions on different objects like relational connections and repository folders
  • Experienced in working closely with DBA’s and Unix System engineers for fixing Production issues related to Informatica

Environment: Informatica 8.6/9.1/9.5, oracle 10g/11g, Red hat enterprise Linux, open suise Linux, TOAD Teardata, UNIX, Win SCP, Windows 7, Linux, Power Exchange, and SFDC.

Confidential

Senior DW ETL Informatica Developer

Roles & Responsibilities:

  • Involved in backing up and restoring Domain, repository content and exporting content from repository to repository. Also involved in backing up the repository contents before every critical migration on release
  • Worked with Informatica technical support on several Informatica related technical issues and resolved them
  • Developed Informatica mappings, sessions, worklets and workflows, for one of the projects in which we brought in the data from different countries from different source system into the data warehouse
  • Worked with shell scripts, to test ODBC connectivity from Informatica server to databases
  • Monitor daily loads,Report daily on load status
  • Identify and report issues associated with load failures,Raise data issues to business leader
  • Response to queries raised by Business Leader
  • Manually load referential Integrity rejected records once it is confirmed by Business Leader that the root cause is fixed in Vision Plus.
  • Maintain existing application and process documentation
  • Coordinate with DBA for database administrative tasks in terms of Scheduling backups
  • System shut down/restarts, Diagnosing database related causes of failure
  • Coordinate with Product team before making changes to Global Product
  • Do analysis of change requests, Propose alternate solutions
  • Develop, Unit and Test changes having less than 10 person days effort
  • Set-up and Maintain ODS development/Test environment using Informatica
  • Coordinate with Product Team for Product change implementation
  • Used scheduled Task option available in Control panel for triggering, trigger.exe(which is written in C code) for scheduling purpose.

Environment: Informatica, oracle 10g/11g, Red hat enterprise Linux, PL/SQL Developer, TOAD 8.6

Confidential

Senior DW ETL Informatica Admin/Developer

Roles & Responsibilities:

  • Work involved understanding the new business requirements in existing system and then designing the ETL architecture.
  • The work also included working with the data modelling team to understand the logical design and then come up with the physical design specifications, which was then implemented in database.
  • Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
  • Created mappings to build business rules to load data.
  • Various transformations (SQ, lookup, Router, aggregators, filters, SG and UPS) were used to handle situations depending upon the requirement.
  • Done performance tuning in Informatica. Implemented slowly changing strategy to manage the data in the dimension tables.
  • Responsible for creating reusable transformations and Maplets.
  • Prepare the Weekly Status Report and attend the weekly call with the Client.
  • Review of Unit test cases, testing individual modules of the software against the Unit test cases.
  • Testing for Correct data.
  • Improving the performance of Workflow so that it takes minimal time.
  • Involved in installation of Informatica on UNIX, Migration of repositories (Folder Level), up gradation of repositories
  • Involved in Install, upgrade, configure and maintain Power Center 7.x instances
  • Interact with UNIX and Database Administrators to create and maintain each Power Center instances. .
  • Manage and administer system performance including on-going optimization and tuning of Informatica environment
  • Manages repository users, pmservers, repository functions (adding folders, migrating objects, etc.), and maintaining a clean and organized environment (truncating log files, removing invalid shared objects, etc.).
  • Creation of repository, backup and upgradation of repository
  • Shutting down and restarting the Informatica servers when there is a requirement
  • Perform complex troubleshooting, root-cause analysis, solution development
  • Resolving all type of Informatica technical issues
  • Informatica Admin activities like deployment, maintaining logs
  • Object migration(using static and dynamic deployment grp)

Environment: Informatica 7.x/8.1, oracle 10g/11g, Red hat enterprise Linux, PL/SQL Developer, TOAD 8.6

Confidential

ETL Informatica Admin/Developer

Roles & Responsibilities:

  • Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica.
  • Created mappings to build business rules to load data.
  • Various transformations (SQ, lookup, Router, aggregators, filters, SG and UPS) were used to handle situations depending upon the requirement.
  • Done performance tuning in Informatica. Implemented slowly changing strategy to manage the data in the dimension tables.
  • Responsible for creating reusable transformations and Maplets.
  • Prepare the Weekly Status Report and attend the weekly call with the Client.
  • Involved in installation of Informatica on UNIX, Migration of repositories (Folder Level), up gradation of repositories
  • Involved in Install, upgrade, configure and maintain Power Center 7.x instances
  • Interact with UNIX and Database Administrators to create and maintain each Power Center instances. .
  • Manage and administer system performance including on-going optimization and tuning of Informatica environment
  • Manages domain and repository users, domain functions, repository functions (adding folders, migrating objects, etc.), and maintaining a clean and organized environment (truncating log files, removing invalid shared objects, etc.).
  • Creation of repository, backup and upgradation of repository
  • Shutting down and restarting the Informatica servers when there is a requirement
  • Perform complex troubleshooting, root-cause analysis, solution development
  • Resolving all type of Informatica technical issues
  • Informatica Admin activities like deployment, maintaining logs
  • Object migration(using static and dynamic deployment grp)
  • Upgrading Informatica Powercenter from 6x to 7x

Environment: Informatica 6.x/7.x, oracle 9i, unix

Confidential, Charlotte, North Carolina.

ETL Informatica Admin/Developer

Roles & Responsibilities:

  • Requirement Analysis
  • Extracting source data from oracle and Flat Files and moving into Staging area and then transferring to Oracle target database using Informatica.
  • Involved in development of mappings.
  • Sophisticated transformation rules are implemented using Informatica features like Aggregator, Filter, Expression, S G, Lookup, UPS and Source Qualifier.
  • Used Joiner transformation for extracting data from multiple sources.
  • Used Star schema to populate data into cube, using dimensions and fact tables.
  • Conduct reviews
  • Test case preparation
  • Review of Unit test cases, testing individual modules of the software against the Unit test cases.
  • Testing for Correct data.
  • Improving the performance of Workflow so that it takes minimal time.
  • Involved in installation of Informatica on UNIX, Migration of repositories (Folder Level), up gradation of repositories
  • Involved in Install, upgrade, configure and maintain Power Center 7.x instances
  • Interact with UNIX and Database Administrators to create and maintain each Power Center instances. .
  • Manage and administer system performance including on-going optimization and tuning of Informatica environment
  • Manages repository users, pmservers, repository functions (adding folders, migrating objects, etc.), and maintaining a clean and organized environment (truncating log files, removing invalid shared objects, etc.).
  • Creation of repository, backup and upgradation of repository
  • Shutting down and restarting the Informatica servers when there is a requirement
  • Perform complex troubleshooting, root-cause analysis, solution development
  • Resolving all type of Informatica technical issues
  • Informatica Admin activities like deployment, maintaining logs
  • Object migration(using static and dynamic deployment grp)
  • Upgrading Informatica Powercenter from 6x to 7x

Environment: Informatica 6.x/7.x, oracle 9i, unix

Hire Now