We provide IT Staff Augmentation Services!

Etl Admin Resume

5.00/5 (Submit Your Rating)

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.

We'd love your feedback!