We provide IT Staff Augmentation Services!

Sr Informatica Bdm Administrator Resume

West Chester, PA

SUMMARY

  • Over 8 years of IT experience in Analysis, Design, Development, Administration and Maintenance for Data warehouse and related applications using ETL and BI tools.
  • Expert level experience in implementing advanced ETL methodologies for corporate wide - ETL solution using Informatica Power Center, Data Quality & Big data Management versions.
  • Good Knowledge in Installation, Configuration and Upgrade of Informatica Services Platform 10.2/10.1.1/ 9.5.1/9.1.0 /9.0.1/8. x/7.x on IBM AIX, SUN-SOLARIS and LINUX.
  • Experience in Applying Informatica Hot fixes and EBF (emergency bug fixes).
  • Experience in Setting up Highly Available Power Center Enterprise domain and configuring services to run on Enterprise GRID Option.
  • Having experience in installing and upgrading Big Data Management versions of informatica to BDM 10.2 versions & administering this software packages in a complex Enterprise Hadoop ecosystem.
  • Experience in integrating the BDM version with kerberized Hadoop environment and installing informatica RPMs on the Hadoop cluster.
  • Experience in integrating the BDM version with kerberized Hadoop environment and working on various Hadoop engines like HIVE (Map Reduce & Tez) and Spark.
  • Having good understanding of Zero design-time footprint, 1-step Hadoop Integration and Cluster configuration objects (CCO) in BDM version.
  • Experience in configuring Informatica Data Quality (IDQ) services like Model Repository Service, Data Integration Service, Analyst Service, Profiling service modules.
  • Experience in configuring Metadata Manager/Business Glossary in the Informatica Data Quality platform.
  • Installed and configured Manta Xconnect a third party tool which is used for pulling the metadata from scripts like SQL, BTEQ (Basic Teradata Query) and establishing the data lineages in Metadata Manager.
  • Knowledge in Informatica Data Quality, Data Profiling and Power Exchange for different data sources like VSAM & CDC for Oracle.
  • Having experience in configuring Power Exchange for Teradata Parallel Transporter (TPT).
  • Having sound knowledge on Teradata utilities like Multi load, Fast load, fast Export &TPUMP.
  • Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer
  • Good working experience with Complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy.
  • Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, VSAM, DB2, Oracle, SQL Server and Teradata.
  • Developing UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process.
  • Experience in Tuning and scaling procedures for better performance and Capacity planning of the enterprise informatica platform.
  • Experience in creating new LDAP Nested groups and integrating LDAP in to informatica. Also worked on migrating the user’s security from Native to LDAP.
  • Experience in setting up the DR environment and also worked on a Hardware migration project of database and the application servers.
  • Experience in working ininformatica Intelligent Cloud Services Platform (IICS).
  • Having knowledge in installing the informatica MDM Multi Domain Edition with other related components like Reference data Management Accelerator (RDM) and Informatica Data Director (IDD) Services.
  • Worked on Change Management Tools to track all the incidents and changes and to plan the production changes as per the change management policies.
  • Excellent communication and interpersonal skills.

TECHNICAL SKILLS

ETL: Informatica Power Center Advanced 10.1.1/9.6.0 & Power Exchange, B2B DT.

Data Quality & Metadata Manager: Big Data Management (BDM) 10.2, Big Data Edition 10.1.0, Informatica Data Quality 10.1.1 HF1 & 9.6.1 HF3.

Databases: Oracle 12c/11g/10g, MS SQL Server2005/2008,Sybase

Data Modeling: SAP Power Designer, Erwin

Reporting Tools: SAP BO, Tableau, OBIEE, Cognos

Languages: SQL, PL/SQL, Unix Shell Scripting, Windows Power Shell.

Operating System: UNIX (AIX, Solaris, LINUX), Windows NT/XP

Scheduling Tools: UC4, Maestro, Ctrl M.

PROFESSIONAL EXPERIENCE

Confidential, West Chester, PA

Sr Informatica BDM Administrator

Responsibilities:

  • Providing 24/7 support to all administrative issues, while working with around 200 developers (onshore/offshore) model.
  • Have built new informatica environments from scratch by architecting the servers including disaster recovery servers with standard specifications directly with Power Center 9.6.1 big data edition and BDM 10.2 versions in DEV/QA/PRD with 4 nodes on each Red hat Linux instances.
  • Having experience in applying EBF’s and hot fixes on informatica.
  • Having experience Installing and configuring power exchange for sales force and integrate with Power Center.
  • Installed and configured Manta a third part tool which is useful for pulling metadata from BTEQs for creating data lineages in Metadata Manager Environment.
  • Also having experience working with power designer data modeling tool for creating lineages for SAP sources.
  • Created Groups, roles, privileges and assigned them to each user group and administered Power Center Security.
  • Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments on versioned repositories using Deployment groups.
  • Having experience in deploying the Informatica data quality (IDQ)components likes mappings, rules, Applications, workflows and their dependencies using advanced import and export method.
  • Experience in Big Data Quality (BDQ) onHadoopplatform, Created connections to HDFS cluster, HIVE and HBase connections in Developer tool to connect to Hadoop environment.
  • Experience in integrating the BDM version with kerberized Hadoop environment and working on various Hadoop engines like HIVE (Map Reduce & Tez) and Spark.
  • Worked on debugging various pushdown mapping failures in BDM environment running with Hive and Spark execution engines.
  • Created a Ambari user for importing the cluster details using a cluster configuration object (CCO).
  • Worked with Data Quality Analysts in debugging the various Profiling and scorecard issues and worked on automating the Scorecards and Profile jobs.
  • Running and monitoring the weekly Metadata Manager Resource loads to extract the metadata from different sources in to MM Warehouse.
  • Extensively worked on UNIX shell scripts on automation (Auto restart of services, Disk space utilization, cleanup the logs directories) and scripts using Informatica Command line utilities.
  • Performed System level health checks CPU, Memory utilization, Number of parallel loads (sessions) running on each node.
  • Implement capacity management, Debugging, Validation and performance best practice guidelines and monitoring.
  • Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users.
  • Worked closely with Informatica Technical support on Informatica related technical & environmental issues.
  • Worked on automating the addition if users in to LDAP groups using a Windows Power Shell Script.

Environment: Informatica Power Center 10.1.1/9.6.0 , BDM 10.2, Oracle 12c/11g/, Red hat Linux 6.9, Teradata 15.10, HDP 2.6, Microsoft SQL Server 2008, UC4 & JIIRA.

Confidential, Springfield, MA

Sr Informatica Platform Administrator

Responsibilities:

  • Installed, configured & upgraded to Informatica Power Center 9.5.1 from previous versions and applying EBF and Hot fixes.
  • Migration of Informatica Mappings/Sessions/Workflows from Dev, QA to Prod environments on versioned repositories.
  • Import and export INFA xml’s across repositories from clear case versioning server.
  • Setup and administer Power Center security.
  • Created Groups, roles, privileges and assigned them to each user group.
  • Setup and configure Power Center domain, grid and services.
  • Create and maintain the Relational and Loader ODBC connections in Development, QA and Production environments.
  • Implement capacity management, Debugging, Validation and performance best practice guidelines and monitoring.
  • Configured OS Profiles and LDAP Authentication and worked with UNIX Admin and DBA team related to OS and Database related issues.
  • Worked closely with Informatica Technical support on Informatica related technical & environmental issues.
  • Installed and configured Informatica Support Console to proactively monitor the environment.
  • Extensively worked on UNIX shell scripts on automation (Auto restart of services, Disk space utilization, cleanup the logs directories) and scripts using Informatica Command line utilities.
  • Performed System level health checks CPU, Memory utilization, Number of parallel loads (sessions) running on each node.
  • Worked on SQL queries to query the Repository DB to find the deviations from Company’s ETL Standards for the objects created by users such as Sources, Targets, Transformations, Log Files, Mappings, Sessions and Workflows.
  • Performed Testing, Debugging and Validation and Performance Tuning of Data Warehouse deliverables.
  • Provide standards using Informatica velocity guidelines to application development teams.
  • Worked on HP Service Manager Tool to plan production changes as per the change management policies and get it approved along with other dependent changes.

Environment: Informatica Power Center 9.5.1/9.1.0 , Oracle 11g/10G, IBM AIX, Teradata, Microsoft SQL Server 2008, DB2, Tivoli Workload Scheduler (MAESTRO), HP Service Manager.

Confidential, Waltham, MA

Sr ETL Administrator

Responsibilities:

  • Installed, configured & upgraded to Informatica Power Center 9.5.1 from previous versions and applying EBF and Hot fixes.
  • Creating Object Queries, Deleting and purging objects.
  • Formulating deployment plans and weekly Audit reports.
  • Created Users, Groups and Roles in Admin console (Administrator) and granted the privileges.
  • Creation of Static and Dynamic deployment Groups, Labels and Queries.
  • Updating and Adding ODBC and TNS entries.
  • Created Folders and assigned permissions to developers for Folders depending up on the environments.
  • Involved in Migration of Informatica Mappings/Sessions/Workflows from DEV, QA to PROD environments.
  • Create and maintain the Relational and Loader ODBC connections in Development, QA and Production environments.
  • Created backup, restore and DR for Informatica Repositories.
  • Handled ETL batch jobs across all the environments (DEV, QA & PROD).
  • Involved in Performance Tuning of Informatica Server and Repository Server.
  • Monitoring systems capacity and performance, plans and execute disaster recovery procedures.
  • Record and maintain ETL software procedures.
  • Providing Application support to ETL application development teams.
  • Coordinating with Offshore and support teams regularly
  • Running UNIX shell scripts for repository backups, domain backups and scheduled the informatica sessions runs.
  • Communicated infrastructure needs and directions with management.
  • Implementing procedures to maintain, monitor, backup and recovery operations for ETL environment.
  • Report regularly on health and performance of ETL environment and jobs.
  • Provided 24/7 Support related to Administration tasks (Emergency Deployments, FATAL ERRORS on the Informatica Server, unexpected Informatica services failures, Repository issues etc.)
  • Worked on Service Now tool to track all the changes and incidents.

Environment: Informatica Power Center 9.5.1/9.1.0 , Oracle 11g/10G, IBM AIX, Teradata, Ctrl M, Service Now

Confidential, Weston, MA

Informatica Developer/Administrator

Responsibilities:

  • Analyzed Incident and Change requests and complete the requests as per Configuration Management Releases.
  • Creating SR to Informatica Inc- related to any Power center product issues.
  • Installing Informatica Power center 8.6.0 on SUN-SOLARIS and applying Patches/Hot fixes.
  • Performed Upgrading Informatica Power center Version 8.X to Informatica Power center 9.0.1.
  • Ensures proper configuration of the Power Center Domain components
  • Configuring nodes, Repository services, Integration services and SAP BW services.
  • Configured Informatica Data Quality 9 on Power Center 9.0.1.
  • Create and maintain ETL administration best practices and procedures.
  • Create Operating System Profiles and assign the OS profiles to folder.
  • Maintain all necessary updates and/or patches for the ETL environments.
  • Monitors and tunes ETL repository and system for performance improvements.
  • Perform root cause analysis, performance monitoring and application related issues.
  • Handle user access / security role requests for new developers and projects.
  • Write Repository Queries in support of developments and Production statistics.
  • Ensures proper application of the licensing files
  • Creating Folders and manages user and user group access to objects based on LDAP settings.
  • Performs Testing, Debugging, Validation and Performance Tuning of data warehouse, help develop optimum solutions for data warehouse deliverables.
  • Work with UNIX Admin and DBA team related to OS and Database related issues.
  • Monitoring the Jobs and sever space availability and CPU Process.
  • Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loading process
  • Add and update ODBC and TNS entries.
  • Preparing standard operating Procedures for related Informatica issues
  • Preparing weekly and monthly progress report

Environment: Informatica Power Center 9.0.1/8.6.1 , Oracle 10G/9i, Red hat LINUX/Sun Solaris, Teradata, UC4, and Windows XP professional, REMEDY (Change management Tool).

Confidential, McLean, VA

Informatica Developer

Responsibilities:

  • Gathering requirements from the various systems business users.
  • Worked on Informatica Power Center tools-Source analyzer, Warehouse Designer, Mapping Designer and Transformation developer.
  • Designed and developed Informatica Mapping for data load and data cleansing.
  • In Workflow Manager created connections, sessions, tasks, workflows etc.
  • Created complex SCD type 1& type 2 mappings using dynamic lookup, Joiner, Router, Expression, Update Strategy and Sequence Generator.
  • Worked on performance tuning of the complex transformation like SCD type 1 & SCD Type 2.
  • Extracted, transformed data from various sources such as Flat files, MS SQL Server and Oracle transferred data to the target data warehouse Flat files.
  • Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate one time, Weekly, Monthly and Yearly Loading of Data.
  • Utilized the Aggregate, Join, Router, Look up and Update transformations to model various standardized business processes.
  • Worked with Scheduler to run the Informatica session on daily basis and to send an email after the completion of loading.

Environment: Informatica Power Center 7.1.2 (Repository Manager, Designer, Workflow Manager), Oracle 9i, MS Sql Server 2000.

Hire Now