Manager Sql

Professional Summary

• Eight years and * months ( 8.3 ) years of focused experience in Information Technology with a strong background in Data warehousing and ETL process experience using Informatica PowerCenter 8.6/8.1.1/7.1.1.

• Exclusive Experience in Data Warehousing, Business Intelligence working with Informatica, Oracle 10g.

• Experience with relational data sources like Oracle, Teradata sources, Fixed Width and Delimited Flat Files and DB2.

• Extensively worked in ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.

• Experience in Performance tuning of targets, sources, mappings and sessions.

• Proficient in SQL, PL/ SQL Programming, and implementing business logic with stored procedures and triggers.

• Good understanding on Star schema and ER- models.

• Experienced in loader utilities including SQL Loader.

• Unix Shell scripting.

• Responsibilities include designing the documents which is based on the requirement specifications.

• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.

• Excellent Technical, Communication and Interpersonal Skills with strong Customer Orientation and Client Interfacing Skills.

Skills :

Databases and Utilities: Oracle 11g/10g/9i/8i/8.0, MS Access 7.0/97/2000, SQL*Plus,

SQL Server, , MS Access, DB2, SQL*Loader, TOAD, SQL

Navigator 7.x.

Data Modeling: Physical and Logical Data Modeling, Erwin 4.0/3.5.2/3.x,

PL/SQL Developer.

ETL: Informatica Power Center 8.6/7.1.1 (Source Analyzer, Data

Warehouse Designer, Mapping Designer,

Mapplet,Transformations, Workflow Manager, Workflow

Monitor, Worklets), Autosys.

Programming: SQL, PL/SQL, HTML, C, C++, UNIX Shell Scripting.

Contact this candidate