Hello,
We are looking for *Cognos Developer* with one of our direct client. REQUIREMENT NO: 1 *Cognos Developer* *Location: Columbus, OH* *Duration: 12+ Months* *Face to face interview* Please send me the resumes at nav...@dsiginc.com or you can reach me at 614-344-4600 ext 114 DOH is looking for TWO Programmer 3/PR3 for a 1208-hour assignment Extensions are likely, but budget is set and initial duration is limited to 402 hours for the time being. Onsite interviews are highly preferred, and local candidates available to interview onsite will be considered first. Utilize the bid comment section to explain each candidate's situation!!! A PO at DOH can take 3+ weeks to generate, please set this expectation with candidates prior to submitting! Thank you. Please see attached job description, by scrolling down to the "Attachments" Section of the posting for further details regarding this role *Description of Duties: * 20% of Total Work Effort: Requires 4-7 years' experience as a Business Intelligence/Cognos Developer and/or in combination with Database Analyst experience or other equivalent work experience. 20% of Total Work Effort: Framework Manager modeling (required), Report Studio (required), and Transformer (preferred) 20% of Total Work Effort: Strong SQL experience 20% of Total Work Effort: Strong Cube/analytical Data Model design expertise. 20% of Total Work Effort: Snowflake and Star Schema design The Cognos Developer is responsible for gathering requirements, designing, developing, and delivering high-quality output and proactive involvement in the successful delivery of BI systems; through coordination within the rest of the technology department and the business owners. The Cognos Developer is responsible for data profiling of new source systems, data modeling in Framework Manager, and report development in Report Studio. The Cognos Developer will create custom reporting tables (such as fact and dimension) using SQL in order to adequately support BI/reporting needs of the organization. Has thorough knowledge of data warehousing and Cognos tools. The Resource must have a good understanding of the business needs and the technical capabilities and be able to help align the BI solutions to meet the business growth objectives. *Must have:* • Strong understanding and ability in working with the Cognos Business Intelligence technical stack, including Framework Manager modeling and Report Studio (4-7 years of experience) • SQL, T-SQL, PL/SQL techniques • Data warehousing concepts • DataMart design decisions in order to provide the best possible Cognos Metadata solutions • Data profiling and data modeling experience • Experience creating custom reporting tables using SQL (such as fact and dimension tables) REQUIREMENT NO: 2 *SSIS ETL Developer* *6+Mothns* *Columbus,Ohio* *In person interview (only Locals)* Please send me the resumes at nav...@dsiginc.com or you can reach me at 614-344-4600 ext 114 Description of Duties: 25% of Total Work Effort: Requires 5-7 years’ experience as an SSIS ETL Developer working in Microsoft SQL Server 25% of Total Work Effort: Knowledge of administration of SQL Server for transactional and analysis systems 25% of Total Work Effort: Strong cube/analytical data model design expertise (preferred) 25% of Total Work Effort: Snowflake and Star Schema design The *SSIS ETL Developer* is responsible for designing, developing, and delivering high-quality output and proactive involvement in the successful delivery of BI systems; through coordination within the rest of the technology department and the business owners. The SSIS ETL Developer is responsible for data profiling of new source systems, designing custom reporting tables (such as fact and dimension), and using SSIS to create ETL packages to fully support reporting solutions in Cognos. Has thorough knowledge of data warehousing and ETL (SSIS required). The Resource must have a good understanding of the business needs and the technical capabilities and be able to help align the BI solutions to meet the business growth objectives. *Must have:* • 5-7 years of experience as an SSIS ETL developer • Data profiling and data modeling experience • Strong in data warehousing concepts and techniques • SQL, T-SQL, PL/SQL techniques • Experience creating custom reporting tables using SQL (such as fact, dimension, aggregate, slowly-changing dimension) • Snowflake and Star Schema design • Effective verbal and written communications skills and effective presentation skills • Self-motivator, independent, cooperative, flexible, creative *Preferred:* • Strong OLAP/cube/analytical data model design expertise • Cognos experience *MINIMUM REQUIREMENTS * • Bachelor’s degree in Computer Sciences or Computer Engineering or associated discipline or the equivalent experience. • Microsoft Certified Solutions Developer (MCSD) certification is a plus • Knowledge of administration of SQL Server for transactional and analysis systems • Strong cube/analytical data model design expertise (preferred) • Specific knowledge of Software Deployment Requirements for BI/DW Projects (preferred). • Effective verbal and written communications skills and effective presentation skills. • Self-motivator, independent, cooperative, flexible, creative. *Essential Duties and Responsibilities* • Designs, develops and monitors Enterprise Transformation Language (ETL) processes using SSIS • Performs data profiling, ETL development and administration, and release management • Data modeling using modeling tools and methodologies • Gathering, documenting, and designing data requirements • Strong quantitative and analytical skills with accuracy and attention to detail • Ability to work well independently with minimal supervision, manage multiple priorities, and remain flexible in a dynamically changing environment. • Establishes and implements standards and strategies for data management, lifecycle, and quality • Defines and implements best practices and standards for the data modeling processes. • Creates and maintains the logical and physical data models for the production and Business Intelligence Data Warehouse and Data Marts. • Collaborates in data design walkthroughs to communicate Data Warehouse and Data Mart table designs to the development team. • Develops prototype views and works with business users both internal and external to refine their requirements. • Demonstrates self-reliance in researching technical solutions and product functionality. • Continuously improves existing approaches by seeking opportunity to creatively transform current business practices into fresh alternative solutions. • Monitors production support issues and develops corrective solutions. • Conducts performance tuning of existing data structures. *Data Profiling* We currently are pulling data from a few source systems and are gathering requirements for dozens of new dashboards, each from at least one (and maybe more) source systems. Each dashboard project will require data profiling, ETL, and report development work. On some projects, the ETL developer will take on the data profiling responsibilities in addition to the actually ETL work itself. This involves working with the business analyst, end-user, report developer, and maybe the technical subject matter expert. The Resource must have strong experience creating reporting tables. The reporting tables created will contain the business logic required for the reports, so that the calculations are performed during ETL. There will be reporting tables created for each dashboard project. The ETL Resource needs to have strong SQL skills in order to optimize the table builds, in addition to reviewing and optimizing the SQL code of other developers. *ETL Development* Create ETL packages and jobs to pull data from source system and also create reporting tables (such as fact and dimension). Resource must have experience with data warehousing techniques, including aggregates and slowly changing dimensions. Create new ETL jobs and tune existing ETL jobs. Review code from other data modelers and make recommendations for changes in order to improve performance. Create indexes for tables which are being pulled in as needed. *Administration* Administer ETL system by setting-up new data sources, monitor performance of ETL jobs and resolve all issues, communicate any issues to team and business users, implement practices to mitigate issues, and work with DBAs as needed to investigate any data source connection issues. Schedule ETL jobs to run at optimal times as to not interfere with live operational data, yet pull the most current data. Set-up notification emails to monitor success or failure of ETL jobs. Communicate status of ETL jobs to team and mentor other developers on how to resolve issues. Monitor ETL sequence and make changes as needed. Mid-day data refresh as needed in Development and Production environments. Coordinate Cognos read access to Data Warehouse data sources. *Monitor Growth* The data housed in our data warehouse will be growing exponentially, and in a short time frame. This Resource will be responsible for tracking the growth rate and keeping the team and management updated on any hardware changes and recommendation so that our systems can handle our growth. *Release Management* Selected Resource will learn and follow our release management process. This includes identifying the schedule in which the deployment needs to occur (standard release, non-standard release, or emergency release). The ETL Resource will be responsible for identifying the database rollback process for each database deployment. -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-projects+unsubscr...@googlegroups.com. To post to this group, send email to oracle-projects@googlegroups.com. Visit this group at https://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.
