SQL Developer/ETL Tester Resume Santa Clara, CA - Hire IT People

SUMMARY

Over 7 years of experience in Software Development with expertise in design, development, Analysis and Testing of various technologies
Technical expertise in Python, Mongo DB, ETL Testing, Informatica, ORACLE, SQL, JavaScript
Expertise in NoSQL database MongoDB
Excellent understanding and working knowledge of Python
Working knowledge of Unix at system level
Install, Configure and monitor numerous MongoDB and NoSQL instances
Study the database needs of our applications and optimize them using MongoDB and NoSQL
Strong knowledge of relational and NoSQL databases
Understanding of Database Architecture
Experience in using Version Control Systems like GIT
Thorough understanding of Sharding, Query analysis and DB Schema design
Strong knowledge in MongoDB concepts - CRUD operations and aggregation framework
Experience in the design of Mongo DB database - Indexing and Sharding
Expertise in Business Requirements Analysis, Application Design, Data Modeling, Development, Testing and Documentation which includes Business Requirement Documents (BRD), Functional Requirement Documents (FRD) and Software Requirement Specification (SRS)
Excellent understanding of Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC) and Test Methodologies
Expert proficiency in SQL Scripting
Involved in all phases of testing such as Unit Testing, Regression Testing, Integration Testing, System Testing and User Acceptance Testing
Strong knowledge in Object Oriented programming making code more flexible, maintainable analyzing various performance or run-time complexities
Extensive experience in developing Test Cases, Test Plans, Test Metrics, Test Summary and Defect Reports
Excellent communication skills, interpersonal skills, self-motivated, quick learner & team player

TECHNICAL SKILLS

Databases: MongoDB, Oracle 11g, SQL, DB2, PL/SQL

ETL: Informatica Power Center 8.6, Power Mart, Data mart, ETL, OLTP, OLAP, Star Schema, Snowflake Schema, WS FTP PRO, SQL Developer, UNIX Shell Scripting

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, FACT, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Erwin 4.0/3.5.2/2. x

Languages: Python, C

Environment: Windows, UNIX, MS-DOS

Scripting Languages: Python 2.7, Unix shell scripting

PROFESSIONAL EXPERIENCE

Confidential, Santa Clara, CA

MongoDB Developer

Responsibilities:

Conducted requirement and impact analysis received from the business team
Designed migration procedures and Created applications in Python to do the data migration from Oracle to MongoDB
Developed Python scripts using multithreading module
Defined collections to store data in MongoDB
Wrote aggregation functions to perform different types of calculations
Expertise in MongoDB Schema Design using DB Ref, Manual Ref
Used the mongo import command to load the huge data into the Database
Developed the code with CRUD operations and aggregation framework to interact with the database
Performed Unit and end-to-end Integration testing

Confidential, San Francisco, CA

SQL Developer/ETL Tester

Responsibilities:

Analyzed the business requirement document and the system requirement document to arrive at a detailed Test Plan
Executed test cases for complex mappings that involved Expression, Filter, Aggregate, Join, Lookup, Router, Sequence, Update Transformations (business rules) procedures for new functionality
Involved in creating test cases based on the requirement and review with the client
Performed all phases of testing: System, Integration, and Regression testing
Executed shell scripts to refresh the QA DB in order to reflect the changes made to the mapping workflows
Generated defect reports for project status meetings as necessary. Involved in Quality Center activities and used Quality Center for executing test cases, JIRA for logging defects, creating data warehouse test plan and handling test lab activities
Interacted with the Business Users for user acceptance testing
Interacted and worked with the development teams to resolve issues observed during test execution
Participated in test case review and walkthrough meetings
Maintained warehouse metadata, naming standards and warehouse standards for future application development

Confidential

SQL Developer/ETL Tester

Responsibilities:

Preparation of Test Cases based on Business Specification Document
Executed the developed Test Cases and Test Plans
Involved in Unit testing and integration testing Functional testing, System testing, Regression testing and Back end testing
Worked with Requirement Analysts, Developers, and other testers to resolve issues with requirements
Involved in Unix script testing for efficiency improvement of loading process
Validating the data files from source to make sure correct data has been captured to be loaded to target tables
Extensively used SQL queries for data validation and backend testing

We provide IT Staff Augmentation Services!

Sql Developer/etl Tester Resume

Santa Clara, CA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship