System Engineer Resume

SUMMARY

3 years 7 months experience in Development, Implementation, Testing and Maintenance of Enterprise Data Warehouse (EDW) for Insurance and Banking customers using Informatica Powercenter 9.5.1, Oracle SQL, MS SQL, Business Objects Data Services, Oracle warehouse builder and Unix Shell Script.
Comprehensive problem solving abilities, excellent verbal and written communication skills, ability to deal with people diplomatically, willingness to learn and a good team member.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

System Engineer

Responsibilities:

Developed and maintained EDW using Informatica 9.5.1,Oracle SQL Developer, Oracle 11g,MS SQL Server, Unix
Proficiency in developing SQL for validating ETL implementation against Business rules with various relational databases like Oracle, SQL Server
Handled early arriving facts, incremental load with parameters and UNIX files.
Extensively worked in development of Reusable components, handling dependency among workflows
Involved in extracting the data from the Flat Files and Relational databases into staging area.
Implemented Slowly Changing Dimension methodologies.
Created component Lists for all Objects, Migration Document, Dependency Structures, Mapping Documents
Scheduled jobs using Informatica Scheduler
Created Unix Shell scripts for customizing the job runs, Created Wrapper scripts and Parameter generation scripts.
Created and Monitored Tasks, Workflows and Worklets using Workflow Manager.
Handling Files with Post session and pre session commands
Worked closely with the end users and Business Analysts to understand the business and develop the transformation logic to be used in Informatica

Confidential

System Engineer

Responsibilities:

Involved in development and maintenance of Enterprise Datawarehouse using Oracle Warehouse Builder (OWB), SAP Business Objects Data Services (BODS), Oracle SQL Developer.
Performed Unit Testing and validation of the ETL implementation using SQL developer.
Created PL/SQL procedures.
Use of Complex SQL queries for Data Validation and Testing.
Created Mapping Documents, component lists and test documents.