Looking for someone who has at least 3-5 years of recent hands on experience with both Cognos and Informatica. Experience in Informatica needs to be very strong.
Review existing Business Requirements with business and technical staff. Define development tasks and timelines, define required interactions with other project areas, and work with the Project to integrate tasks into the project plan. Develop dashboards, reports and /or cubes using the various tools within the Cognos Series 8.4/10 Suite. Experience with Business Insight Advance, and Life Cycle is a plus. Must demonstrate the ability to analyze and implement solutions for existing or proposed Cognos applications and to provide written and verbal communication such as status reports, progress reports and application documentation to Information Technology partners. Design, develop and deliver project solutions to specified requirements on schedule following appropriate IT methodologies. Define and execute technical unit test cases. Analyze application performance levels, work with other project areas to define strategies and Client improvements. Troubleshoot and debug software issues. Work with business and technical team members to identify and define issues. Follow an existing quality assurance process. Flexibly interact with globally dispersed project team members.
Responsible for the design, development and implementation of ETL solutions using Informatica PowerCenter. Design and implementation of Systems Automation Processes. Develop complex database queries to produce expected result sets. Oracle database performance optimization. Repository Creation, Maintenance, Groups, users creation, Metadata Maintenance. Application monitoring, performance tuning, capacity planning and problem resolution. Unix shell scripting to support pre/post session activities. Documenting standards and procedures.
BA/BS in Computer Science or equivalent experience
Experience with SDLC and CSV processes is highly desirable. 4 years experience in designing and developing business intelligence solutions, with at least 3 years involving Cognos 8.x and above. Cognos 10 experience is preferred. Strong experience in creating OLAP (Online Analytical Processing) cubes using Transformer. Strong experience in creating Framework models. Hands on experience in creating complex drill through reports. Excellent database architecture and design skills, with three or more years of experience using Oracle 11 and DB2. Experience with modeling customer and sales data is preferred. Knowledge of various data related functions such as data integration, data modeling, metadata management, data replication and ETL, business intelligence, data cleansing, and profiling is desired. Unix shell scripting.
Cognos Development Tools
Cognos Change Management & Security
Windows Server and OS .NET Development
Deep expertise with Report Studio and framework manager are essential.
Bachelors degree in Computer Science or equivalent.
8+ years software Systems Analysis, Systems Design, Documentation, Development, Testing and Implementation experience. 4+ years Data Warehousing ETL experience using Informatica. 4+ years Unix shell scripting experience. 4+ SQL, PL/SQL, Procedures/Functions, Triggers and Packages. Excellent design concepts for dimensional data modelling, Star/Snowflake schema creation, fact and dimension table definition.
ETL, Informatica 9.0, PL/SQL, Oracle, DB2, MS SQL Server
Automotive industry experience. 5yrs experience with the following: Oracle, DB2, MS SQL Server, PL/SQL, stored procedures, Linux SUSE 10/11, Scripting, Data Warehousing Best Practices. Experience with Metadata Manager a plus.
Intermediate Word, Excel and Outlook skills required
Thanks & kind regards,
Phone: 703-349-1759|Alt: 703-372-0342| Fax 202-478-0885 | E-mail: firstname.lastname@example.org
10565 Fairfax Blvd # 301, Fairfax, VA 22030 | Multivision Inc.
National Certified Minority Supplier (MBE)
Multivision Inc., is a global Professional IT Services Company having presence in three countries recording an astounding 200% growth for the past three years. Multivision expertise embraces a broad range of technologies, domains and service offerings. We have about 300+ employees on our payroll. We are ranked 23rd in the Top 100 fastest-growing businesses in Washington-Arlington-Alexandria-DC-VA-MD-WV and also 33rd in the Top 100 fastest-growing IT Services Company in USA.