Informatica ETL Developer
Resume:
Kumar Dudi
Contact No :+1-515-***-****
Email-ID:*****.******@*****.***
Place:San Antonio,TX
Professional Summary:
9+ years of IT experience in Analysis, Design, Development, Implementation, Testing and Supportof Data Warehousing and Data Integration Solutions using Informatica Powercenter and Datastage
7+ years of experience in using Informatica Powercenter (8x/9x)
Proficiency in developing SQL with various relational databases like Oracle, SQL Server,DB2,Teradata
Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
Strong business understanding of verticals like Banking, Insurance and retail
Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server, TSQL and Oracle PL/SQL.
Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
Proficient in the Integration of various data sources with multiple relational databases like Oracle11g /Oracle10g/9i, MS SQL Server, DB2, Teradata, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.
Experience in using Automation Scheduling tools like Autosys and Control-M.
Worked extensively with slowly changing dimensions.
Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
Work Experience:
Currently working as a Senior ETL Developer for Tata Consultancy Services from June 2011 to till date
Worked as a ETL Developer for Tavant technologies, Bangalore from Apr 2009 to Apr 2011
Worked as ETL Developer for Xcaliber technologies, Pune from Jan 2008 to Mar 2009
Academic Qualification:
Bachelor of Computer Science from S.V.University
Technical Skills:
Operating Systems: Windows 2008/2007/2005/NT/XP, UNIX, MS-DOS
ETL Tools: Informatica Power Center 9.1/8.6/8.5/8.1/7.1
Databases: Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1, Teradata.
Languages: SQL, PL/SQL, UNIX, Shell scripts
Scheduling Tools: Autosys,Control-M
Projects Information:
Client: United Services Automobile Association (USAA)
Duration: September 2017 to till date.
Role: ETL developer & Support
Description:
USAA is a San Antonio, Texas-based bank, insurance, and financial services company with 22,000 employees, serving 8 million current and former members of the military and their families. The company's roots go back to 1922, when 25 army officers agreed to insure one another's cars when no traditional companies would. Since then, USAA, or the United Services Automobile Association, has steadily grown. The main objective of the project was to help the decision making team of the organization, to monitor/improve the sales and to explore avenues for new business opportunities. DW team is responsible for building Global Data Warehouse and providing reports for Production and Midstream groups. Worked on four capital projects EPC BI, EQUITRANS BI, EGC BI and ETRM BI. The data is extracted from Flat files, Oracle, SQL and DB2 into the Operational Data Source (ODS) and the data from Operational Data Source was extracted, transformed and applied business logic to load them in the Global Data Warehouse Using Informatica PowerCenter 9.1.0 tools.
Responsibilities:
Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
Used various transformations like Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Sorter and Union to develop robust mappings in the Informatica Designer.
Extensively used the Add Currently Processed Flat File Name port to load the flat file name and to load contract number coming from flat file name into Target.
Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
Extensively used workflow variables, mapping parameters and mapping variables.
Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
Implemented Informatica recommendations, methodologies and best practices.
Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
Involved in Unit, Integration, System, and Performance testing levels.
Written documentation to describe program development, logic, coding, testing, changes and corrections.
Migrated the code into QA (Testing) and supported QA team and UAT (User).
Created detailed Unit Test Document with all possible Test cases/Scripts.
Involved in production support.
Client: Liberty Mutual
Duration: Aug 2014 to Aug 2017.
Role: ETL Informatica developer & Support
Description:
The main objective of this project is to provide the valuable metrics from across the QA organization as an interactive reports. These metrics will be developed in database views based on the data where we pull from ALM, RTC and share point locations .The data analysts using these metrics to build out the reports using Microsoft power view and these reports will be published on daily basis and pre-determined intervals.
Responsibilities:
Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
Develop the mappings using needed Transformations in Informatica tool according to technical specifications
Created complex mappings that involved implementation of Business Logic to load data in to staging area.
Used Informatica reusability at various levels of development.
Developed mappings/sessions using Informatica Power Center 9.5 for data loading.
Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
Pre and post session assignment variables were used to pass the variable values from one session to other.
Implementedslowly changing dimensionmethodology for accessing the full history of accounts.
Write Shell script running workflows in unix environment.
Optimizing performance tuning at source, target,mapping and session level
Effectively worked on Onsite and Offshore work model.
Participated inweeklystatus meetings, and conducting internal andexternal reviews as well as formal walk through among various teams and documenting the proceedings.
Prepared migration document to move the mappings from development to testing and then to production repositories.
Client:Cigna, CO
Duration :Feb 2014 to July 2014
Role :ETL Developer
Description:
CIGNA’s goal is to be a leading individual health insurance provider, underpinned by a tightly integrated front-end retail solution coupled with a strong back-end claim administration platform that will drive membership growth in the pre- and post- Healthcare Exchange environment. The target file is a data extract file created from Facets FSA EOB/EOP data stored in the Extract Mart, also called the FSA EOB/P Driver file. This extract file is used as input to the Dialogue application, which runs at the Windsor Data Center. Dialogue composes FSA EOB/EOP statement for output, which could include printing, insertion, distribution and archiving or just archiving.
Responsibilities:
Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
Involved in extracting the data from the Flat Files and Relational databases into staging area.
Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Power Center Designer.
Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
Developed several reusable transformations and mapplets that were used in other mappings.
Prepared Technical Design documents and Test cases.
Involved in Unit Testing and Resolution of various Bottlenecks came across.
Implemented various Performance Tuning techniques.
Used Teradata as a source system
Client : Target
Duration : Jan 2013 to June 2014
Role :ETL Tester
Description:
eDw is a eCommerce DWH, that gets feed from Target.com,PRISM,various other systems and provides the data to various financial systems for reporting purposes. It also involves the Calculation Of Metrics for Business Analysis.
Responsibilities:
Ensuring testing for the release is completed within testing window.
Participating in Internal Reviews and raising QA logs.
Running the jobs for ETL Process through Data stage 8.5 and Ctrl –M.
Preparing and Executing SQL Queries.
Analyzing the Data Mapping and identifying gaps/ambiguities
Preparing Test Data.
Data Mapping, Defect Analyzing and Reporting in Quality Centre
Performing Functional Testing, Integration Testing, Regression Testing.
Defect Tracking and Reporting, Defects Report generation and Consistent on-time delivery.
Prepare lessons learnt document once the release is completed.
Co-coordinating with client for completion of User Acceptance Testing & results verification
Actively involved with the Client and On-shore team on the day to day basis regarding the project details.
Participated in the review meeting with Customers, Leads, Developers and Management.
Client : CMEC FUTURE
Duration :June2011 to Dec 2012
Role :ETL Developer
Description:
The Child Maintenance and Enforcement Commission (CMEC), referred to as “the Commission”, were established as a Crown non-departmental public body by the Child Maintenance and Other Payments Act 2008 and came into being on 24 July 2008.
Its main objective is supported by the following subsidiary objectives to: encourage and support the making and keeping by parents of appropriate voluntary maintenance arrangements for their children; Support the making of applications for child support maintenance under the Child Support Act 1991 and to secure compliance when appropriate with parental obligations under that Act.
Responsibilities:
Developed Informatica Mappings to load data from different Source systems to staging area.
Developed Slowly Changing Dimensions mapping for Type1 SCD and Type2 SCD.
Worked extensively with flat files and relational tables.
Involving in the preparing of technical detail design documents.
Coordinated with the Requirements gathering team to design Informatica jobs.
Used various transformations like Source Qualifier, Joiner, Lookup, sql,router, Filter, Expression and Update Strategy.
Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
Documented Informatica mappings in Excel spread sheet.
Tuned the Informatica mappings for optimal load performance.
Load balancing of ETL processes, database performance tuning and capacity Monitoring
Created unit test cases for the purpose of unit testing of various mappings
Prepared Unit Test plan and efficient unit test documentation was created along
with Unit test cases for the developed code.
Developed Informatica mappings and also tuned for better performance.
Worked with many existing Informatica mappings to produce correct output.
Client :Deloitte
Duration : July 2009 to Nov 2011
Role :ETL Developer & Support
Description:
This project has developing for Deloitte company to store The associate processing details that are related to transactional processing and call center. The data is collected from different process and from different process databases and from different locationsThailand and Vietnam. Is stored as centralized datastore Which is used to analyze the associates capabilities across the process,locations and also analyze the business improvement across the globe
Responsibilities:
Extensively used ETL to load data from Flat Files, XML, Oracle to oracle 8i
Involved in Designing of Data Modeling for the Data warehouse
Involved in Requirement Gathering and Business Analysis
Developed data Mappings between source systems and warehouse components using Mapping Designer
Worked extensively on different types of transformations like source qualifier, expression, filter, aggregator, rank, update strategy, lookup, stored procedure, sequence generator, joiner, XML.
Setup folders, groups, users, and permissions and performed Repository administration using Repository Manager.
Used various transformations like Source Qualifier, Joiner, Lookup, sql,router, Filter, Expression and Update Strategy.
Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
Documented Informatica mappings in Excel spread sheet.
Tuned the Informatica mappings for optimal load performance.
Involved in the performance tuning of the Informatica mappings and stored procedures and the sequel queries inside the source qualifier.
Created, launched & scheduled sessions.
Involved in the Performance Tuning of Database and Informatica. Improved performance by identifying and rectifying the performance bottle necks.
Used Server Manager to schedule sessions and batches.
Involved in creating Business Objects Universe and appropriate reports
Wrote PL/SQL Packages and Stored procedures to implement business rules and validations.
Client : Assurant
Duration :Feb 2008 to June2009
Role :ETL Developer
Description:
This project has been done for Group Benefits Division in Assurant to cover Life Insurance and Disability. In Group Benefits any association opens a new account first data will feed into different source systems like Private Label, Direct Side and Special Risk and Life Health. The Case Management data mart has been developed to store the data from those three sources and will be stored in a Centralized database so that they can done business analysis on this integrated data
Responsibilities:
Extracting and Loading of data from flat files and Oracle sources to oracle using transformations in the mapping.
Developed a series of mappings for handling different cases of input data.
Involved in development of Informatica mappings and also tuned for better performance.
Involved in the maintenance of Data Warehouse.
Worked on extensively for monitoring session for conformity of Data in datawarehouse.
Testing of mapping, Workflow and Tuning of mapping.
Involved in capturing slowly changing dimensions of all varieties including type-I and type-II
Used ready wizards in Informatica to capture and implement SCD Type-II (Changing Data) and tuned it requirement.
Involved in Tuning the mappings for optimum performance, dependencies and batch design.
Scheduled and ran extraction and load process and monitored sessions using Informatica workflow manager.
Contact this candidate