Data Warehouse Consultant Resume

SUMMARY

More TEMPthan 8 years of IT experience and wide range of experience in software development, Data Integration, Data Warehousing and Oracle Development.
Experience working wif different stakeholders including business analysts, data architects, report developers, QA testing and production teams.
Strong experience in Extraction, transformation and loading (ETL) of data from various data sources into data warehouses and data marts using Informatica Power center tools - designer, workflow manager and workflow monitor.
Experience in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to apply business logics and to move data from multiple sources into targets.
Extensively worked on development of various ETL mappings in Informatica designer to load teh data from various source systems into teh Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Router, Java, Lookup, Sequence Generator, Filter, and Sorter.
Experience in developing XML/XSD/XSLT as a part of Source XML files for Informatica
Experience working in different phases of Data Warehouse Life Cycle including source system analysis, ETL design/development, project deployment, production support
Experience in using HP Quality center for defect tracking and defect reporting.
Experience testing ETLInformaticamappings and other ETL Processes (Data Warehouse Testing)
Strong ability to analyze source systems and business requirements, identify and document business rules.
Extensive knowledge of Dimensional Data Modeling like Star schema and snowflake schema.
Very strong knowledge of Entity-relationship concept, facts and dimension tables and slowly changing dimensions.
Experience working wif high volume data sets from various sources like Oracle, SQL server, XML files and flat files.
Experience implementing slowly changing dimensions according to business requirements.
Experience in writing Oracle PL/SQL Stored Procedures/Functions/Packages and cursors Triggers.
SQL Tuning and creation of indexes for faster database access, better query performance in Informaticaby creating Explain Plan, SQL hints for query and indexing teh required columns.
Expertise in UNIX Shell Scripting and also automation of ETL processes using UNIX shell scripting.
Experience working wif Autosys for scheduling teh workflows.
Knowledge in developing reports using Business Intelligence tools like Business Objects.
Experience working wif cross - functional departments.
Experience working in an onsite-offshore structure and TEMPeffectively coordinating tasks between onsite and offshore teams.
Experience working as a liaison between teh business users and IT team.
A highly motivated self-starter and a good team-player wif excellent verbal and written communication skills including experience in presentation skills.
Excellent analytical and logical skills wif a good understanding at teh conceptual level and possess strong interpersonal skills.

TECHNICAL SKILLS

Tools: TOAD, SQL *Plus, SQL *Loader, Informatica Power Center 9.1/9.5, FileZilla

Data Modeling: Physical Modeling, Logical Modeling, Relational Modeling, Dimensional Modeling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes, Cardinality, ER Diagrams, Erwin Data Modeller

Databases: Oracle 11g/12c

Languages: SQL, PL/SQL, Unix Shell Scripting

Web Technologies: HTML, XML, Java Script

Tools: SQL Plus, PL/SQL Developer, Toad, SQL* Loader, Putty, Telnet

Operating Systems: UNIX (Sun Solaris, AIX), Linux and Windows 7/XP.

Schedulers: Autosys, Control M

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship