ETL Developer and Tester Resume

PROFESSIONAL SUMMARY:

4.6 years of experience in Data Ware housing
Presently working with Cognizant Technology Solutions as ETL/Business Intelligence developer.
Acquired practical knowledge and experience in DW technologies like Oracle Business Intelligence (OBIEE), informatica 9.1, informatica 10 and databases like Oracle, Teradata.
Proficient in Oracle SQL query and data analysis
Have experience in domains like: Manufacturing &logistics, Communications and Life science
Have knowledge in ETL development using different modules of Informatica Power Center 9.1, Informatica Power Center 10.1and good knowledge of business Intelligence tools like OBIEE.
Experience in integrating SharePoint data with Salesforce using Power Center
Good knowledge in salesforce integration through power center.
Performed POC for informatica cloud connector for SharePoint.
Worked on databases including Oracle 11g, Teradata
Expertise in planning, design and streamline ETL tasks, verifying Data Quality and Data Integrity
Basic knowledge in UNIX Bash Shell Scripting.
Developed various interactive reports and dashboards using OBIEE 11 g which provided insights to the business trends, enhanced the data visualization.
Expert in Deliverables like Functional Requirement specification, Design Document, Unit test document, Requirement Tractability matrix etc.
Experience in System Testing, Regression Testing, Data (ETL) Testing and OBIEE Testing.
Good knowledge of Data Warehouse Architecture and concepts including top down/bottom up/change data capture.
Good communication and interpersonal skills

TECHNICAL COMPETENCE

Tools: OBIEE 11g, Informatica PowerCenter 9.1, Informatica PowerCenter 10.1,Teradata SQL Assistant, Oracle SQL Developer, Cloudingo Studio for Salesforce, Data loader for salesforce

Database: Oracle 11g, Teradata

Languages: Oracle SQL,PL SQL, Unix Scripting, SOQL

BI Technologies: OBIEE 11g

Database: Oracle, My SQL, Teradata

ETL testing: OBIEE 11g, Informatica

Testing Tools: Platinum V2.1,HP ALM

Domains worked: Manufacturing &logistics, Communications and Life science

Hardware/ Platforms: Windows XP/2000/2003, Windows 7

Attended: Informatica PowerCenter 9.1

WORK EXPERIENCE:

Confidential

Tool: Putty, Oracle, informatica

ETL Developer and Tester

Responsibilities:

Design and analysis of the proposed data flow.
Development of the mapping.
Implementation of SCD type 2 logic in the Stage - ODS layer.
ETL and Functional testing of all the requirements, System Integration testing. Deployment to higher environments and UAT Support.
Development of Initial design document, UTD,RTM

Confidential

Tool: Putty, Oracle, informatica, Cloudingo studio for Salesforce, workbench, Data loader

ETL Developer

Responsibilities:

Design and development of Share point data load to oracle tables
Trial of Cloud connector, web services, HTTP transformation etc for achieving the solution.
Share point data (including List data and various data formats) loaded using Restful API. Non-list data (Documents) also loaded to salesforce.
ETL and Functional testing of all the requirements, Deployment to higher environments and UAT Support.

Confidential

Tool: Oracle SQL Developer, Putty, OBIEE 11g

OBIEE Developer

Responsibilities:

Contributed in preparation of technical specification and design documents.
Enhancements in the Field Service - CB Dashboard Reports to improve the data visualization.
Verification of report with the backend data
Worked on Test scenarios for GUI and expected Functionality like drill reports, exporting functionality etc.

Confidential

Tool: Oracle SQL Developer, Putty, OBIEE 11g

OBIEE Developer

Responsibilities:

Involved in Storyboard preparation as per requirements, technical specification and design documents
Created reports in Analysis/Answers and dashboard prompts and embedded them in Dashboards.
Development of Dashboards, Prompts and filters.
Provided support and fixed defects for all reports, Test plans and performed unit testing

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship