Previous Job
Data Analyst
Ref No.: 18-03833
Location: Cincinnati, Ohio
Position Type:Direct Placement
Timesheet Submission Frequency:Weekly
Invoice submission frequency:Monthly
Timesheet Instructions for Consultants:Time/Expenses are to be entered on Kaygen s JobDiva Portal
KAYGEN is an emerging leader in providing top talent for techCincinnati, OH
FTE – Visa independent only
Around $100K
Essential Functions and Job Responsibilities
The successful candidate will work with senior developers and a cross-functional team to ensure maintenance and support of critical data warehouse environments as well as develop enhancement solutions that address all customer priorities, including performance, functionality, ease of use, and security considerations.
Duties and responsibilities will include, but are not limited to
 Involvement in SDLC which includes gathering of business requirements, architecture, design document, planning, development, deployment and maintenance of Care     Coordination Technology Infrastructure.
Gathering and analyzing the business and technical requirements. Create Functional Specification Document
Provide PLSQL development in Oracle 11g12c environment
 Responsible for data mapping, metadata maintenance and enhancing existing Logical and Physical data models.
Create tables, views, sequences, indexes, constraints and generated SQL scripts for physical implementation using SAP Power Designer.
Reverse Engineering of database schemas into SAP Power designer Physical Data Model for reusability and then forward engineered them to Oracle using SAP Power designer.
Develop source to target mapping documents to support ETL design and development.
Integrate data from various back-end services and databases.
Develop queries, troubleshoot issues, and perform bug fixes.
Perform technical reviews of customer requirements, analyze source data, and perform gap analysis.
Conduct acceptance testing, load testing, troubleshooting, and performance tuning as required.
Create and maintain documentation for the design and development processes.
Should have an excellent knowledge and experience to implement the Data warehousing concepts.

Minimum Requirements
 At least 5 years of PLSQL, Data warehouse development experience.
Bachelors degree in computer science, information technology, or other equivalent engineering or technical discipline and at least 5 years of related experience.
 Strong technical background with complete understanding of data warehouse modeling, architectures, OLAP, OLTP datasets etc.
Experience with data visualization, data warehouse and BI concepts.
 Strong knowledge of data gathering using Structured Query Language SQL.
Proficient in the use of Microsoft Office Suite of tools.
Broad understanding of information technologies, their uses and applications.
Strong knowledge in conceptual, logical and or physical data modeling, including technical infrastructure.
 Strong knowledge and working experience with Oracle PLSQL packages, procedures, coding.
Self-starter who can work under general direction in a highly collaborative, team-based environment.
Proficient in translating business requirements to technical specifications.
Excellent written and verbal communication skills.

nology based staffing services. We specialize in providing high-volume contingent staffing, direct hire staffing and project based solutions to companies worldwide ranging from startups to Fortune 500 and Managed Service Providers (MSP) across a wide variety of industries

Insert Full Job Description.

- No client name
-No confidential info
-no sensitive details

At KAYGEN, we are always looking for dynamic, talented and experienced individuals. We invite you to join our team of talented IT professionals, consulting at client locations across the globe. Our culture is team-orientated; we strive to stand by our core values of respect, honesty and integrity. Our team of experienced staffing experts will work with you to find you the best opportunity. For more information please visit us at