Home

Arun T - ETL Informatica

[email protected]

Location: Center Line, Michigan, USA

Relocation:

Visa: H1B

PROFILE Over 14 years of experience in Data Warehousing, Data Integration in Financial, Healthcare and Banking 5 years of experience as a Lead managing offshore Team Experienced and good knowledge in Project Management and Planning, Engineering Management Planning, Service Operation and Management. 8 years of strong Data Warehousing experience in Business Requirement Analysis, Design, Development, Testing, Implementations, Loading, Maintenance and Enhancements of Data warehouse and ODS systems using Informatica, Oracle, SQL Server and well versed with Data Warehousing Architecture, Technology, Operational Data Store and Dimensional Data Modeling. Have exposure to Salesforce and SAP. Experience in conducting Change review meetings for the production change and Problem management and Incident Management. Experience in migrating ETL code from Informatica PowerCenter to Informatica Cloud. Extensive knowledge with Dimensional Data modeling, Star Schema/Snowflakes Schema, Fact and Dimension tables. Experienced in working on AWS migration s project like data migration s from on premise DB s to AWS RDS, worked on migrating the on premise ETL Informatica application to AWS hosted Informatica application. Heavily interacted with the Source System owners and business users to gather requirements, design tables, standardize interfaces for receiving data from multiple operational sources, coming up with load strategies of loading staging area and data warehouse. Experienced in Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling. Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch. Performed data analysis and data profiling using complex SQL on various sources systems. Excellent knowledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders. Conducted GAP analysis to analyze the variance between the system capabilities and business requirements. Worked extensively with different source & target systems like XML, flat file, relational tables, Salesforce etc. Experience in developing Test Strategies, Test Plans, Test Cases, Test Scripts and provided 24x7 production support. Possess excellent interaction, communication and problem-solving abilities. Strong experience in offshore and onsite coordination and Team Based Development Environment. Project Resource planning and allocation. EDUCATION Bachelor of Technology from KAKATIYA UNIVERSITY, INDIA - May 2009 WORK EXPERIENCE 1 Project Name: International Fleet Card Services Client WEX Inc. - Portland, ME Role Senior ETL Informatica Consultant/ Data Engineer Duration July 2022-May 2024 Environment Software Oracle, SQL Server, Amazon RDS, IICS, Informatica Power Center 10.2, XML, SFDC, JIRA, Control-M, WinSCP, Amazon RDS, S3, EC2, Lambda, GitHub. Project Description: The IFCS (International Fleet Card Services) project has been initiated to build an Enterprise Data warehouse and business intelligence application to address the challenges and enhance the way both WEX and its customers log, retrieve, maintain and present the information related to Fleet cards registrations, transactions and Payments related to their clients based out internationally in Europe and Asia Pacific and North America. The project involves 3 phases namely Legacy Data Conversion, Incremental Data Processing and Real Time Data Processing into the EDW in addition to various integrations between the IFCS and SFCD(BC) apps and Data Feeds. Responsibilities: Worked with Business Analysts to translate business requirements into design documents and source-to-target mapping documents that served as the blueprint for ETL work. Involved with data profiling for multiple sources and answered complex business questions by providing data to business users. Prepared High Level Technical Design specification and Low-level specifications based on business requirements. Informatica PowerCenter to IICS cloud migration activities Designed ETL process flows for entire applications and developed data mapping spreadsheets to define transformation rules for each stage of ETL process. Involved in the full development lifecycle from Requirement gathering through Design, Build, QA, Deployment and Support using Informatica Intelligent Cloud Services (IICS) Involved in Data Load to IFCS using DM Framework 2 Project Name: Advanced Data Management Capabilities (ADMC) Client LabCorp Drug Development, Indianapolis, IN Role Senior ETL Informatica Consultant / Data Engineer Duration Nov 2021-Jul 2022 Environment Software SQL Server, Informatica Intelligent Cloud Services (IICS), JIRA, SharePoint, GitHUB Project Description: Advanced Data Management Capabilities (ADMC) Team uses Informatica Intelligent Cloud Services (IICS) ti establish a product team and replacing existing DT4 functionality to package and transmit study data files to sponsors at various intervals during clinical trials. Responsibilities: Worked with Business Analysts to translate business requirements into design documents and source-to-target mapping documents that served as the blueprint for ETL work. Involved in understanding DT4 functionality and translate the requirements to match with Informatica Cloud Created custom user defined functions (UDF s) and Task flow Temp variables, In-out parameters to cater business requirement Involved in the design and implementation of 3 stage process for package processing and integrating it to the master task flow Involved in integrating the code development for each sprint and migrating to QA and UAT after unit testing 3 Project Name: Campaign Manager Automation Client Merck & Co, Kenilworth, NJ Role Senior ETL Informatica Consultant / Data Engineer Duration Dec 2020-Nov 2021 Environment Software Oracle, Snowflake, Amazon RDS, S3, Informatica Intelligent Cloud Services (IICS), SharePoint, ALM, Remedy, Amazon Redshift Project Description: ACE Campaign and Tactic Metadata Repository (Campaign Manager) is used to meet the business needs of users in Marketing Communications/Channels at Merck. The Project involves creating Execution Tactics based on the trackers provided by Business, IICS Data Integration between SharePoint, Salesforce, S3 and Snowflake Responsibilities: Worked with Business Analysts to translate business requirements into design documents and source-to-target mapping documents that served as the blueprint for ETL work. Involved with data profiling for multiple sources and answered complex business questions by providing data to business users. Worked on POC to integrate Amazon S3 with Informatica Intelligent Cloud Services (IICS) for processing multiple Parquet files, csv files to Snowflake Involved in creating Functional Requirements, Integration Design Documents, Development Test Plans, UAT Test Cases, Release and Validation Plans adhering to healthcare standards. Designed ETL process flows for entire applications and developed data mapping spreadsheets to define transformation rules for each stage of ETL process. Worked on IICS Data Integration between SharePoint, SalesForce and Snowflake using Data Synchronization, Mapping Tasks and Taskflows Involved in performance optimization of IICS jobs. Migrating Powercenter mappings to IICS Written various Unix scripts to handle pre and post data load tasks Converting source files from excel to csv, csv to Parquet files for large data volumes using Intelligent Structure Model transformation Creating SOP documents for Prod support teams. 4 Project Name: IFCS Client WEX Inc. - Portland, ME Role Senior ETL Informatica Consultant / Data Engineer Duration Aug 2017- Nov 2020 Environment Software Oracle, SQL Server, Amazon RDS, Informatica Power Center 10.2, XML, SFDC, JIRA, Control-M, WinSCP, Amazon RDS, S3 , EC2, Lambda , GitHub. Project Description: The IFCS (International Fleet Card Services) project has been initiated to build an Enterprise Data warehouse and business intelligence application to address the challenges and enhance the way both WEX and its customers log, retrieve, maintain and present the information related to Fleet cards registrations, transactions and Payments related to their clients based out internationally in Europe and Asia Pacific and North America. The project involves 3 phases namely Legacy Data Conversion, Incremental Data Processing and Real Time Data Processing into the EDW in addition to various integrations between the IFCS and SFCD(BC) apps and Data Feeds. Responsibilities: Worked with Business Analysts to translate business requirements into design documents and source-to-target mapping documents that served as the blueprint for ETL work. Involved with data profiling for multiple sources and answered complex business questions by providing data to business users. Prepared High Level Technical Design specification and Low-level specifications based on business requirements. Designed ETL process flows for entire applications and developed data mapping spreadsheets to define transformation rules for each stage of ETL process. Involved in the full development lifecycle from Requirement gathering through Design, Build, QA, Deployment and Support using Informatica Power Center. Designed and developed the Data integration framework and code base to integrate data from IFCS application to Business Connect (SFDC) application for EMEA and Chevron APAC clients. Worked on implementing hierarchy solution in SFDC BC applications Account object and other objects like Invoice, Account Receivables, Contacts, Security, Program and Dishonor. Fine-tuned the SFDC BC ETL jobs and implemented the Bulk load methodology in SFDC to ingest enormous amount of transactions into SFDC objects. Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries and tuning SQL to improve performance. Worked on generating Custom EDI files based on the companion guide for different customers. Worked on migrating the ETL Informatica code base from 9.6 on premise application to 10.2 AWS hosted application and configuring the root /Cache/file/log/Parameter file directories accordingly. 24x7 production support for jobs running in the production environment. Involved in debugging the failed mappings identify the root cause and developing error-handling methods. Work with a team of architects and engineers to develop proof-of-concept components. Worked with several heterogeneous sources and targets from various channels including JMS Message Queue, Oracle, XML files and flat files. Implemented various Performance Tuning techniques such as Pushdown Optimization and Partitioning. For reusability, Mapplets and reusable transformations have been created. Facilitated code reviews as a Lead consultant to ensure code quality worked and afted QA testers in testing the ETL output. Extensively worked on XML Mappings to facilitate the requirements and business case. Created mappings & Mapplets for data cleansing in IDQ/Informatica developer and used in Power Center. Worked on Informatica transformations including but not limited to SQL, XML, SFDC objects and Stored Procedure to facilitate the business requirements. Created labels, deployment groups and worked on migrating the code between different environments using deployment groups. Used team-based versioning to check all versions of the objects used in creating the mappings, workflows and to track the changes in the development and QA environments. Worked with Change Management deployment team to migrate Informatica objects such as workflows, sharable sources & targets, parameter files from DEV environment to higher environments such as SIT, UAT and PROD. Worked with Production Support team to schedule Informatica jobs using Control-M scheduler. Involved in unit testing of the end-to-end flow and documented the unit test case scenarios. Worked with various offshore teams based out across Europe, New Zealand, Australia and India to deliver the various project deliverables with the designated business clients. Manage all backup, restore and disaster recovery processes and procedures. This includes understanding how to execute all procedures and meet all related SLA s Provide security administration support with respect to users and privileges within all informatica domains 5 Project Name: Mobile Payments Client American Express- Phoenix, AZ Role ETL Informatica Consultant / Data Engineer Duration Oct 2015 - Jul 2017 Environment Software Oracle, DB2, SQL Server, Informatica Power Center 9.6, IDQ, Power Exchange, XML, Microsoft SQL Server Management Studio, Control-M, WinSCP. Project Description: AMEX is a global services company that provides customers with access to products, insights and experience that enrich lives and build business success. The project involved the AMEX mobile wallet payments Apple Pay, Android Pay, Samsung Pay, Amex Pay and Amazon Pay. Responsibilities: Worked with Business Analysts to translate business requirements into design documents and source-to-target mapping documents that served as the blueprint for ETL work. Involved with data profiling for multiple sources and answered complex business questions by providing data to business users. Extensively worked on Power Center Client tools such as Designer, Workflow Manager, Workflow Monitor, and Repository Manager. Implemented Slowly Changing Dimensions to store history according to business requirements. Implemented various Performance Tuning techniques such as Pushdown Optimization, Pass-Through Partitioning, Key range and Database partitioning. Responsible for four types of performance tuning Mapping Level, Session Level, Source Level, and Target level. Worked with several heterogeneous sources and targets from various channels including Oracle, DB2 and flat files. Extensively worked on developing Real-time CDC Mappings to process the Message queue data using transformations such as XML Parser, Router, Lookup, Update strategy and XML Generator. Work with a team of architects and engineers to develop proof-of-concept components. Design/Develop the ETL process framework to process Initial and Incremental load. Created labels, deployment groups and worked on migrating the code between different environments using deployment groups. Created mappings, Mapplets for data cleansing in Informatica developer and used in Power Center. Used team-based versioning to check all versions of the objects used in creating the mappings, workflows and to track the changes in the development and QA environments. Worked with Change Management deployment team to migrate Informatica objects such as workflows, sharable sources & targets, parameter files from DEV environment to higher environments such as SIT, UAT and PROD. Worked with Production Support team to schedule Informatica jobs using Control-M scheduler. Involved in through unit testing of the end-to-end and documented the unit test case scenarios. 6 Project Name: International Membership Rewards (Loyalty Rewards) Client American Express- Phoenix, AZ Role ETL Informatica Consultant / Data Engineer Duration Mar 2010-Sep 2015 Environment Software Oracle, Informatica Power Center 8.6, Power Exchange, XML, Control-M, WinSCP. Project Description: The system does the processing to award reward points to card members for both consumer and corporate credit cards. The system also sends various feeds to downstream systems, credit authorization systems, MIS data sent to Data warehouse for business analytics by marketing and Sales systems, external partners and banks. Responsibilities: Extracted data from different data sources and loaded them into Oracle using Informatica Power Center. Created source and target definitions, mappings, transformations (re-usable). Used various transformations like Joiner, Aggregate, Expression, Lookup, Filter, Update Strategy, Stored Procedures, and Router. Implemented SCD methodology including Type 1 and Type 2 changes. Developed several Workflows, Tasks, Sessions in Workflow Manager and scheduled them to run according to Load order. Created shortcuts, copies of Mappings, Workflows, various objects as per requirements and made use of shared folder objects. Involved in ETL processes from development to testing to production environments. Created Source-Target field mapping documents. Developed stored procedures to run as part of pre/post load process. Responsible for scheduling jobs and preparing technical documentation. Created Dimension tables, Fact tables, Aggregation tables. Used the Repository Manager and Administrator Console to create users, folders and groups and providing the required privileges. Responsible for verifying the Source to Target data load. Responsible for implementing change requests and fixing defects, issues and failures. Keywords: quality analyst sthree database information technology Arizona Colorado New Jersey