Etl Developer Resume Profile
- 9 years of IT experience in the analysis, design, development, testing and implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.
- Solid Back End Testing experience by writing and executing SQL and PL/SQL Queries.
- Experience in Data Analysis, Data Validation, Data Cleansing, Data Standardization, Data Verification and identifying data mismatch.
- Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle SDLC with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
- Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
- Worked on Waterfall, RUP and Agile methodologies.
- Experience in using Automation Tools: Quick Test Professional, Win Runner and Quality Center in Client/Server. Experience.
- Extensive testing ETL experience using Informatica PowerCenter 9.0/8.x/7.x, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server .
- Experienced working with all kinds of test designing techniques including Decision Table, Pair wise Testing, State Transition Tables, Equivalence partitioning Boundary value analysis
- Experience in Data Modeling using Erwin in Client/Server and distributed applications development.
- Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within timeframe.
- Expert in writing SQL queries and Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
- Experience in UNIX shell scripting and configuring cron-jobs for ETL Loads
- Extensively used ETL methodology for supporting data extraction, transformations and loading processing in a corporate-wide-ETL solution using ETL tools like Informatica
- Expertise in Testing complex Business rules by creating mapping and various transformations
- Strong working experience on DSS Decision Support Systems applications and Extraction, Transformation and Load ETL of data from Legacy systems.
- Extensive experience in working with databases including Oracle 10g/9i/8i, MS SQL Server 2008/2005/2000/7.0
- Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL.
- Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming.
- Extensive experience in writing SQL to validate the database systems and for backend database testing.
- Good experience in data sources, data profiling, data validation, developing low level design patterns based on the business and functional requirements.
- Excellent communication, analytical and interpersonal skills.
Technical Skills:
OPERATING SYSTEMS | Windows XP,NT/95/2000, OS/2, Sun Solaris 2.6/2.7,Linux 6.X/7.X/8.X |
LANGUAGES KNOWN | C, PL/SQL 8.x/2.x, SQL Plus, SAS 9.1/8.1 |
RDBMS | Oracle 7.X/8/9i/10g, Teradata V2R6, MS SQL Server 6.5/7.0/2000, MS Access 7.0/'97/2000, SQL Server 11.x/12.0 |
REPORTING TOOLS | Crystal Reports 6.5, Business Objects 5.1, Cognos 6.5/7.0 |
SCRIPTING LANGUAGES | VB Script, Java Script, XSLT |
DATABASES | IBM DB2 8.x, Oracle 9i/10g, Teradata V2R6, Sybase 12.3, SQL Server 2000/2005, Netezza NPS 8050 |
TECHNOLOGIES | Active X, OLEDB, and ODBC |
WEB SERVERS | Java WebServer2.0, Netscape Enterprise Server, Web Logic 6.0. |
DATAMODELLING TOOLS | Erwin 3.5.1/4.x, Designer 2000 |
DATAWAREHOUSING | Informatica PowerCenter 9.0/8.x/7.x, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor and Informatica Server . |
Confidential
Responsibilities:
- Involved in understanding Logical and Physical Data model using Erwin Tool.
- Written Test Plan, Test Strategy, Test Script, Test Cases, Reported bugs and tracked defects using Quality Center 10.0
- Performed all aspects of verification, validation including functional, structural, regression, load and system testing
- Worked with Decision Table Test Design Technique for various test actions.
- Used all the Informatica power center 9.1.0 client components like Designer, Workflow Manger, Workflow Monitor .
- Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
- Tested the ETL Informatica mappings and other ETL Processes Data Warehouse Testing .
- Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
- Collected requirements and tested several business reports.
- Did Test coverage by adding new test actions from iteration to iteration according to the test strategy.
- Performed Functional Testing and Back-end Testing using the database comparable results Manually
- Worked on Execution Tracker, Test Design Tracker Defect Metrics.
- Did complex data validation using SQL queries.
- Tested ad hoc and canned reports for Business objects.
- Tested Business Objects reports and Web Intelligence reports.
- Managed user accounts and security using Business Objects Supervisor
- Tested the outgoing links from all the web pages from specific domain
- Tested all the internal links and tested links jumping on the same Web page Tested Cookies for all user machines and maintained the session for login sessions.
- Performed the Back-end Integration Testing to ensure data consistency on front-end by writing and executing SQL statements.
- Vigorously worked on Manual Testing by writing the Test Cases and executing the Test Scripts for various scenarios.
- Extensively used T-SQL to verify and validate the data loaded to the SQL Server 2005
- Developed Test Cases for testing the mapping designs before going to the production phase.
- Independently designed and developed project document templates based on SDLC methodology
- Extensively test the reports for data accuracy and universe related errors.
- Tested several dashboards and deployed them across the organization to monitor the performance.
- Used SQL tools to run SQL queries and validate the data loaded in to the target tables
- Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
- Involved in user training sessions and assisting in UAT User Acceptance Testing .
- Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
- Preventing occurrences of multiple runs by flagging processed dates
- Written Test Cases for ETL to compare Source and Target database systems.
- Testing of records with logical delete using flags
- Interacting with senior peers or subject matter experts to learn more about the data
- Identifying duplicate records in the staging area before data gets processed
- Extensively written test scripts for back-end validations
- Tested Standard and Ad-hoc Impromptu Reports
- Involved in automation of test cases using QTP.
- Did functional testing using QTP
- Tracked and reported the bugs with Quality center.
- Extensively worked on Mercury Test Center and ran various scenarios and scheduled them. .
- Tested users and user classes through Access manager
- Tested multi dimensional cubes using models and implemented incremental updates for power cubes
- Created Impromptu Reports and modified existing reports as per users requirement
- Experience in creating UNIX scripts for file transfer and file manipulation.
- Created Test input requirements and prepared the test data for Data Driven testing.
- Created ETL execution scripts for automating jobs.
- Involved in extensive DATA validation using SQL queries and back-end testing
- Tested the different sources such as Flat files, Main Frame Legacy Flat Files, SQL server 2005 and Oracle to load into the Teradata data warehouse
- Performed front-end testing on Data Portal and Executive Credit Risk Dashboard portal
- Used workflow manager for session management, database connection management and scheduling of jobs.
Environment: Informatica Power Center 9.0/8.x/7.x, Business Objects Enterprise XI R2 / XI R3, Mercury Quality Center9.2, QTP 9.2, IBM Rational Functional Tester, Windows NT 4.0, SQL Server 2008, Quality Center 10.0, DTS, T-SQL,SQL, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 10gi, PL/SQL, IBM DB2, WinSQL, TSO, Java Scripts ,SOAP, SAML, WSDL, XML, XSD.0, Microsoft Visio 2003, MS Access, XML/VSAM/Flat Files,
Confidential
ETL Tester Equity Financing Data Warehouse
- Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
- Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
- Performed Black-box testing, White-box testing, System Testing, Data Integrity Testing, Sanity, Regression and end-end testing .
- Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
- Responsible for testing Business Reports developed by Business Objects XIR2.
- The reports that were created in Business Objects were testing by running the SQL statements.
- Used Quick Test Pro to write the automated test scripts by using various actions and reusable actions.
- Worked in keyword view as well as expert view of Quick Test Pro.
- Configured Quick Test Pro with Quality Centre and Maintained the project information in Quality Centre.
- Developed and involved in both Manual Testing and Automation Test scripts based on Use cases developed.
- Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
- Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
- Used T-SQL for Querying the SQL Server database for data validation and data conditioning Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
- Involved in the error checking and testing of the ETL procedures and programs Informatica session log..
- Experienced in writing test cases, test scripts, test plans and execution of test cases reporting and documenting the test results using Quality Center.
- An extensively used Complex SQL statement for retrieving data using TOAD and it is used in TSL scripts
- Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
- Created the test environment for Staging area, loading the Staging area with data from multiple sources.
- Extraction of test data from tables and loading of data into SQL tables.
- Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
- Tested the ETL Informatica mappings and other ETL Processes Data Warehouse Testing.
- Tested several stored procedures.
- Worked with Equivalence Partitioning and divided the input data into various partition of data based on test case condition.
- Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
- Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
- Experience in creating UNIX scripts for file transfer and file manipulation.
- Validating the data passed to downstream systems.
- Worked with Testing Data Extraction, Transformation and Loading ETL .
- Involved in testing data mapping and conversion in a server based data warehouse.
- Involved in testing the UI applications
- Used Informatica Designer to test mappings, transformations and source and target tables
- Tested various Drill through reports from report to report.
- Reported operations sum and average, intersection, etc.
- Used Quality Center to track and report system defects
- Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
Environment: Informatica 8.1/7.1, Informix, DB2, Java, Business Objects Enterprise XI R2 / XI R3, SQL, SQL Server 2000/2005, Teradata V2R6 MLOAD, FLOAD, FAST EXPORT, BTEQ , Teradata SQL Assistant 7.0, XML, XSLT, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra edit, Rumba UNIX Display, Quality Center 9.2.
Confidential
Responsibilities
- Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
- Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
- Written complex SQL queries for querying data against different data bases for data verification process.
- Designed the data flow diagrams using VISIO.
- Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
- Preparation of technical specifications and Source to Target mappings.
- Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
- Worked with SOAPUI for testing Web Services
- Tested both the Web Service Architecture and Service Oriented Architecture
- Created several SOA test cases for validations which were based on the behavior of a specific service.
- Written test cases to test the application manually in Quality Center and automated using Quick Test Pro.
- Developed automated test scripts from manual test cases for Regression testing based on the requirement documents using Quick Test Professional.
- Written Test Plans and Test Cases on Mercury's Test Director Tool.
- Defects identified in testing environment were communicated to the developers using defect tracking tool Mercury Test Director.
- Developed scripts, utilities, simulators, data sets and other programming test tools as required for executing test plans.
- Tested several Ab Initio graphs for each line of business and created test data for the same.
- Tested a number of complex ETL graphs, transformation logic for both full load and daily data loads.
- Creating test cases for ETL graphs and design documents for production support.
- Setting up, monitoring and using Job Control System in Development/SIT/QA/UAT/Prod.
- Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
- Scheduling and automating jobs to be run in a batch process.
- Effectively communicate testing activities and findings in oral and written formats.
- Reported bugs and tracked defects using Test Director 6.5
- Extensively used Informatica power center for extraction, transformation and loading process.
- Worked with ETL group for understating mappings for dimensions and facts.
- Extracted data from various sources like Oracle, flat files and SQL Server.
- Worked on issues with migration from development to testing.
- Extensively tested several Cognos reports for data quality, fonts, headers cosmetic.
Environment: SAS/Base 8.1, SAS/Macros, SAS/Stat, SAS/Graph, SAS/ODS, SAS/SQL, SAS/Connect, SAS/Access, SAS/ETL, UNIX Shell Scripting, SOAP, SOAPUI, Web Services ,Ab Initio GDE 1.12, Co>Op 2.12 , Mercury Test Director 6.5, QTP 7.2, SQL Loader, Cognos 7.0 Series, Oracle8i, SQL Server 2000/2005, Erwin 3.5, Windows 2000, TOAD 7