SQL developer Resume

SUMMARY

Around Eight years of extensive experience in Information Technology with special emphasis on Design and Development of Data Warehousing using Informatica Power Center 9.6.1/9.1/8.6.1 /8.5.1 , IDQ and SSIS.
Over 6 years of working experience in all the phases of the Data warehouse life cycle involving design, development, and analysis and testing in the various areas of Data warehousing.
Hands on experience in the reconciliation process and audit tables.
Strong Experiencein ETL design, ETL Architecture Solution, Development and maintenance.
Expertise onInformatica Mappings, Mapplet, Sessions, WorkflowsandWork letsfor data loads.
Experience inInformatica Performance Tuning of Targets, Sources, Sessions, Mappings and Transformations.
Extensively used Informatica Client tools such as Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations, Workflow Manager/Monitor and Informatica Repository Manager.
Proficient in Oracle 11g/10g/9i, SQL, PL/SQL, SQL*Plus, SQL developer and Toad.
Created ETL mappings using Informatica PowerCenter to move Data from multiple sources like XML, Copybooks, SQL server, Flat files, Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
Implemented Slowly Changing dimension methodology for accessing the full history of accounts and transaction information.
Extensive experience in developing complex mappings from varied transformations like Source Qualifier, Connected and Unconnected lookups
Router, Filter, Sorter, Expression, Aggregator, Joiner, Union, Update Strategy, Sequence Generator etc.
Worked with various SQL Editors such as TOAD.
Good understanding and exposure to Data Warehousing techniques such as Star - Schema Modeling, Snowflake Modeling, OLAP, Fact tables, Dimension tables.
Hands on experience in Tuning Mappings, Identifying and resolving Performance bottlenecks in various levels like sources, targets, mappings, and sessions.
Strong analytical, logical and problem solving skills and ability to quickly adapt to new technologies by self-learning.
Experienced with coordinating cross-functional teams, project management and presenting technical ideas to diverse groups.
Ability to work independently as well as in a team, fun-filled and challenging environment.

TECHNICAL SKILLS

Data Warehousing: OLAP, OLTP, Star Schema, Snowflake Schema, RDBMS

Other Tools: TOAD,SQL Developer, Autosys, JIRA, ALM, Team Foundation Server

Programming Languages: PL/SQL, Unix Shell Scripting

Databases: Oracle Teradata, SQL Server, Nateeza, Postgress

ETL Tools: Informatica PowerCenter, IDQ, SSIS

Operating Systems: Windows UNIX, LINUX

Project Management tools: MS Project, UML diagram, data modeling with MS visio.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship