Datawarehouse Designer - 4 Years of Experience - Near 75062


Datawarehouse Designer


Irving, TX

Education Level:


Will Relocate:



Summary: * 5 years of professional experience in Data Modeling and Data Analysis as a Proficient in gathering business requirements and handling requirements management. * Experienced in designing the Conceptual, Logical and Physical data modeling using ER win and ER Studio Data modeling tools. * Good in System analysis, ER Dimensional Modeling, Database design and implementing RDBMS specific features. * Experience in Developing Data Models For both OLTP/OLAP systems * Exposure to Both Kimball and Bill Inmon Data Warehousing Approaches * Experience in modeling OLTP and OLAP using tools like Erwin r9.6/9.1/r8/r7.1/7.2, Sybase Power designer 12.1 and E-R Studio. * Having Good Experience with Normalization (1NF, 2NF and 3NF) and De-normalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments. * Experience in Working Dimensional Data modeling, Star Schema/Snow flake schema, Fact & Dimensions Tables. * Experience in building reports using SQL Server Reporting Services and Crystal Reports * Experience in performing Reverse Engineering of Physical Data Models from data, SQL scripts. * Worked extensively on Forward Engineering processes. Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF, PDF format depending upon the requirement * Experience in Creating Partitions, Indexes, Indexed views to improve the performance, reduce contention and increase the availability of data. * Expert in writing SQL queries and optimizing the queries in Oracle 9i/10g/11g, SQL Server 2005/2008/2012/2014. * Extensive experience in development of Oracle PL/SQL Scripts, Stored Procedures and Triggers for business logic implementation. * Experienced in designing the Data Mart and creation of Cubes. * Experience in Data transformation, Data Mapping from source to target database schemas, Data Cleansing procedures * Performed extensive data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality. * Experience in Performance Tuning and query optimization techniques in transactional and Data Warehouse Environments. * Experience in using SSIS in solving complex business problems. * Significant Exposure to Talend Etl Tool.