![]() ![]() Reporting Tools: Business Objects, Cognos, Crystal Reportsĭatabases: Oracle 11g/10g/8i/9i,SQL Server 2000/2005/2008, DB2,MS Access 7., Teradata V2R6,Sybase.ĭB Tools: Toad, SQL*plus, SQL Developer, iSQL*plus, SQL*Loader, TD SQL Assistant 13.10, DB Artisan ![]() Languages: C, C++, SQL and PL/SQL, Teradata SQL, T-SQL,Perl,Unix shell scripting.ĮTL Tools: Informatica Power Center 9.x/8.x/7.x/6.x/5.x,Informatica Power Exchange 8.1, Power Mart, Power connect, Power Analyzer.ĭata Modeling: Dimensional Data Modelling, Star Schema and Snowflake Schema, Erwin, Power Analyzer. OS: Windows/XP, Windows NT 4.0, UNIX, MS DOS Excellent analytical and logical programming skills with a good understanding at conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.Experience in coordinating with cross functional teams and project management.Strong experience in Tuning both ETL and Database Objects for better performance.Documentation on Detailed Technical Design, Migration process, Test cases and ETL Run Book.Worked with different scheduling tools like Control-M, Autosys.Experience in UNIX shell scripting and automation of jobs.Proficient in the Integration of various data sources like Oracle, SQL Server, DB2, Teradata, Ms-Access, COBOL, Mainframe, Excel, XML, VSAM files and Flat Files.Expertise in coding, testing and implementation of SQL Queries and PL/SQL Objects like triggers, stored procedures, functions, packages.Knowledge in Database architecture for OLAP and OLTP applications to model the snowflake and star schema’s and report delivery methodologies.Expertise in design and implementation of SCD - slowly changing dimensions types (1, 2 and 3), CDC - Change data capture.Knowledge in Data warehousing tools like Power Exchange,Power Analyzer,Informatica Data Quality(IDQ) and Informatica Data Explorer(IDE).Profound knowledge in complete life cycle development of Data Warehouse: Data Analysis, Design, Development, Implementation and Testing using Data Extraction, Transformation and Loading (ETL).Strong understanding in Mortgage, Insurance, Finance, Healthcare and Telecom/Wireless domains.Around 8 years of IT experience in software analysis, development and implementation of ETL applications using Informatica 9.x/8.x/7.x/6.x/5.x. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |