We provide IT Staff Augmentation Services!

Qa Etl Tester Resume

3.00/5 (Submit Your Rating)

Dallas, TX

SUMMARY:

  • Over 8+ Years of experience as Quality Analyst/ETL Tester/SQL Server BI developer (SSIS/SSRS) including writing T - SQL Programming.
  • Experience in migrating from SQL Server 2000 to SQL Server 2005 and from SQL Server 2005 to SQL Server 2008 R2.
  • Experience in Objects creation such as Tables and Views, Table Normalization, User Defined functions, Indexes, Stored Procedures, coding, Correlated sub queries, Cursors and Triggers.
  • Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2005/2008.
  • Created the Different types of reports such as Linked, Sub report, Cascading report, Drill down and drill through Reports.
  • Experience in Data Warehousing/ETL testing and BI Reports Testing.
  • Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to an Enterprise Data Warehouse.
  • Proficient in using global variables, expressions and functions for the reports.
  • Generated reports using SSRS that could be used to send information to diverse group of users.
  • Create and maintain SSIS packages to extract transform and load data in to SQL Server.
  • Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and Data stage tools.
  • Experience in SSIS tools like Import Export wizard, Package installation, and SSIS Package Designer.
  • Experience in the ETL processes involving migration and sync process between two databases.
  • Experience in creating configuration files to deploy the SSIS package across all environments.
  • Demonstrated strong expertise in creating logical and physical data models (dimensional, relational and NoSQL) for enterprise data warehouse.
  • Experience in ETL Data Warehousing, database testing using Informatica for job process.
  • Worked closely with DBA to perform Database back up, Restore and Replication.
  • Worked on different SSIS Tasks of data flow, control flow.
  • Experience in creating scheduling Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
  • Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Designed and developed ETL business transformation logic to successfully load data into data warehouse from several disparate source systems.
  • Experience in ETL Data Warehousing, database testing using Informatica for job process.
  • Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services.
  • Experience in extracting and transforming data using DTS Import/Export Data, Bulk Insert.
  • Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
  • Experience in SQL Server SSIS (Integration Service) package design, constructing, and deployment.
  • Extensively created dashboards against using SSRS.
  • Tested several UNIX Korn Shell scripts for ETL Testing data loading.
  • Successful in building (modelling, designing and developing) enterprise data warehouse and data marts that capture end to end business data related to customer shopping and browsing behaviour to all ordered transactions and financials in both Oracle and SQl server environments.
  • Assisted in kicking off Informatica ETL Testing jobs using UNIX and analysed the data in dimension and fact tables
  • Created OLAP Cubes based on the data stored in Facts and Dimensions.
  • Great Knowledge in Dimensional Modelling, Star Schema/Snowflake Schemas, ODS.
  • Established Standards and Procedures for data loading into Operational Data store, Data warehouse, data marts and ETL development artifacts.
  • Experience in Performance Optimization.
  • Experience in Data Warehouse applications testing using Informatica Power Center and Ab Initio on multiple platforms.
  • Experience in configuring and managing Linked Servers, data transfer between SQL Server and other heterogeneous relational databases such as Oracle, DB2 etc.
  • Designed and implemented various enhancements to existing Data Warehouse.
  • Supported and maintained batch load of Data Warehouse.
  • Supported and maintained Business Objects Universe overlaying Data Warehouse. data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
  • Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.
  • Involved in testing data mapping and conversion in a server based data warehouse.

TECHNICAL SKILLS:

RDBMS/DBMS: SQL Server 2005/2008/2008 R2

BI Tools:: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Studio, Visual studio 2008, T-SQL, DTS.

Languages:: T-SQL.

Operating Systems: Windows 2008/2003/2000/ NT 4.0, Window XP/VISTA/7

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

QA ETL Tester

Responsibilities:

  • Worked independently to uncover and resolve issues associated with finding data that can be used by Compliance Tester to monitor operational compliance.
  • Maintained Data Warehouse metadata, naming standards and Data warehouse standards for future application development.
  • Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and Data stage tools.
  • Served as a consultant to test Designer to ensure appropriate data filters are applied based on the business / product needs.
  • Tested all the ETL Testing processes developed for fetching data from OLTP systems to the target Market Data warehouse using complex SQL queries.
  • Analyzed the SSIS package to see whether its meets the criteria proposed by the test owner.
  • Updated SSIS package to meet the criteria proposed from the test owner.
  • Tested all phases of ETL testing including Extraction, Transformation and Loading.
  • Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the data warehouse.
  • Extensively used ETL Testing methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution.
  • Verified the requirement of the test owner and updated it to meet the Compliance Control Regulation.
  • Created the optimized SQL query to pull the sample from database using RAND () and NEW ID () function.
  • Created the SSIS Package the using different task and transformation in the control flow and data flow task of SSIS.
  • Exposure on ETL testing and data ware house testing.
  • Use dimensional modelling, star schema/snow flake schema to design fact tables and dimension tables in data warehouse.
  • Worked as ETL tester responsible for the requirements gathering / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Developed, Deployed and monitored the SSIS Packages.
  • Created SSIS package using SSIS Designer to export data from the heterogeneous data from OLED DB Source, Excel Spreadsheet to the SQL Server 2014.
  • Designed and deployed data warehouse. Designed data models for the data warehouse and involved in the extract.
  • Participated in Design/Discussions of ETL flow from different source systems into Datawarehouse(DWH) model(Start Schema).
  • Created and updated CTEs, Stored Procedures, Views to retrieve the data from the database.
  • Provided analytical support in EIT activities related to multiple Compliance Control Function.
  • Analyzed the pre-existing T-SQL query to see if it meets the requirement from the test owner.
  • Updated the T-SQL query to meet the criteria from test owner.
  • Gathered and organized data in order to track, report and monitor effectiveness of controls and tracking, monitoring and escalation of risk related to management.
  • Investigates data attributes within various operation and the reporting database. Builds logics for automated data extraction and validation for EIT testing.
  • Validated SSRS reports and ETL testing with use of complex SQL queries and UNIX scripting.
  • Acted as subject matter expert on datamining, code development, quantitative tools and automated reporting.
  • Worked within the policies and standards regarding sampling methodologies, thoroughly documented operating procedures for sampling execution.

Confidential, Willow Park, TX

DWH ETL Tester/SQL SSIS / Production Support

Responsibilities:

  • Participated in the meeting to take the business requirement, and organized the meeting to convey the thought and the business flow and the requirement.
  • Demonstrated QA Test Plan with cross-functional team to approve business logic and baseline documents.
  • Testing Data warehouse ETL components by Executing SQL and PL/SQL Queries.
  • Created and maintained test scripts in Quality Center and co-ordinate with the ETL group and other developers.
  • Created ETL test data for all DWH ETL mapping rules to test the functionality of the Informatica Mapping
  • Wrote SQL queries to validate the actual result with expected result.
  • Prepared Test Cases for the mappings developed through the ETL Informatica tool and executed those Test Cases.
  • Extensively used DWH ETL for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
  • Conducted manual execution of test scripts, evaluated the expected results with actual results and logged defects
  • Created the database for the new client.
  • Created the complex stored procedure that inserts update the system in the single shot.
  • Created the triggers, views, table and set up the replication plan for the database.
  • Wrote the query to back up the production, QA database and implemented it in the SQL job to run it every night.
  • Created complex ETL Packages using to extract data from staging tables to partitioned table with the incremental load.
  • Created SSIS Reusable package to extract the data from multi formatted flat file, excel, XML files into UL Database and DB2 Billing system.
  • Worked Closely with the manager to deploy the package across the environment.
  • Developed the SSRS report and prepared the dashboard to show the performance of each department based upon the quantity of task they accomplished.
  • Prepared the automated email system to send mail to user, using an SQL Server SP-Mail Stored proc.
  • Developed the Cascading SSRS Report to with the multiple parameters.
  • Created the Stored procedure to help the C# Developer in the work.
  • Created the Stored procedure that loads the data directly from the Excel file.
  • Created the Rounding function for the payroll department, to display the total time worked in to the hundred.
  • Created the views that retrieves the data from multiple tables. It helped the C# developer to implement it in the UI.
  • Developed various types of reports like drill down, matrix, cross tab, ad hoc, Parameterized and cascading parameterized reports using SSRS.
  • Participated in the creating new environment for the new client.
  • Functional testing the application and made necessary changes in the stored procedure.
  • Did the product support to explain the user the how the application can be used and what are the plus point of the application.
  • Participated in the meeting with the users and gathered the issues raised by the user and took the action resolve it.

Confidential, Irving TX

ETL Tester/SQL, SSIS, SSRS Developer

Responsibilities:

  • Participated in the meeting to gather the business as well as the functional requirement.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Data Stage Mapping
  • Analyzed and created the bug tracking reporting and summary report in the Quality Center
  • Tested Complex ETL SSIS Packages and Sessions based on business user requirements and business rules to load data from different source
  • Worked with SSIS system variable, passing variables between packages.
  • Performed Verification, Validation, and Transformations on the Source data before loading into target database.
  • Written complicated of SQL queries for data validation and data verification based on data mapping document.
  • Wrote SQL queries in Toad and SQL server Management studio 2008 to validate the source and target systems
  • Extensively executed T-SQL queries in order to view successful transactions of data between sources
  • Designing the star schema for the data mart
  • Tested the reports generated by (SSRS) SQL Server reporting services and checked as they are as per the Organization standards.
  • Experienced in writing complex SQL Queries, Stored Procedure, Functions, Trigger, View, Cursor and various database objects.
  • Created the template reprocess the various file.
  • Created the template to update the data for team who only have read-Only excess to the production Database.
  • Designed and developed the SSIS package to import the data from various sources such as Excel, Flat file, SQL Server 2005 etc.
  • Used various task and transformation in SSIS Dataflow, Control Flow using For loop container, For each loop container, fuzzy lookups etc.
  • Implemented Event handlers and Error Handling in SSIS packages.
  • Created the SSIS package for data conversion utilizing Data conversion as well as the Derived Column transformation.
  • Configured the loading of data into the slowly changing dimensions using Slowly Changing Dimension Wizard.
  • Involved in creating the snapshot and subscription report in SSRS 2008.
  • Involved in designing parameterized reports for generating Ad-Hoc reports as per the client requirement.
  • Developed various types of reports like Drill Down, Drill Through, Parameterized Cascading report and used Gauges and KPI.

Environment: SQL Server 2012, SSDT, SSRS, SSIS, SQL Server Profiler, MS Office 2013, MS Window2008 R2, MS Windows 7, MS TFS

Confidential, Dallas TX

SQL/ ETL Developer

Responsibilities:

  • Design and development of the SQL objects like Tables, Views, Stored Procedures, Indexes etc.
  • Experience in DDL and DML.
  • Experience in creating SQL jobs using agent.
  • Wrote the complex SQL query using multiple joins for creating Ad Hoc reports using report builder based on the requirement.
  • Planned, Defined and Designed data based on business requirement and provided documentation.
  • Involved in complete SSIS life cycle in creating SSIS packages, Building, deploying and executing the package.
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
  • Involved in ETL architecture enhancements to increase the performance using query optimizer.
  • Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
  • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
  • Designed and created Report templates, bar graphs and pie charts based on the financial data.
  • Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
  • Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
  • Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Created the cubes for the departmental data mart.
  • Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server.

Confidential, Dallas, Texas

SSRS/SSIS Developer

Responsibilities:

  • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
  • Wrote efficient stored procedures for the optimal performance of the system.
  • Created indexed views and appropriate indexes to reduce the running time for complex queries.
  • Generated custom and parameterized reports using SSRS.
  • Created reports that call sub reports in SSRS.
  • Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments.
  • Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
  • Responsible for creating datasets using T-SQL and stored procedures.
  • Created several packages in SSIS to load the different data file.
  • Used different SSIS task and transformations to implement the business logic.
  • Implemented Error Handling in SSIS packages and notified process results to various user communities.
  • Used SQL Server Agent for scheduling jobs and alerts.
  • Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server.

Confidential, Coppell, Texas

SSIS/SSRS Developer

Responsibilities:

  • Create SSIS Package to Extract, Transform and Load Data using different transformations Such as Lookup, Derived column, Conditional Spilt, Aggregate, Pivot Transformation, and slowly changing Dimension.
  • Worked on SQL Server integration service (SSIS) to integrate services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CVS, EXCEL, DB2, SQL 2000, 2005 and 2008)
  • Create configuration to make package portable and create Event handler for handling package error.
  • Use For-Each Loop Container, Sequence container, Script task, Expressions, Execute SQL Task, Variable, send mail Task, Package Execution Task to achieve business needs.
  • Create and modify Different Store procedure used in the application using T-SQL.
  • Schedule and maintain package by daily, weekly and monthly using SQL server Agent in SSMS.
  • Develop complex Store Procedure to generate Various Drill-through reports, parameterized reports, Tabular reports, matrix reports, and linked report using SSRS.
  • Designed SSIS Packages to transfer data between servers, load data into database, and archived data file from different DBMS using SQL enterprise manager/SSMS on SQL server.
  • Tuning SQL query for better performance using SQL profiler.

Environment: MS SQL Server 2005/2008/2008 R2, BIDS, 2005/2008, Windows Enterprice2003 Server, Lite Speed, SSIS, SSRS, SQL profiler, MS Excel, MS Word.

We'd love your feedback!