We provide IT Staff Augmentation Services!

Sql Developer And Etl Test Lead Resume

SUMMARY

  • Experience in Data Warehouse with exceptional technical, analytical skills and project management skills
  • Developed Complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL
  • Developed UNIX Shell script and BTEQ script to perform ETL process in the Active Enterprise Data Warehouse
  • Experience in performance tuning in PL/SQL, SQL, IBM DataStage and Teradata SQL and expertise in writing complex SQL queries
  • Well versed in querying and testing RDBMS such as MS SQL Server and Teradata using SQL, PL/SQL for data integrity
  • Developed Teradata Utilities such as Mload, Fast Load, Tpump and TPT scripts to load and extract data
  • Worked on multiple databases such as Teradata, Oracle, SQL server.
  • Designed DataStage jobs to extract, transform and load data from various sources like Text files, XML, CSV, Teradata, MS SQL Server and Oracle into Data Warehouses
  • Designing Unit Test Cases, Unit Test Report and Unit Test Summary Report
  • Good knowledge in various testing assignments in Functional Testing, Regression Testing, Data warehousing Testing, System & Integration Testing
  • Developed Python script for ETL testing to compare the data loaded between ETL load job and Testing SQL
  • Used Python script to fetch data from different databases such as Teradata, Oracle, SQL server to test the ETL jobs
  • Used Python scripting to parse the complex data formats like XML, Json and HTML to load the data into tables for testing.
  • Experience in preparing Master Test Strategy, developing Test Plan, Test Scenarios, Test Cases, Test SQL Scripts for Business Requirements to support quality deliverables
  • Performed end to end ETL testing for the Informatica and IBM DataStage ETL jobs using complex SQL queries
  • Good knowledge and experience in various subject areas like Client, Group, Product, Member Enrolment, Claims, Provider and Lab Results in Healthcare Domain
  • Strong knowledge of all phases of SDLC, Agile & Waterfall methodology
  • Worked with production control team in preparing the job run instruction and scheduling the jobs in production
  • Close coordination with Business stake holders to troubleshot issue and fulfil the data requirement
  • Have hands on experience on Tableau dashboards created multiple graphs that includes bar graph, line graph, geographic graphs & stacked bar graphs. Implemented row level security on the dashboards
  • High level of proficiency with HP ALM, JIRA, AZURE, Rational Quality Manager & Rational Clear Quest to manage testing activities and defect tracking
  • Has the ability to build and manage teams and create a high - performance environment
  • Experience in leading onshore & offshore team comprising 10 resources
  • Holds the credit of conducting trainings on Data Warehouse Concepts for the new joiners in the project
  • Effective communication with stake holders, ready to take responsibilities with excellent interpersonal skills

TECHNICAL SKILLS

Tools: SQL Developer, IBM DataStage, Teradata SQL Assistance & Informatica

Languages: SQL, Python, PL/SQL, MS Excel VBA & Unix Korn Shell

Database: Teradata, Oracle, MS SQL Server

Methodologies: Agile Scrum, Agile Kanban & Waterfall

Defect & Test Management Tools: HP ALM, JIRA, AZURE, Rational Quality Manager & Rational Clear Quest

PROFESSIONAL EXPERIENCE

SQL Developer and ETL Test Lead

Confidential

Tools: : SQL Developer, Teradata, DataStage, UNIX, ALM, AZURE & VSTS

Responsibilities:

  • Extracted and sourced the Client, Group, product, Member Enrollment, Provider and Claims data into Active Enterprise Data Warehouse
  • Performed End to end ETL development to extract, transform and load data from various sources like Text files, XML, CSV, Teradata, MS SQL Server and Oracle into Data Warehouses
  • Managing various vendors for sourcing and extracting data from Active Enterprise Data Warehouse.
  • Developed UNIX Shell Script and BETQ to perform ETL in Data Warehouse
  • Expert in writing SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Stored Procedures, User-defined Functions, and Views
  • Involved in Performance tuning of the PL/SQL, SQL and Teradata SQL queries to enhance the performance
  • Performed end to end ETL testing for the Informatica and IBM DataStage ETL jobs using complex SQL queries
  • Developed Python script for ETL testing to compare the data loaded between ETL load job and Testing SQL
  • Involved in resolving Critical Issues by performing fixes/enhancements to the ETL jobs built using DataStage
  • Optimized the existing jobs for better performance and implemented new business logic
  • Created complex Stored procedures & views for reporting purpose
  • Create Master Test Strategy, Test plan and assigning work to offshore team on daily basis
  • To prepare End of Test Report/ Test Closure Reports and seeking the approval from key stakeholders
  • Maintained cordial relationship with end customers which helped the team in gathering necessary requirements for enhancements and analysis
  • Coordinated with the client and with Off-Shore teams to get the work done and to deploy in production on time
  • Responsible to gaining the Sign-off from business analyst and vendors
  • Responsible to migrating the code for various environments such as Test, Pre-production and Production
  • Responsible to assigning work to offshore team, clarify their queries with the business confirmation and reviewing their work and documentation on the daily basis
  • Resolve issues faced by the team members and help them to progress in their work front

SQL Developer

Confidential

Tools: : Microsoft SQL Server, JIRA, Rational Quality Manager & Rational Clear Quest

Responsibilities:

  • Responsible for Requirement gathering with the business analyst from the onsite
  • Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction.
  • Involved in database tuning and performance activities.
  • Documentation of complex data flows, data models and Source to Target mapping
  • Created tables and created indices for better query performance
  • Walkthrough with offshore team on the business requirements and clarify their queries with the business confirmation
  • Involved from the initial phase of the project discussion with the business stakeholders
  • Responsible to report daily status, weekly test report, issues and resolution to client team
  • Conducted unit tests using various test cases as well as conducted QC testing
  • Providing functional guidance and reviewing the work and all project documentation prepared by the team before publishing to client
  • Worked on the Rational Quality Manager, Rational Clear Quest & JIRA for the defect management

ETL Tester

Confidential

Tools: : DataStage, Teradata, UNIX, QC & ALM

Responsibilities:

  • Responsible for test planning, test preparation, test execution and defect tracking
  • Create test case scenarios for the business requirement
  • Developed ETL jobs to Load and Extract data from AEDW
  • Developed UNIX Shell Script and BETQ to perform ETL in Data Warehouse
  • Developing SQL queries to perform testing by comparing the source system data with the data moved into the Active Enterprise Data Warehouse and data extracted from the Active Enterprise Data Warehouse
  • Create Mload, Fast Load, Tpump and Bteq scripts to load and extract data
  • Responsible for testing end to end ETL process in Loading and Extracting data in AEDW
  • Liaise with the onshore client and onshore lead on the status of the project in daily status calls
  • Log defects and tracking using Quality Center and ALM

SQL Developer

Confidential

Responsibilities:

  • Fuji Xerox project was an upgradation project from oracle 11i to r12
  • Retrofitting the interfaces to r12 both inbound and outbound interfaces
  • Involved in Query tuning of Batch jobs to reduce execution time
  • Work closely with the technical team to resolve the upgrade issue on time
  • Performing Integration Testing and Unit Testing

Hire Now