We provide IT Staff Augmentation Services!

Database Developer Resume

WA

SUMMARY:

  • IT professional with 9 years of experience in Development, Testing and Implementation of Data warehousing/BI solutions)
  • She has experience in Teradata, Informatica Powercenter, PL/SQL, GIT, JenkinsandUnixshell scripting.
  • Expertise in working with tools Quality Center, Jira, Qtest, Jmeter, SoapuUI, Rest Services
  • Extensive knowledge of system integration testing methodologies, defect tracking systems, and Quality Assurance process
  • Experience in SDLC models (Waterfall Model, Incremental & Agile Model)
  • Extensive experience in running various kinds of tests such asUnit, Functional, Regression, Integration, System, End to End, Performance, Load, Stress, Backend,Black Box, User Acceptance Test (UAT)
  • Expertise in Analysis of Requirement documents, Design documents & Business Rules.
  • Experience in Project Management by performing multiple roles like team member, lead/manager etc. and performing various tasks related to planning, tracking, estimation, Quality control, Risk management etc.
  • Experience in using Informatica PowerCenter 9.6.1 (Work flow manager, workflow monitor).
  • Strong experience in dealing with different data sources - Oracle, Teradata, SQL Server, MySQL, DB2, Flat file, XMLs, WSDLs, CSV files, Cobol Sources.
  • Experience in ORACLE 10g, SQL Server, Teradata, DB2 and VSAM.
  • Experience with high volume datasets.
  • Hands on experience in preparing Test plans, Test cases, Automated Tests and Test Data and executing the same and expertise on Black box Testing.
  • Good experience with setting up Control-M Job scheduling for Informatica /Datawarehouse Workflows.
  • Comprehensive analytical and problem solving skills, written and verbal communication skills
  • Certified Tester by International Software Testing Qualifications Board.
  • Experience with working with teams across multiple geographical locations and leading offshore teams in Global delivery model.
  • Quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS:

ETL Tools: Teradata, Informatica PowerCenter 9.6.1/9.5.1/8. x/7.x

Programming Languages: Java, UNIX shell scripts, SQL, PL/SQL (stored procedure)

Databases: Teradata, Oracle 11/10g, MS SQL server 2008/2005, MySQL,DB2, VSAM

Tools: Toad 10.6.1, SQL Developer 1.2., Teradata SQL Assistant. GIT, Jenkins

Testing Tools: SOAP UI, JMeter, Rest services HP Quality Center, Jira, Qtest

Data modelling tools: MS Visio

Scheduling Tools: Control-M

PROFESSIONAL EXPERIENCE:

Confidential, WA

Database Developer

Software and Tools: UNIX, Teradata, Oracle11/10g, Informatica Power Center 9.5.1, Qtest, Jira, Microstrategy, Business intelligence, SOAP UI, MS Visio, Toad 10.6.1, SQL Developer 1.2., Teradata SQL Assistant, Control-M

Responsibilities:

  • Responsibilities included development, testing and implementation of ETLs usingBTEQ,FastLoad utilities in Teradata, Powercenter mappings.
  • Created and ran load and functional test for web services
  • Part of a DevOps team which implemented this project and provided production support. She had supported CICD pipeline implementation for this project using GIT and Jenkins
  • Involved in performance tuning /identifying bottlenecks. Involved in design of the job flow for batch jobs and its restart/recovery based on business function.
  • Her responsibilities included setting up test environment, deployment and support of Teradata procedures, database components.
  • She also implemented Unix shell scripts, automated validation and verification of business function points using java framework.
  • She was involved in enhancements, post production support, analysis, and fixes for data issues.
  • Performed load and performance testing of entire batch as well as performed automated performance testing on micro strategy reports using Jmeter .
  • Setting up of test environment, deployment and support of Teradata procedures, database components.
  • Setting up Control-M jobs and their dependencies across multiple applications
  • Automated validation and verification of business function points
  • Estimation and resource plan
  • Involved in enhancements, post production support, analysis,
  • Performed unit testing, system integration testing, and supported user acceptance testing.
  • Created automation suite for relational databases sql queries for data validation and verification
  • Cross team integration and testing support.
  • Worked on UNIX shell scripts and stored procedures to perform tasks like scheduling workflows, error handling and email notification for failures of loads.

Confidential, WA

Database Developer

Software and Tools: UNIX, Teradata, Oracle11/10g, Informatica Power Center 9.5.1, MS SQL server 2008/2005, DB2, HP Quality Center, Microstrategy, Business intelligence, HP Quality Center, SOAP UI, MS Visio, Toad 10.6.1, SQL Developer 1.2., Teradata SQL Assistant, Control-M

Responsibilities:

  • Responsibilities included testing and implementation of ETLs using BTEQs in Teradata and Informatica Powecenter.
  • Cross team integration and testing support.
  • Used SOAP UI to test Web Services running on WebLogic Server.
  • Performed load and performance testing of entire batch as well as performed automated performance testing on microstrategy reports using Jmeter .
  • Worked on UNIX shell scripts and stored procedures
  • Setup scheduler jobs/Control-M.to perform tasks like scheduling workflows, error handling and email notification for failures of loads.
  • Defect fix and production maintenance.
  • She had setup Control-M jobs, developedTeradata Macrosand used various Teradataanalytic functions.
  • She has coordinated the platform outage, release management during the implementation/cutover for this project.
  • Her responsibilities included setting up test environment, deployment and support of Teradata procedures and database components.
  • She was involved in enhancements, post production support and analysis.
  • She created automation suite for relational databases sql queries for data validation and verification.

Confidential, WA

Database Developer

Software and Tools: Rest Services, Unix,Hadoop,Hive

Responsibilities:

  • Real Time Load Validation of GNIP Stream to hadoop server
  • Replay - Disconnect of data during real time data streaming will be recovered using Replay .The time of disconnect will be captured in hbase tables and once stream is established data during disconnect will be loaded to hadoop server.
  • Flume job will run to bring data from GNIP data stream to hadoop server. The data will be received as Json object and loaded to hadoop servers as json objects.
  • Using JSON diff or Pretty Diff tool we compared data loaded to hadoop server

Confidential, WA

Database Developer

Software and Tools: UNIX, Teradata, Oracle11/10g, Informatica Power Center 9.5.1, MS SQL server 2008/2005, DB2, HP Quality Center, Microstrategy, Business intelligence, HP Quality Center, SOAP UI, MS Visio, Toad 10.6.1, SQL Developer 1.2., Teradata SQL Assistant, Control-M

Responsibilities:

  • Post production implementation support responsibility
  • Tested Database objects like PL/SQL Procedures, Functions, and Packages
  • Testing of Web Services using web services client generated using SOAP UI, TCP Monitor to track request and response SOAP Messages
  • CreateUNIX Scriptsto Manipulate and Load the data
  • Designed andimplemented stored procedures and triggers for automating tasks in SQL
  • Providingstrategic and tactical direction to the team
  • Responsible for Technical implementation of the change request solution
  • Supportingenterprise data warehouse testing
  • Analysis of change request

Confidential

Database Developer

Software and Tools: UNIX, Teradata, Oracle11/10g, Informatica Power Center 9.5.1, MS SQL server 2008/2005, DB2, HP Quality Center, Microstrategy, Business intelligence, HP Quality Center, SOAP UI, MS Visio, Toad 10.6.1, SQL Developer 1.2., Teradata SQL AssistantControl-M

Responsibilities:

  • Developed design documentation and implementation proposal for extraction of data from data warehouse.
  • Involved in SOAP and Restful web services using SOAP UI
  • Developed and tested modules to extract, process & transfer the customer data using Teradata utilities.
  • Created Fast Export scripts for extracting and formatting customer data from data warehouse

Confidential

Software and Tools: UNIX, Teradata, Oracle11/10g, Informatica Power Center 9.5.1, MS SQL server 2008/2005, DB2, HP Quality Center, Microstrategy, Business intelligence, HP Quality Center, SOAP UI, MS Visio, Toad 10.6.1, SQL Developer 1.2., Teradata SQL Assistant, Control-M

Responsibilities:

  • Customized, developed and tested Database objects like PL/SQL Procedures, Functions, Packages, and Views Involved indatabase design/preparing SQL scriptsto support the larger databases
  • Reviewed and analysedFunctional requirements, Mapping documents
  • Analysed Requests for Changes and new Business requirements
  • PreparedTechnical specifications, detailed Design documentsWriting the SRS
  • Created detailed documentation using Data Flow diagrams, rule-sets/thresholds, and ETL mappings Involved in Unit and Integration Testing

Confidential

Database Developer

Software and Tools: UNIX, Teradata, Oracle11/10g, Informatica Power Center 9.5.1, MS SQL server 2008/2005, DB2, HP Quality Center, Microstrategy, Business intelligence, HP Quality Center, SOAP UI, MS Visio, Toad 10.6.1, SQL Developer 1.2., Teradata SQL Assistant, Control-M

Responsibilities:

  • Helped in Analysis activities
  • Prepared Design for New Architecture
  • Build (Coding as per requirement specification).
  • Worked in CICS online regions and coded new programs for the same
  • Provide support during user acceptance testing
  • Post implementation support.
  • Perform IQA and EQA reviews.
  • Co-ordinate all the deliverable reviews and Final Inspection
  • Involved in mentoring juniors/ freshers.

Confidential

Database Developer

Software and Tools: UNIX, Teradata, Oracle11/10g, Informatica Power Center 9.5.1, MS SQL server 2008/2005, DB2, HP Quality Center, Microstrategy, Business intelligence, HP Quality Center, SOAP UI, MS Visio, Toad 10.6.1, SQL Developer 1.2., Teradata SQL Assistant, Control-M

Responsibilities:

  • Preparation of LLD and HLD
  • Building the code
  • Preparing Test Data for Unit Testing for existing application.
  • Testing of programs with the prepared unit test plans and to compare the test results with the expected results.
  • Preparation of Design documents, Unit Test Plans and Reports.
  • Regression Testing of batch programs.
  • Ensure the quality of the deliverables by effective self-review and peer review

Confidential

Database Developer

Responsibilities:

  • Analysing and providing resolution to the service requests given by clients
  • Development and maintenance of Custom Statement Formatter (CSF)
  • Preparing Test Data for Unit Testing for existing application.
  • Testing of enhanced programs with the prepared unit test plans and to compare the test results with the expected results.
  • Preparation of Design documents, Unit Test Plans and Reports.
  • Regression Testing of batch programs.
  • Ensure the quality of the deliverables by effective self-review and peer review.
  • Generating the monthly reports and verifying it with production

Hire Now