Sign in

PowerCenter

Company:
CareWorks Technologies
Location:
Columbus, Ohio, United States
Posted:
November 08, 2018

Description:

For more than 18 years, CareWorks Tech has been delivering technology solutions that drive results. As your advocate, the common thread across our associates is crafting the right tech-savvy solutions. Whether it’s IT Consulting, Infrastructure Services, Security, Enterprise Service Management or Interactive, we’re all about finding solutions that advance your career aspirations. Our ongoing client relationships speak to our long-term collaborative partnerships.

Position Description: We are looking for an experienced Informatica PowerCenter Developer. You will be responsible for planning, designing, configuring, developing, testing, deploying and supporting your code. Superior ability to communicate and collaborate within an Agile team environment is critically important. You must have a minimum of 5 years of overall ETL development experience and 3+ years of Informatica coding experience (PowerCenter). The ability to produce complicated queries (heavy optimization) and stored procedures is required as is advanced knowledge of Oracle and Unix scripting (Batch scheduling tool).

Responsibilities Include

Ability to successfully design, deploy and evolve ETL solutions to meet business requirements using Informatica 9.6 or higher

Experience working with a variety of protocols for file transfer and delivery

Strong written and oral communication skills with ability to interpret and understand technical requirements

Strong understanding of software design principles, algorithms, data structures, design patterns, and multithreading concepts.

Strong client-facing skills (communication, explanation, slideware, etc.)

Strong project/task management skills

Strong knowledge of software engineering and development methodologies, techniques, and tools, including Configuration Management (CVS), Issue Tracking (Jira), and Software Development Lifecycle (Agile)

Ability to validate design with business requirements to ensure completeness of the ETL solution

Experience with performance tuning Informatica mappings and sessions

Experience with performing Informatica upgrade, service pack installs, and administering Informatica environments

Experience building SQL queries, including creating sub-queries, minus/union, and inline queries

Develop and design data models and data processing and transformation rules for proper data representation

Must have proven ability to estimate development duration and effort

Must have knowledge of dimensional modeling including knowledge of slowly changing dimensions, historic data capture, error capturing and reporting

Must be able to troubleshoot problems and have knowledge of how to incorporate techniques for data auditing and quality

Must have knowledge of Master Data Management and Metadata Management

Must assist in the development of best practices and guidelines to ensure complete, accurate, and maintainable solutions

Must be able to work on multiple simultaneous timelines

You must be able to plan and manage deployment from Development to Staging to Deployment

The CareWorks Family of Companies is committed to providing career opportunity and growth to all Associates without regard to race, color, religion, sex, national origin, age, marital or veteran status, medical condition or disability.

CareWorks Tech Strategically-Led Technology Solutions

5555 Glendon, CT

Dublin, OH 43016

614-789-3767

david.horvay@careworkstech.com

Thank you for considering CareWorks Tech for your next career opportunity. CareWorks Tech is not your typical technology company. We are part of the CareWork’s family of companies which is one of Ohio’s largest managed care organizations, serving over 115,000 employers and owned by York Risk Services Group. We have 4 guiding principles: (1) Customer Commitment (2)Attitude of Service (3) Respect for the Individual and Team and (4) Exceeding Expectations. We invest in your training, professional development, benefits (medical, 401k, paid holidays/vacation, etc.) and personally focus on your career success. We have operations in 85 locations worldwide and employ 5,000+ people.