Need informatica Resume Sample? Check out for Informatica developer resume- FREE Downloadable Resume Templates | Easily Editable. Download Now
Just 3 steps to unlock your resumes.
Mobile : + 91-80XXXXXX
Email : sreenXXXXX.XXXX@gmail.com
Professional and Experience Summary
Having 6 Months of experience in the IT industry which includes experience in ETL testing & Manual testing
· Main areas of expertise are testing the Data warehousing projects.
· Extensively working Experience in preparation of Test cases and Defect reports.
· Good Knowledge of Data Warehousing concepts like Star Schema, Dimensions and Fact tables.
· Used ETL process to Extract, Transform and Load the data into the stage area and data warehouse.
· Experience in using QC 9.2 as a Test management tool.
· Skilled in understanding Business requirements and Designed documents.
· Extensively Good Working Knowledge on Oracle.
· Extensively Good Working Knowledge on Unix.
· Exposure to all stages of Software Development and Software Testing Life Cycles.
· Exposure to all stages of Test Defect Life Cycle.
· High degree of flexibility and ability to adapt to change in direction.
· Excellent interpersonal, communication and documentation skills.
· Excellent problem solving skills with strong technical background and ability to meet deadlines and work under pressure.
Organization
Currently working for xxxxxx Infotech, Bangalore as Test Engineer from May 2012 to till date.
Academic Profile
B.Tech. (INFORMATION TECHNOLOGY) from xxxxx University, 2012.
Technical Skills
Software Testing: ETL Testing & Manual Testing
Management Tools: Quality Centre 9.2
Languages: SQL, C
ETL Tool: Informatica 8.6
Operating System: Windows-XP & Unix
Database: Oracle 9i/10g
Application Tools: TOAD
WEB Tools: HTML
Projects in Detail
Project # 1
Project Title: New Scheduling System
Client: xxxxxx's, UK
Environment: Informatica 8.6, Quality Centre, Unix and Windows XP
Database: Oracle 10g
Role: Test Engineer
Project Description
· xxxxxxxx is currently scheduled using an in-house DS system (static slot matrix).
· The existing system is constrained by the static slot matrix and otherwise difficult to maintain as it is tightly coupled with the Delivery Scheduling (DS) consumer sites such as Grocery, Non-food etc.
· The objective of this project is to replace the existing DS system with Oracle Real time Scheduler.
· This system will enable Sainsbury to offer slots until full capacity is reached, should increase the number of orders Sainsbury can accept by removing the limits imposed by static slot matrix and will be easier to manage and maintain.
Responsibilities
· Understanding database design schemas for different sources and targets and end user business requirements.
· Running the Jobs/Workflows for ETL process.
· Preparing SQL queries to verify the data.
· Verifying the ETL data in target database.
· Column Mapping between source and the target databases.
· Preparing test data.
· Interactions with BA & Development teams to resolve the issues.
· Reporting daily, testing status.
· Designed test cases and Executed Test cases.
· Defect Analyzing and Reporting in QC.
· Workflow monitoring to ensure error free loading of facts and dimensions.
Project # 2
Project Title: xxxxxx Management Services
Client: xxxxxxxxxx Holding Inc.,
Environment: Informatica 8.6, Quality Centre, Unix and Windows XP
Database: Oracle 10g
Role: Test Engineer
Project Description
· xxxxxxxxxx Holdings Inc. is the world's biggest MTSO providing medical coding and medical claims to more than 50% of the hospitals, clinics, universities, etc., in the USA.
· Its vendors are scattered throughout the world who work round the clock with a TAT of 6 hours to 24 hours.
· The company needs various reports based on its requirement like quality control report, quality complaints report, TAT compliance report, allocation of work report, billing report for clients and vendors, and various other reports 6 hourly, daily, weekly, and monthly for its smooth functioning and better client satisfaction and business growth.
Responsibilities
· Understanding the customer requirements.
· Designed High level test scenarios and test cases.
· Executed test cases in QC.
· Run the Informatica Workflows for ETL Process.
· Validated data in Target database according to business rules.
· Prepared SQL queries and executed to validate the ETL processed data in the target database.
· Verifying the column mapping between source and target databases.
· Worked closely with Development team.
Professional Summary:
· 3 years of experience in Data Warehousing. Sound technical
Over background and hands-on development experience in Data Warehousing
platforms like ETL .
· Presently working extensively in ETL phase of Data Warehousing using
· Informatica 8.x, Informatica 7.x.
· Used Client Tools Designer, Workflow Manager, Workflow Monitor in
Informatica Power Center.
· Extensively used Expression, aggregator, Lookup, Update Strategy,
sequence Generator, Router, Unions, Joins .
· Implemented Various Performance Tuning techniques on Mappings.
· know the Partition PointsOverview, CheckInn's&CheckOut's. Involved in Unit Testing .
· Worked on extracting data from Oracle, Flat Files, transform and
loading into data warehouse.
· Experienced in working on developing Oracle PL/SQL to write stored
· procedures, oracle functions, packages and triggers.
· Experienced in writing shell scripts for multiple tasks to be performed.
· Strong communication and Inter-personal skills with the ability to work
in fast paced team environment and quickly learn new software
technologies.
Technical Skills:
Business Intelligence: Informatica 8.x, Informatica 7.1
RDBMS : Oracle -9i/10g.
Operating System : Windows XP / 2000,and UNIX
Languages : C, C++, SQL, PL/SQL
OLAP Tool's : Cognos 8.4
Education:
· B.Sc (Computer Science) From AacharyaNagarjuna University (2002-2005) with an average of 74%.
· M.C.A from BharathiDasanUniversity,Trichy(2005-08) with an average of 80%.
Work Experience:
· Working as Software Engineer for Prodapt, Bangalore from Oct 2009 to
tilldate.
· Worked as Developer for Tavant Technologies, Bangalore from June 2008
To Sept 2009.
Project # 1
Title Banking and Finance services Data Collection
Client Old National Bank, Evansville (Indiana)
Role ETL Developer
Duration Aug 2010 to tilldate.
Description:
Old National Bank is a multi-billion dollar, multi-state Financial Services company Headquartered in Evansville, Indiana. As the largest Independent banking company Based in Indiana, It is providing to customers with a comprehensive range of financial Products and services, including Commercial and Retail Banking, Credit Card Services, Electronic Banking, Trust and Asset Management, Brokerage and Insurance Services.
This bank involved in amounts for various purposes like Personal Loan, Vehicle Loan, Housing Loan, Consumer Durable Loans, etc. The company requires different level of analysis regarding loan amount, type of customers' type of payment schedules, interest rates, defaulters list and the penal interest calculations, etc. The data warehouse, basically it is a Data Mart as it covers only one domain of the business and captures data from their Historical Database.
This system is required to extract, transform, and load data from the different client system into a relational table environment that can be accessible for reporting purposes. A set of reports will be developed against the relational tables to deliver the information to its customers in the form of PDF files. The data from the different systems will be extracted into a set of text-based and Graphical reports.
Responsibilities:
· V Extraction, Transformation and Loading (ETL) of data by using
· Informatica Power Center.
· V Extracted source data from flat files, Oracle and loaded to an Oracle.
· V Developed mappings in Informatica Power Center Designer to load data
· from staging environment to warehouse.
· V Created mappings using the transformations such as the Source
· qualifier, Aggregator, Expression, Router, Filter, Sequence Generator,
· and Update Strategy.
· V Created and Monitored Informatica sessions.
· V Checked and tuned the performance of Informatica Mappings.
· V Involved in Creating Sessions, Workflows Using Workflow Manager
· V Involved in testing the mappings (UNIT testing).
· Environment: Windows NT, Informatica Power Center 8.6.1, Oracle 9i, UNIX.
Project #2:
Title : Telecom Services Information Systems
Client : Vertech Telecom Services Inc., Texas
Role : ETL Developer
Duration Nov 2009 to Aug 2010.
Description :
The main purpose is to develop high-performance data warehouse infrastructure that integrates data from a variety of source systems and provide client with information. The main process that is performed is Extraction, Transformation and Loading. The reporting tools provide on- demand reports to business users who use the information to study service usage patterns, design more competitive, cost-effective services, and improve customer service.
Responsibilities:
· Created mappings using the transformations such as the Source
· V Involved in requirements study and understanding the functionalities
V Used heterogeneous data sources like flat files and Oracle.
· V fier, Aggregator, Expression, Router, Filter, Rank, Sequence Generator, and Update Strategy.
· V Created and Monitored Informatica sessions.
· V Checked and tuned the performance of Informatica Mappings.
· V Identified and created different source definitions to extract data from input sources and load into relational tables using Informatica
· Power Center.
· V Analyzed Mappings and Sessions for better performance.
· Environment: Informatica Power Center 7.1, Windows, Flat Files, Oracle8i .
Project Name : DWH for Motor Insurance
Role : ETL Developer
Duration : June 2008 to Sept 2009
Client : Abbey National, UK
Project Description:
Abbey National is UK based Insurance Company, is one of the largest insurance providers for Home insurance, Motor insurance, Travel insurance and Card insurance. This project involves building of data ware housing for Motor insurance.
The source data, which includes
· V Types of policies
· V Information about policy holder
· V Policy covered item details
· V Premium Payment details V Types of claims like fast claim payments, fast repairs claim
Responsibilities:
· V Analysing Source System data and Information.
· V Worked on Informatica - Source Analyzer, Warehouse Designer, Mapping
Designer, Mapplet and Transformations.
· V Involved in the development of Source to Target Mappings.
· V Developed data Mappings between source systems and warehouse
components using Mapping Designer
· V Used most of the Transformations such as Source Qualifier, Aggregator,
Lookups, Filters, Sequence generator, Update strategy etc.,
Professional Summary:
· 8+ years of IT experience in Software Development Life Cycle (SDLC) which includes requirement gathering, designing, implementing and testing.
· 5+ years of Technical and Functional experience in Decision Support Systems – Data warehousing implementing ETL (Extract, Transform and Load) using Informatica Power Center 8.6/7.1.3/6.2
· Solid understanding of ETL design principles and good practical knowledge of performing ETL design processes through Informatica.
· Extensively worked on Power Center Mapping Designer, Mapplet Designer, Transformation developer Warehouse Designer, Workflow Manager, Repository Manager and Workflow Monitor
· Well acquainted with Performance Tuning of sources, targets, mapping and sessions to overcome the bottlenecks in mappings.
· Sound Understanding of Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema)
· Strong analytical and conceptual skills in database design and implementation of RDBMS concepts.
· Experienced in Oracle database development using PL/SQL, Stored Procedures, Triggers, Functions and Packages.
· Good knowledge in interacting with Informatica Data Explorer (IDE), and Informatica Data Quality (IDQ).
· Experience in UNIX shell scripting (file validations, file downloads, workflow executions).
· Developmental experience on Windows NT/95/98/2000/XP, UNIX platforms.
· Excellent communication and interpersonal skills.
· Good understanding of Star and Snowflake Schema, Dimensional Modeling, Relational Data Modeling and Slowly Changing Dimensions.
· Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schemas.
· Resourceful, creative problem-solver with proven aptitude to analyze and translate complex customer requirements and business problems and design/implement innovative custom solutions.
· Exceptional problem solving and sound decision making capabilities, recognized by associates for quality of data, alternative solutions, and confident, accurate, decision making.Technical Skills:
ETL Tools |
Informatica Power Center 8.6/7.1.3/ 6.2 |
Operating Environment |
Unix(solaris) 9.0, AIX 5.2,MS Windows 95/98/NT/2000/XP |
RDBMS Tools |
TOAD 7.x/8.5 |
Databases |
Oracle 10g/9i/8i, DB2, SQL server 2000 |
Languages |
SQL, PL/SQL |
Scripting |
Unix shell scripting |
Graphics |
MS-visio 2007. |
Education/Technical Certifications:
· Master’s in computer science, Bachelor in Arts in India
Professional Experience |
Goodyear Inc., OH Mar 2009-till date
Sr.ETL Developer
Description: World Services Data warehouse
Goodyear is the world’s largest tire company. It operates more than 2,000 tire and auto service center outlets. The high-level scope of this project is to extract data from collection computers from the plants, transform it to fulfill the business rules and load to EDW tables. Once the data is available in the EDW tables, generate BI reports against the EDW for the Business Users. By collecting barcode data from the plants into a standard database and integrating it with production, transportation, registration, and adjustment data, Goodyear would have visibility to the tire’s life cycle.Responsibilities:
· Assisted Business Analyst with drafting the requirements, implementing design and development of various components of ETL for various applications.
· Worked exclusively on performing the ETL to Level 1 as is staging, Level 2 staging, DW load based on the business rules and transformation specifications.
· Extensively used Transformation Language functions in the mappings to produce the desired results.
· Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
· Analyzed requirements from the users and created, reviewed the specifications for the ETL.
· Designed Incremental strategy, Created Reusable Transformations, Mapplets, Mappings/Sessions/Workflows etc.
· Used Session parameters, Mapping variable/parameters and created Parameter files for imparting flexible runs of workflows based on changing variable values.
· Created Complex ETL Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Dynamic Lookup, and Connected and unconnected lookups, Filters, Sequence, Router and Update Strategy
· Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
· Implemented Slowly Changing Dimensions (SCD, Both Type 1 & 2).
· Worked with complex mapping using transformations such as Expression, Router, Lookup, Filter, Joiner, SQ, Stored Procedures and Aggregator.
· Worked on existing mapping for the performance tuning to reduce the total ETL process time.
Environment: Informatica Power Center 8.6, Oracle 10g, Windows NT, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting.
Centene corporation, St.Louis MO Mar 2008 – Feb 2009
ETL Developer
Claims processing (Medicare/Medicaid)The client is a leading multi-line healthcare enterprise that provides programs and related services to individuals receiving benefits under Medicaid, including the State Children’s Health Insurance Program (SCHIP), as well as Aged, Blind, or Disabled (ABD), Foster Care, Long-Term Care and Medicare (Special Needs Plans).
Working as a Technical analyst, I was responsible for handling diverse technical activities that included managing the ETL processes, analyzing and documenting the technical specifications, reverse engineering process flows and deducing the corresponding business rules and process rules, maintenance of the User acceptance Test (UAT) manual.
Responsibilities:
· Analyzed, inspected and laid the framework for Claims process Engine, a process designed and customized by external vendors for the client.
· Comprehensively analyzed and systematically documented the end-to-end flow of the Inbound and Outbound claims file (834 HIPAA). Informatica B2B
· Extensively Worked in Processing Structured and Unstructured data.
· Informatica B2B Data Transformation supports transformations and mappings, via XML, of
most healthcare industry standards including HIPAA 275,277.
· Resolved the anomalies arising in the file processing across individual stages of data flow.
· Deduced the business rules and process rules from the stored procedures that were an active part of the MEMBER’S load reporting layer.
· Designed, Developed and unit tested the ETL process for loading the Medicaid/Medicare records across STAGE, LOAD and ACCESS schemas.
· Accomplished the Provider directory load (a five step sequential process) using informatica for the states of AZ and FL.
· Extended the functionalities of existing ETL process of Medicaid for Medicare.
· Extensively worked on the transformations like Source Qualifier, Filter, Joiner, Aggregator, Expression and Lookup.
· Used session logs, workflow logs and debugger to debug the session and analyze the problem associated with the mappings and generic scripts.
· Maintained documents for Design reviews, Engineering Reviews, ETL Technical specifications, Unit test plans, Migration checklists and Schedule plans.
· Worked with HIPPA 5010 for reduces risk and provides flexibility and complete bi-directional transaction crosswalk transactions.
Environment: Informatica Power Center 8.1/7.1.3, HIPPA5010, SQL server 2000, DTS, Oracle 10g, Windows NT, VB, Flat files (fixed width/delimited), MS-Excel, UNIX shell scripting.
Circuit City Stores Inc, Richmond,VA Nov 2006 – Feb 2008.
ETL Developer/Analyst
Floor and Space Planning (FSP)Circuit City is a Fortune 200 company and the third largest consumer electronics retailer in the United States with over $11 billion USD in sales. Working as a ETL Designer, I was primarily involved in designing, developing and testing the mappings meant for processing Floor and Space related data using informatica. The FSP application team generates the source data using JDA tool which in turn is staged and transformed in EDW and subsequently stored in EDM for reporting. The sources and targets were ORACLE, DB2 and Flat Files respectively.