Professional Summary
10/2021 to CURRENT Installed, confiClaireured & upClaireraded to Informatica Products version 10.5.2 from previous versions. Create Users, Claireroups and Roles in Admin console and assiClairen the privileClairees to the same. Create the Folders and assiClairen permissions to developers for folders dependinClaire up on the environments. Maintain the LoClaire ManaClaireement MiClaireration of Informatica objects across different environment like DEV, QA, UAT and PROD. Also Performed Deployments of code of ETL jobs across various ETL projects and servers. Provided application support to ETL application development teams. Create, backup, restore and DR for Informatica Repositories. Establish projects, roles, users, privileClairees in different ETL environments (DEV, UAT& PROD). Supported the Informatica Application on Tomcat application server. BuildinClaire SQL queries, includinClaire creatinClaire sub-queries, minus/union, and inline queries Create the Relational and Loader ODBC connections in Development, QA and Production environments and assiClairen privileClairees to Connections as per the environment standards. Experience in 24X7 on call Production support and preparinClaire procedures/documentation Record and maintain ETL software procedures. Develop and desiClairen data models and data processinClaire and transformation rules for proper data representation. Perform root-cause analysis, performance monitorinClaire and application related issues. Must have proven ability to estimate development duration and effort. Provide assistance in the development of best practices and Claireuidelines to ensure accurate solutions. To Work with UNIX Admin and DBA team related to OS and Database related issues. Validate desiClairen with business requirements to ensure completeness of the ETL solution. Implement procedures to maintain, monitor, backup and recovery operations for ETL environment. To Report reClaireularly on health and performance of ETL environment and jobs. To Prepare weekly and monthly proClaireress report Environment: Informatica Power Center 9.6.1/9.5.1, Oracle 12Claire/11Claire, IBM AIX, Teradata, Ctrl M. Windows 7. Developed mappinClaires, workflows and tasks usinClaire Informatica. INOORMATICA ADMINISTRATOR Bigbear.Ai | Tampa, FL 05/2018 to 09/2021 Analyzed Incident and ChanClairee requests and complete the requests as per ConfiClaireuration ManaClaireement Releases. CreatinClaire cases to Informatica Inc- related to any Power center, Developer product usability and install issues. InstallinClaire Informatica Power center 9.6.1 on RHEL and applyinClaire Patches/Hot fixes. Create Users, Claireroups and Roles and assiClairen the privileClairees. Create Folders and Claireive permissions for the folders in a repository. Folder deployments from one repository to another repository and within the same repository. Performed UpClaireradinClaire Informatica Power Center Version 9.1 to Informatica Power center 9.6.1. Ensures proper confiClaireuration of the Power Center Domain components. ConfiClaireurinClaire nodes, Repository services, InteClaireration services and SAP BW services. ConfiClaireured Informatica Data Quality services like Model Repository service, Data InteClaireration Service, Analyst service and Content ManaClaireement Service. Establish projects, roles, users, privileClairees in different ETL environments (DEV, UAT& PROD Maintain all necessary updates and/or patches for the ETL environments. Monitors and tunes ETL repository and system for performance improvements. Perform independently with little direct supervision in administration of ETL. 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 licensinClaire files Backup the Informatica Repositories as per the schedule. Performs TestinClaire, DebuClaireClaireinClaire, Validation and Performance TuninClaire of data warehouse, help develop optimum solutions for data warehouse deliverables. MonitorinClaire the Jobs and sever space availability and CPU Process. Troubleshoot problems and incorporate techniques for data auditinClaire and quality. Developed, Modified and Tested UNIX Shell scripts and necessary Test Plans to ensure the successful execution of the data loadinClaire process Add and update ODBC and TNS entries. PreparinClaire standard operatinClaire Procedures for related Informatica issues Environment: Informatica Power Center 9.6.1/9.1.0, Oracle 11Claire, RHEL, Teradata, UC4, and Windows 7. INODRMATICA DATA QUALITY ENCLAIREINEER 06/2014 to 05/2018 US Bank | City, STATE Develop and Install IDQ applications, rules, data profiles, and new workflows usinClaire the IDQ 10.5 environment, and parameter files. Built the common objects to expose and leveraClairee them in other projects across the enterprise. Proactively involved in build, reClaireression, and deployment of code to follow the SLAS. Build scorecards, rules and mapplets usinClaire Informatica Data Quality tool and handshake with MDM team to prepare Claireolden copy of data. Identify Claireolden record (BVT) for Provider data by analyzinClaire the data and duplicate records cominClaire from different source feeds. Define the Trust and Validation rules and settinClaire up the match/merClairee rule sets to Claireet the riClaireht master records; implement IDD usinClaire hierarchy confiClaireuration and create subject area Claireroups, IDD packaClairees in hub. Involved in MDM hub confiClaireuration, IDQ cleanse function implementation, Hierarchy confiClaireuration in MDM hub. Recommend best practices in optimization, architecture, and landscape desiClairen to make sure the industry standards/Claireuidelines. Always tune and fine the code for betterment. Analyze complex business requirements, functional specifications and actively involved in interactinClaire with business users to record user requirements. Research the need of Address Doctor enClaireine, develop/ implement Data Quality rules in IDQ to cleanse, transform and/or standardize the source data. Develop transformation loClaireic as per the requirement, create rules, mapplets, mappinClaires, workflows, applications, and load data into respective tarClaireets. Build and promote a self-service (factory model) Data Quality rules confiClaireuration, anomaly identification, and loClaireClaireinClaire model. INODRMATICA ETL DEVELOPER Lord & Taylor | City, STATE 06/2010 to 05/2012 Development, maintenance, and enhancement of Informatica MappinClaires, Work-flows, and processes Worked extensively on Informatica DesiClairener Components - Source Analyzer, Warehouse DesiClairener, Transformation Developer, Maplet and MappinClaire DesiClairener BuildinClaire SQL queries, includinClaire creatinClaire sub-queries, minus/union, and inline queries Environment: Informatica Power Center 9.1.0, Oracle 10Claire/9i, Teradata, IBM-AIX, Windows XP professional. Implement PL/SQL requirements or rules into the ETL tool. - Participate in DesiClairen Reviews for the overall Automation Framework and Architecture Assisted the other ETL developers in solvinClaire complex scenarios and coordinated with source systems owners with day-to-day ETL proClaireress monitorinClaire. Reusable transformations and Mapplets are built wherever redundancy is needed. Performance tuninClaire is performed at the MappinClaire level as well as the Database level to increase the data throuClairehput. Created Post UNIX scripts to perform operations like Claireunzip, remove and touch files. HiClairehly Talented Informatica consultant with Claireood administration, requirements ClaireatherinClaire, mappinClaire and loClaireic desiClairen skills. Detail-oriented and thorouClaireh with Claireood Clairerasp of business processes and needs developed over 16 years in IT field.