Data Warehouse Developer Resume

SUMMARY

Over 7 years of IT experience in System Analysis, Design, Development, Implementation and Testing of Data Warehouse and Data Integration applications in domains like Financial, Banking, Insurance, and Telecommunications.
Extensive experience on ETL (Extract Transform Load) Data Warehouse experience using Informatica Power center 9.x/8.x/7.x and Reporting on OBIEE, Qlikview, MicroStrategy, etc.
Basic Informatica administration such as creating users, folders, privileges, optimize server settings, deployment groups, etc.
Extensive experience in data warehousing tools and technology such as Informatica PowerCenter, PowerExchange, Metadata Manager, IDQ, MDM, OBIEE, Qlikview, SSIS, SSRS, MicroStrategy, etc.
Expertise in Logical and Physical Data Modeling, E - R modeling, and Dimensional Modeling techniques such as Star and Snowflake schemas using ERWIN.
Experience in Database Design and Development using Relational Databases like Oracle 11g/10g/9i/8i, Sybase, MS SQL Server, Teradata V2R6/V2R5, Perl, DB2 UDB 8.0/7.0/6.0, MS Access 2000/2003, XML sources files, cobol files, SQL, PL/SQL, Cobol, Stored Procedures, Functions, Packages, Indexes, Sub Queries, and Performance Tuning.
Experience in full life cycle implementations in Data Warehouses including designing Understanding and working knowledge of Informatica CDC (Change Data Capture).
Implementation experience of CDC using stored procedures, and triggers.
Database Design and Development using Oracle, Teradata, and SQL Server on windows and UNIX platforms.
Extensive experience in complete Software Development Life Cycle (SDLC) from Requirements gathering, Analysis, Data Modeling, Design, Testing, Debugging, Deployment, and Post Implementation Support and Maintenance
Expertise in importing data from COBOL Files, EDI, Flat Files (Fixed Width and Delimited), and XML files and different relational sources like Oracle, DB2, and SQL Server.
Expertise in implementing performance-tuning techniques on Targets, Sources, Mappings & Sessions.
Experience with Type 1,Type 2,Type 3 Dimensions
Experience with Teradata as Target for the data marts. Worked with BTEQ, Fast Load, MultiLoad, Teradata pump, etc.
Proven expertise in analyzing the Business Intelligence needs of the enterprise and building the enterprise Reporting architecture.
Experience with slowly changing dimension methodology and slowly growing targets methodologies.
Have good problem solving, time management skills, communication skills, good organizational skills, self-motivated, hard working, ability to work independently or cooperatively in a team and eager to learn.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Unix, XHTML, Shell Scripting, Perl Script

RDBMS: Oracle 11g/10g/9i, Teradata, DB2, MS SQL Server 2000/2005, MS Access, MS Excel

ETL Data Integration Tools: Informatica Power Center / Power Mart 9.x/8.x/7.x/6.x (Designer, Workflow Manager, Work flow Monitor, Repository Manager, Repository Server Administration Console), Power Connect for ERP and Mainframes, Power Exchange, Datastage.

Operating Systems: Windows Server 2003, Windows 2000, Windows NT 4.0, Windows 98/2000/XP/2007. DOS.

IDE: Toad, SQL*Loader, SQL Server Management Studio, Teradata SQL Assistant, Quest Central for DB2, ChangeMan Version Manager, Eclipse, Visual Studio, Dreamweaver, Apache Directory Studio, Erwin 4.5/4.0.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship