Cognos/ ETL Developer, IL

• 2 years of experience in analysis, design, development and implementation of scalable and reliable Data warehousing applications using Informatica, Cognos, Oracle, SQL Server. Excellent communication and analytical skills. • Experience with Cognos Tools such as Cognos 8.6, Cognos 10. • 2 years of experience in using Informatica Power Center (8.6.1/9.1) • Proficiency in developing SQL with various relational databases like Oracle9i, SQL Server, DB2. • Knowledge in Full Life Cycle development of Data Warehousing. • Have extensively worked in developing ETL methodologies for supporting Data Extraction, transformations and loading using Informatica Power Center. • Extensively worked on Data Cleansing, Data Profiling, Data Quality using Informatica Products • Have extensively worked with Informatica Power Center to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using Source Qualifiers, Expressions, Normalizers, Routers, connected/unconnected Lookups/procedures, Update strategies, Mapplets and Slowly Changing Dimensions. • Experience with dimensional modeling using Star Schema and Snowflake Schema Models. • Developed OLAP applications using Cognos 8.6, Cognos 10 BI - (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio and PowerPlay Studio, PowerPlay Transformer) and extracted data from the enterprise data warehouse to support the analytical and reporting for Corporate Business Units. • Generated Business reports using Cognos 10 as a reporting tool as and when required. • Experience in conceptual, logical and physical data models using ERWIN (4.5). • Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks. • Extensive experience in writing SQL and PL/SQL programs Stored procedures, Triggers, Functions for back end development. • Proven ability to work effectively in both independent and team situations with positive results. • Excellent analytical, problem solving, and communication

Application Support

Bloomington, IL