Etl Admin Resume
Bowie, MD
SUMMARY
- Having around 8 years of IT experience in Administrative, Development, and Support of Data Warehousing and Data Integration solutions using the Informatica tool.
- Hands - on knowledge and experience with Informatica Power Centre (PC), Informatica Data Quality (IDQ), Informatica Intelligent Cloud Services (IICS), and Master Data Management (MDM).
- Experience with Install and configure and maintaining of MDM Hub and MDM application server (WebLogic, JBOSS) and MDM data stores.
- Experience and hands-on knowledge about resolving development and environment-related issues by working with developers and Informatica vendors.
- Proficient in applyingperformance tuning concepts to Informatica Mappings, Session properties, and database.
- Knowledge and Hands-on Experience in Informatica PowerCenter tools such as Source Analyzer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
- Expertise on Informatica client tools Admin Console, Developer tools, Mapping Designer, Workflow Manager, Repository Manager and Workflow Monitor. Experienced in overall Data Warehouse, Database, ETL and performance tuning.
- Experience in troubleshooting the Session Logs, workflow log files, and debugging the code to fix the Testing issues.
- Experience in Upgrading Informatica Power Center from v .2 Versions.
- Involved in Requirement Analysis, designing overall Architecture, Identifying anomalies, IDQ Mapping development, and Testing.
- Experience in applying Hot Fixes and Patches to Informatica Platform.
- Experience in working with Informatica team regarding Production issues.
- Experience in analysing and resolving issues using data viewer and mapping logs.
- Experience in troubleshooting issues in data integration logs, model repository logs, and domain logs.
- Exclusively worked on different flavors of UNIX and Windows operating systems and good Experience in UNIX shell scripting.
- Good Knowledge in Cloud ETL applications like Snaplogic and Glue.
- Hands on Experience in Git hub activities and AWS services
- Experience in working on all IICS admin activities and hands-on experience in performing the migrations from lower environments to upper environments.
- Experience in troubleshooting and fixing cloud tasks by verifying logs from IICS monitor and EC2 instances.
- Hands-on experience onGit Hub integrations with Cloud Applications.
- Experience in performing the tuning concepts to Informatica Mappings, Session properties, and database.
- Team player with good interpersonal and problem-solving skills, ability to work in a team andwork individually.
TECHNICAL SKILLS
RDBMS: Oracle 19C/12c/11g/, SQL Server 2012/2008, DB2 10.2/9.7 FP1, Sybase 15.x.
ETL Tools: Informatica Power Center 10.1/9.6.1/9.1/8. x, IDQ, TDM, IICS and Power Exchange, AWS, BDM
Operating System: Unix-AIX/Linux/Solaris
Languages: SQL, PL/SQL, Shell Scripting
Modeling Tools: MS Visio.
Other Tools: SQLPlus, Toad, AutoSys, SQL developer, WebLogic, JBOSS, SQL Management Studio, AWS, Microsoft Visio.
PROFESSIONAL EXPERIENCE
Confidential, Bowie, MD
ETL Admin
Responsibilities:
- Participated in meetings with respective teams to gather requirements for project set up
- Installed Power Center and Power Exchange installations, configuring Power Center Domain, nodes, Grids and Create Different services in the Domain.
- Provisioned the Users, Groups, Roles, and grant privileges to the users.
- Experience in creating the users manually and configuring the LDAP setup for users’ access.
- Created folders, Relational and Application connections and configure the ODBC connectivity.
- Participated in meetings with developer team and proposed the best practices
- Created test jobs to check the connectivity between the various databases and Informatica application.
- Responsible for the table imports and data map imports across the environments
- Experience in working with Production support and handling long running jobs in Production server.
- Monitor and communicate the availability of UNIX and Informatica Environment. Follow-up on problem tickets.
- Worked with developers on performing tuning of Informatica Mappings for optimum performance.
- Used debugger to validate the mappings and gain troubleshooting information about data and error conditions.
- Experience in creating the Unix Scripts, and used PMCMD and PMREP to interact with Informatica Server from command mode.
- Experience in Configuring the Secure Agents in IICS Application.
- Worked on migrating the files between the S3 buckets and ec2 instances to local desktop.
- Worked on creating the IICS Users and creating the cloud and ON PREM connections.
- Worked on troubleshooting and fixing cloud tasks by verifying logs from IICS monitor and EC2 instances
- Involved in Prod Support to research and resolve the daily load issues and trouble shoot them.
- Document the Prod job failures and provide the root cause analysis to the management.
Environment: Informatica Power Center 10.2/9.6.1, Power Exchange, IDQ, Informatica MDM HUB 10.2, IICS, SQL Developer, SQL Loader, Windows XP, UNIX/Linux, DB2 9.7, SQL Server 2012, Autosys.
Confidential, Pittsburg, PA
ETL/Informatica Admin
Responsibilities:
- Used Informatica Designer designed Mappings that populated the Data into the Dimensions.
- Used Workflow Manager, Repository Manager for Creating, Validating, Testing and running the Batches and Sessions and scheduling them to run at specified time.
- Maintained Development, Test and Production Repositories using Repository Manager. Also used Repository Manager to maintain the metadata, Security, Backup and Locks.
- Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner transformations·Performed Repository and Domain Backup and Restores as needed.
- Upgraded Informatica PowerCenter 9.6.0 to 9.6.1 and from 9.6.1 to 10.1
- Responsible to work with Informatica support, provide feedback to managers, find a root cause, and take necessary steps to prevent ongoing issues.
- Experience in providing on call 24*7 support.
- Coordinating all code migration efforts between all Dev, QAT, and Production environments.
- Performed Daily activities - Health check of all DEV, QAT, and PROD servers.
- Maintaining all Informatica repositories (DEV, QAT, and PROD).
- Performed Repository and Domain Backup and Restores as needed.
- Setup Maintenance Jobs for the start-up, shutdown, backup, purge, Space usage alert.
- Code Review for Production release.
- Interact with the network, database, and UNIX administrators to implement Informatica infrastructure and troubleshoot issues.
- Coordinating with users to resolve issues in Informatica Jobs and raising SR’s with Informatica Tech Support.
- Used Workflow Manager, Repository Manager for Creating, Validating, Testing, and running the Batches and Sessions and scheduling them to run at specified time
Environment: Informatica PowerCenter 9.1/9.6.1, MDM 9.6/10.1, IDQ 9.6.1, Oracle 11g, SQL Server 2005/2008, Linux RHEL 6.x/5.x, IBM DB2, SQL Developer, Windows XP, PL/SQL, Sybase, Autosys.
Confidential, Tampa, Florida
Informatica Admin
Responsibilities:
- Implemented Hot fixes and EBF’s on top of Informatica Up-gradation.
- Performed Informatica repository management activities like creating folders and assigning required permissions to the folders.
- Implemented the Data Director Service for Data quality.
- Created and configured the Reporting and Dashboards service for Data Quality application.
- Created and managed connections and providing the required access levels Using Repository Manager.
- Regular Monitoring and troubleshooting the Informatica domain.
- Regular repository backup / recovery activities as part of disaster recovery plan.
- Provided E2E support for Informatica Environment.
- Implemented full proof of concept (POC) as part of Informatica Up-gradation 10.2 to v10.4
- Managed the Informatica Logs and space related issues.
- Identified performance bottlenecks and involved in performance tuning of sources, targets, mappings, transformations, and sessions to optimize session performance.
- Identified bugs in existing mappings/workflows by analyzing the data flow and evaluating transformations.
- Experience in Installing and configuring MDM HUB software and setting up databases for the Hub store.
- Experience with configuring security access manager, resource loading and monitoring operations of MDM HUB.
- Implemented update strategies, incremental loads, Data capture and Incremental Aggregation.
- Extensively worked on various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.
- Created UNIX Shell scripts and called as pre session and post session commands.
Environment: Informatica PowerCenter 9.1/9.5, Power exchange 9.1/9.5, IDQ 9.1/9.5, Business Objects 6.0, UNIX Shell Scripting, DB2 8.0, Oracle 10g/11g, SQL Server 2008, TOAD, Linux/Solaris, MDM.
Confidential
Informatica Admin
Responsibilities:
- Installed and Configured Informatica PowerCenter on Client and Server Machines and Configure Informatica Server and Register Servers.
- Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets, and Reusable Transformations.
- Responsible for creating repository users, user groups, giving privileges to the users, granting users with access to the repository folders.
- Responsible for maintaining repository backups and their restorations.
- Responsible for migrations from Development repository to the QA and Prod repositories.
- Managed one-time migration of data with planned outages in the weekend.
- Used Informatica Designer designed Mappings that populated the Data into the Dimensions.
- Used Workflow Manager, Repository Manager for Creating, Validating, Testing, and running the Batches and Sessions and scheduling them to run at specified time.
- Maintained Development, Test and Production Repositories using Repository Manager. Also used Repository Manager to maintain the metadata, Security, Backup and Locks
- Worked extensively on transformations like Filter, Router, Aggregator, Lookup, Update Strategy, Stored Procedure, Sequence generator and joiner transformations.
- Bench Mark testing of Hardware and Informatica PowerCenter mappings to calculate the load times for batch processing and tuning the mappings.
- Experience with Production support. Working in Incident tickets and providing 24/7 on-call support.
Environment: Informatica Power Center 8.6.1 Power exchange for Oracle, DB2, UNIX Shell Scripting, DB2 8.0, Oracle 10g, SQL Server 2005, TOAD, Linux/Solaris.