btaadam.blogg.se - Toad data modeler foreign key naming

Strong experience working with conceptual, logical and physical data modeling considering Meta data standards.

Worked extensively on XML data and XSD schema designing.Experience working with Agile and Waterfall data modeling methodologies.Experience in Ralph Kimball and Bill Inmon approaches.Extensive experience analyzing and documenting business requirements and system functional specifications including use cases facilitated and participated in Joint Application Development JAD sessions, white board sessions to resolve the revolving issues and facilitated the coordination between the teams.Worked with various RDBMS like Oracle, SQL Server, DB2 UDB, and Teradata.Extensive experience in development of T-SQL, Oracle PL/SQL Scripts, Stored Procedures and Triggers and Packages for business logic implementation.Experience in Data transformation and Data mapping from source to target database schemas and also data cleansing.Experience in SQL and good knowledge in PLSQL programming and developed Stored Procedures and Triggers.Experience in performance analysis and created partitions, indexes and Aggregate tables where necessary.Experienced in Data loading using PL/SQL Scripts and SQL Server Integration Services packages SSIS.Experience with DBA tasks involving database creation, performance tuning, creation of indexes, creating and modifying table spaces for optimization purposes.

Performed extensive Data profiling and analysis for detecting and correcting inaccurate data from the databases and to track data quality.

Having very Good exposure to ETL tool like Informatica.