Cohesion, located in Cincinnati Ohio, has an opening for an ETL Developer - Computer Programmer/Datastage Specialist in the Cincinnati-Middletown OH-KY-IN regional area.

Analyze, design, build, test and implement extracts, transforms and loads (i.e. the facilitation of data movement across platforms) utilizing Stored Procedures or an ETL Tool. Consult and advise Cohesion's clients in the development and maintenance of computer data operating systems.

REQUIREMENTS

• Dynamic, professional, team-oriented, self-motivated individual; Master's degree required in Electrical Engineering, Computer Programming or related field
• 2 years ETL development experience
• Experience with DB2 UDB and Utilities
• Experience with IBM Data Stage is preferred but may consider Informatica experience
• Experience with multi-platform environments and languages including Cobol, OS/390, NT, AIX and Korn Shell scripting language
• Strong understanding of Data Warehouse Concepts, including star schemas
• Proficient in SQL
• Strong analytical, communication and organizational skills
• Ability to work on multiple assignments
• Able to trouble shoot, debug and problem solve at the highest level
• Ability and desire to mentor others
• Experience in Stored Procedures or an ETL Tool across multiple platforms

PREFERRED SKILLS

• Experience in OLAP and Reporting Tool Technologies a plus.
• Experience with use of a Reporting Tool (Actuate) and OLAP Technologies (Hyperion) a plus

An equal opportunity/affirmative action employer, M/F/D/VW

Close

• 5+ years of experience managing complex projects with a focus on the SDLC.
• Develops project schedules, work assignments, target dates and other aspects of assigned projects.
• Assist with the inception of a project including definition and exploration phases, responsible for complex cross-functional projects, ensuring project goals and requirements are met on time and within budget.
• Advanced knowledge of project metrics, including gathering, reporting, trend analysis, creation, and metrics.
• Ability to identify issues and problems, generate solutions and choose appropriate alternatives using basic root cause analysis.
• Facilitates project team meetings, manages agendas and meeting recaps to ensure all project tasks and goals are being accomplished as expected.
• Manages resource allocation and evaluates multiple project interdependencies.
• Ensures that the project complies with IT Project Life Cycle methodology.
• Prepares and presents proposals, tracks budget, status reports, and other information to senior management, sponsors, and stake-holders, as well as end-users.
• Delegates assignments to other staff members as appropriate.
• Follows PMI methodology, or similar formal Project Management methodology, preferably PMP Certified.
• Experience managing projects using Waterfall and Agile methodologies.
• Strong/Expert knowledge with MS Project and or Server.

Close

• Works as a team member creating project plans, delivering the business vision and maintaining team cadence and velocity.
• Responsible for enabling / facilitating team success and effectively communicating outside the room to both Agile and non-Agile audiences leveraging both metrics and soft skills.
• 2+ years of proven success working with Agile teams across multiple releases.
• Experienced leading application development efforts
Strong preference experience in custom application delivery.
• Performs as a “Leader” more so than a Manager, Able to work as a member of a self organized team.
• Experienced with Scrum/XP/FDD/Lean approaches as well as BDD/TDD/End-to-End Concepts.
• Has maintained continuous advancement of the Agile process through Retrospectives and team/business feedback.
• Experienced inspecting all aspects of an Agile effort, including Release Planning, Velocity Forecasting/Tracking, Backlog Management, and Big Visible Charts (BVC).

Close

• 3+ years of years of experience as a Business Analyst supporting IT applications.
• Functions as the liaison between the business line, operations, and the technical areas throughout the project cycle.
• Gathers requirements from customers and end users, identifies system enhancements, documents business needs and determines development impact to current system processing.
• Work as liaison between business units and the technical teams to establish requirements transfer and communicate that information efficiently between each group.
• Act as a liaison for the project team, document/translate functional specifications into technical requirements.
• Participate in the testing efforts to verify requirements have been met, and responsible for User Acceptance Testing (UAT).
• Responsible for the delivery of business requirements utilizing standard templates, tools and processes.
• Bachelor’s degree and or advanced degree preferred.
• Strong understanding of Lean, Six Sigma, or ITIL process methodologies. Certifications preferred.
• Proficient with Microsoft Project, Visio, Word, and Excel.

Close

• 3+ years of experience in a manual and or automated testing environment.
• Responsible for system and regression testing of all software developed by development teams including but not limited to: black box, white box testing, and smoke testing, UAT, unit testing, and load testing.
• Develop manual and automated test scripts from scratch using tools such as HP Quality Center/QTP, LoadRunner, Performance Center, Selenium, Silk, Fitnesse, exc.
• Execution of test plans and development of test cases using the playback and record function within test execution.
• Reviews User Requirements, User Interface Specifications and Design Documents, Test Plan and Procedure Documentation along with preparing a Test Strategy.
• Obtain and maintain test data and metrics, review issue reports, and create specifications for test/data environments.
• Works with developers to influence designs to improve performance and reliability and assist in developing complex load testing strategies – a plus.
• Coordinate with other groups within development and operations to ensure any custom software operates with existing company and business unit standards as appropriate.
• Knowledge of scripting languages such as VBScript, SQL, Perl, or UNIX.
• Strong working knowledge of quality assurance methodologies such as Agile, RUP, Waterfall, or SCRUM.
• Bachelor's degree preferred and Scrum Master Certification a plus.

Close

• 5+ years of development experience, working with the SDLC, building new applications from scratch as well as enhancing existing code.
• Designing N-tiered applications, with multi-tier architecture, and strong OO development experience.
• Ability to develop across all layers of the application, using languages such as C#.NET, ASP.NET, VB.NET, SQL Server 2005/2008/2010, Silverlight, HTML/XHTML, JavaScript, CSS, and XML.
• Strong relational database experience, ability to write complex stored procedures and reports using SQL Server/SSRS, Oracle, Cognos, or Crystal Reports.
• Ability to document technical specifications including database design, application design and ongoing documentation of changes and modifications.
• Knowledge of scripting languages such as VBScript, SQL, Perl, or UNIX.
• Strong working knowledge of SDLC methodologies such as Agile, Waterfall, Rapid Application Development (RAD), SCRUM or Rational Unified Process (RUP).
• Ability to communicate well with all levels of the business.
• Bachelor’s degree or advanced degree preferred. Microsoft Certifications a plus.

Close

• Experience with Java/J2EE web applications, development within the SDLC.
• Experience designing multi-tier architecture, and strong OO development experience, and knowledge of Web Services and SOA.
• Ability to develop across all layers of the application, using languages such as Java, J2EE, Spring Framework, Hibernate, JSF, and JSP, and XML
.
• Responsible for development, design, testing, and debugging document and maintaining existing applications.
• Strong database design and data modeling skills with databases such as Oracle, SQL, and DB2, Websphere. Ability to create and execute SQL queries, joins, and develop reports using Crystal or Cognos reporting tools.
• Works within a team to help define system scope, objectives through research and fact-finding to develop or modify moderately complex systems.
• Prepares detailed design specifications from which programs will be written.
• Contributes to the development of project plans, documents and defines business objectives, and works with all levels of the business. Project Management or Project Lead skills a plus.
• Ability to focus on complex projects and demonstrate technical leadership with offshore development teams – a plus.
• Expertise with development of high level designs, code reviews, and ensure code standards are met – a plus.
• Strong working knowledge of SDLC methodologies such as Agile, Waterfall, Rapid Application Development (RAD), SCRUM or Rational Unified Process (RUP).
• Bachelor’s degree or advanced degree preferred.

Close