Guarav Kumar Email & Phone Number

United States

As an Informatica expert with 16+ years of experience, I've architected and migrated various Informatica products to AWS cloud. I've managed IICS, performed automation in PowerCenter deployment, and provided 24/7 production support for Informatica job runs. My roles have also included designing and installing Informatica integration enterprise grids on AWS EC2, RDS Oracle, and creating active highly available configurations for Informatica products. I have experience in automating server deployments using Ansible and shell scripts. Additionally, I've deployed new projects in Informatica environments and documented system configurations and procedures.

United States

● Experienced in PowerCenter and BDM, developing source target mapping and migrating projects with Big Data connections to Teradata, Oracle and more.● Implemented Informatica Big Data Management on Cloudera, Hortonworks, EMR and HDInsight, connecting with various systems like MQ, Kafka, Oracle, Teradata, DB2, MSsql Server, and SAP HANA.● Designed complex Informatica mappings, sessions and workflows for ETL transformations, documenting using UNIX and SQL scripts, mapping and session implementations in Oracle.● Optimized performance of Informatica sessions for large data files, by increasing data cache size, sequence buffer length and target-based commit interval.● Developed data quality tools to cleanse and de-duplicate data for migration activities, and established standards for data quality, usage, and definitions through tooling and scorecards.● Installed Informatica Cloud (IICS) environment with secure agent integration for Salesforce, using different connectors to connect to various sources.

United States

● Informatica SME on designing and designing Enterprise HA Grid for Informatica Big Data Edition.● Installed and Configured multiple Informatica products on-grid highly available environmento Informatica Hadoop Big Data Edition 10x, 9xo Informatica Data Integration Hub 10x, 9x o Informatica Power center 10x, 9x o Informatica Proactive Monitoring (Governance and Operations)o Informatica Data Validation 10x,9xo Informatica Data Qualityo Managed Big Data Cloudera and Hortonworks ● Architected disaster recovery environment including switching over to DR side with minimal downtime ● Supported Development teams provided a recommendation for the development, design, and provision of multiple ETL integration projects● Virtualized Linux/ Unix systems● Written Linux shell scripts for scheduling the workflows. ● Proactively monitored, tuned, and maintained data solutions for performance, capacity management, and business continuity perspectives.● Code Review, Deployments in Power center and Hadoop Big Data Editions ● Created technical design and worked for Informatica upgrade, patching, workflow migration, and service continuity.● Creation of Architecture Technical Document, Technical Run Books, Operational Guide for new installs and upgraded environments● Upgraded 7.1, 8.1, 9.1 legacy environment to 10x Informatica integration enterprise grid ● Consultant to multiple projects for rapid development of their data integration needs. Directing them to the right channels in the organization for minimizing project goes live in production ● Managed and create edge nodes, name nodes, and data nodes ● Cluster Configuration, Operating System Profile setup ● Code deployment, Application deploymentAchievement: Informatica SME for 3 major initiatives for architecting new and upgrading legacy power center, Data Integration Hub, Informatica Big Data Edition, Data Quality, Proactive Monitoring, Data validation highly available grid environments

United States

● Maintained the optimal performance of Informatica batch jobs for BIDW & EDW performance monitoring, Capacity planning and tuning for multiple members on multiple projects.● Provided technical support, troubleshooting data loads, and report design. ● Interacted effectively with internal stakeholders and vendors.● Informatica Upgrade from 7.1 to 9.1 and 8.1.1 to 9.5.● Pager 2nd level support 24/7 for batch production jobs.● Worked with Informatica vendor on any issues that arise.● Promoted and deployed Informatica code● The assisted development team at design time ensuring code will run at scale● Wrote and maintained UNIX shell scripts for administering the Informatica environment● Designed and implemented appropriate error handling procedures● The developed project, documentation, and ETL standards in conjunction with data architects● Worked with other team members to ensure standards around monitoring and management of the Informatica environment within the context of existing enterprise monitoring solutions ● Applied patches/upgrades/hotfixes for Informatica Power Center● Deployed Power Exchange connector for multiple databases including Teradata, Netezza, Db2, Oracle, MQ series Achievement: Successfully delivered multimillion-dollar 15 + projects, Including Architecting creating Informatica Enterprise Integration environment highly available Grid onsite and offsite integration services deployments

United States

Description: Performed Development and production support activities of Tier 1 & 2 supporting single-handedly supporting large AT&T large Broadband Operation Business Intelligence Warehouse (BOBI) and Retail Data Warehouse (RDW) running Informatica 8.6.1 with almost 1200 loads a day. ● The managed new deployment of jobs in production and pre-production environment AIX 5.3 and Informatica 8.6.1.● Promoted the code in the Harvest ( change management tool )● Monitored Bi-Hourly, Daily, weekly and monthly and Yearly Jobs● Fixed Informatica jobs failures and completing all the jobs as schedules in the assigned SLA● Provided oversight of warehouse environment ensuring performance SLAs are met● Identified changes needed in the Jobs configuration to achieve the technology performance improvement● Ensured communication of process and procedure changes to key stakeholders● Monitored delivery against SLAs and reports exceptions to management● Established working relationships with technical, business, and sourcing & target counterparts● Participated in a future project to support the business● Participated in ongoing project deploying data interfaces and reports of varying complexity● Participated in production support activities● Strong documentation, writing, and problem mgmt/solving skills required● Planned and executed scheduled maintenance involving stopping and starting of critical application and changing parameters, making sure no data is missing and no impact on business ● Attended weekly maintenance calls with all the teams for coordinating all upcoming maintenance activities. Achievements: ● Upgraded the Informatica environment from 7.1.4 to 8.6 with hotfix 7 production and pre-production environment on AIX 5.3 for major BOBI warehouse in AT&T for 9 state operations● Deployment and installation 8.6.1 for BOBI 22 states project in production, pre-production, development, and test environment.

United States

Description: The purpose of the project was to integrate the customer management modules for different lines of business like cable, wireless, Media, Verizon Business, Shopping channels. Another project in which I was involved was Business Transformation (BT) ● Extracted data from Flat files, perform mappings based on company requirements, and load it into Oracle Tables. Used joiner transformation, unconnected lookup transformation, aggregator transformations, Update Strategy, Filter, and Router Transformations.● Tested the target data against the source system tables by writing Test Scripts and Test Cases.● Performed Tuned Informatica sessions for large data files by increasing data cache size, sequence buffer length, and target-based commit interval.● Created and Scheduled Sessions and Batch Process based on demand, run on time, run only once using Control M scheduler ● Used Debugger, Session Logs to check the errors in mappings.● Created the exception reporting as a part of the Error Handling Strategy.● Prepared scripts to validate the mappings consolidated with the Technical Specifications Document.● Documented Technical Specifications, which include all the scope, objective, error handling strategy, implementation techniques, SQL scripts, mapping, and session's implementation steps.● Prepared Documentation on planning ETL processesEnvironment: Informatica Power Center 7.1.4, 8x Designer, Repository Mgr, Workflow Mgr, PL/SQL, Oracle 10g, Win 2003, TOAD 9.6

United States

Description: The project involved integrating new data sources for a reporting data warehouse solution for Property & Casualty LOB, including PL & GL and management of these funds with the investments division. ● Extensively used Informatica functions LTRIM, RTRIM, IIF, DECODE, ISNULL, TO_DATE, DATE_COMPARE in Transformations.● Tested the target data against the source system tables by writing Testing Scripts and Test Cases.● Researched to solve production issues related to EDLC, Disaggregation of Funds. ● Used Debugger, Session Logs to check the errors in mappings.● Created the exception reporting as a part of the Error Handling Strategy.● Documented Technical Specifications, which include all the scope, objective, error handling strategy, implementation techniques, SQL scripts, mapping, and session's implementation steps.● Involved in cleaning and scrubbing data source tables before loading to the target database.● Prepared Test Scripts and Test Cases to validate the mappings consolidated with the Technical Specifications Document.● Extracted data from Flat files, perform mappings based on company requirements, and load it into Oracle Tables. Used joiner transformation, unconnected lookup transformation, aggregator transformations, Update Strategy, Filter, and Router Transformations.Environment: Informatica Power Center 7.1.4, 8x, Designer, Repository Mgr, Workflow Mgr, PL/SQL, Unix, Oracle 9i, Win 2000, TOAD, Advanced Query Tool

United States

Description: Streamlining the existing Data warehouse, Informatica for DW synchronization with DW enhancements, responsibilities, and tasks included:● Identified the sources data elements and fields from source systems for mappings.● Facilitated the Mapping of XML source fields, Flat Files with target systems.● Used XML Flat Files from the sources to populate the target tables.● Analyzed and identified the Data Gaps in the current systems.● Assisted the Support/development team to Validate data to ensure data cleansing according to predefined business/ specs requirements.● Prepared Functional Specifications with Detailed Field/ports and Value Mapping documents for the development team.● Developed complex Informatica Mappings, reusable Mapplets, Workflows, and Transformations.● Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression, and lookups (connected and unconnected) while transforming the SalesForce Data according to the business logic using Power Center.● Settled pending/unsettled Claims transactions from assuring database reconciled with MINDS Data warehouse. ● Managed unit and integration test to verify that the application functions as expected ● Troubleshot access, availability, and performance issues.● Created the new DIA’s based on all the new mappings to provide the proper documentation.● Created technical specifications and manage test case development.Environment: Informatica 6.1, Designer, Repository Mgr, Workflow Mgr, Oracle 8i, Toad, XML Marker, Advanced Query Tool

United States

Description: The project entailed working with the corporate finance and business lending division. The company wanted to restructure its capital budgeting process to reformulate the corporate action process to increase corporate sales, deliver personalized services and decrease corporate lending risk exposure.● Imported various Sources, Targets, and Transformations using Informatica Power Center, the Repository Manager, and Designer.● Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.● Performed the data extraction, transformation with business rules & developing the business reports using Informatica Power Center. Created Informatica mappings to load data incrementally into the Data warehouse. ● Developed various Mappings with multiple Sources, Targets, Transformations, and Mapplets using Power Center Designer.● Used heterogeneous files from Oracle, Flat Files SQL server as the source and imported stored procedures from oracle for transformations.● Created complex joiners, transformations of all types to smoothly pass data through ETL maps.● Imported an XML file to Designer, applied the transformations, used in the Mappings, and exported them into an XML file.● Writing PL/SQL procedures for processing business logic in the database. Tuning of SQL queries for better performance.● Created and ran sessions & Batches using Workflow Manager to load the data into the Target Database.● Scheduled Sessions and Batch Process based on demand, run on time, run only once using Workflow Manager.● Generated completion messages and status reports using Workflow Manager.● Tuned ETL procedures and STAR schemas to optimize load and query performance.Environment: Informatica Power Center 6.1, Oracle 8i, PL/SQL, SQL, MS Visio

United States

● Worked on dimensional modeling to Design and develop STAR Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making.● Worked with heterogeneous sources from various channels like Oracle, flat files. ● Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Workflow Monitor, and Repository Manager.● Extensively used Transformations like Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.● Wrote SQL-Overrides in Source Qualifier, used filter conditions in source qualifier thereby improving the performance of the mapping.● Designed and developed reusable transformation to use in multiple mappings.● Wrote UNIX shell scripts for scheduling the workflows. ● Extensively worked in the performance tuning of ETL mappings and sessions.● Created Test Cases and did Unit Testing to ensure the successful execution of the data loading process.● Tested the data and data integrity among various sources and targets. Environment: Informatics 6.2(Power Center), Oracle 8i, PL/SQL, SQL * Loader, Windows NT, 2000

United States

● Helped in positioning Oracle Database product by presenting technical presentation keeping in customer business issue and requirement are addressed carefully● Provided direction and specialist knowledge in applying the technology/application to client business● Performed as the expert for formulating and leading presales technical/functional support activity● Preparation of POC (Proof of concept) for the business solution.● Produced and implemented strategic account management plans for assigned key accounts● Took responsibility for client relationships at both strategic and operational levels● Discussed business issues with key accounts and interpret these into services that can be delivered by respective support offerings● Produced and deliver high-quality presentations/product demonstrations● Presented technical presentation on database ● Achieved agreed annual revenue targets