IIT Jobs Database - Data Modeler: DDL scripts, Data Conversion Strategy Plan, SQL, Oracle, DML Job Opening in Albany NY

	IIT Jobs Data Bank-Job Detail
Submit Resume For This Job (via email)
Follow us on LinkedIn or Twitter or Facebook

ID	Location	Skills	$$	Job Type	Status
9763	Albany, NY 12226	Data Modeler: DDL scripts, Data Conversion Strategy Plan, SQL, Oracle, DML	DOE	Contract	OPEN
If you are unable to click on links above to submit resume, you may email your resume to *jobs@iit-inc.com* *Subject=*IIT Career Site/Resume for JobID=9763 (Data Modeler: DDL scripts, Data Conversion Strategy Plan, SQL, Oracle, DML) in Albany NY 12226 (AMI)
Estimated Length: 24 months Full-Time 8am – 5pm *In-Person Interview Mandatory Requirements Expert 84+ Months Desired Requirements 84 Months of Experience designing and developing logical and physical data models, and creating DDL and DML scripts for tables, indexes, triggers, synonyms and sequences. 84 months of Experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, Gap Analysis, Data Auditing and designing Canonical Data Models. 84 Months of Experience writing complex SQL against an enterprise Oracle and MySQL databases, and creating database objects such as views, materialized views, packages, stored procedures. 84 Months of Experience working with the tools like TOAD, SQL Developer*, Export/Import, SQL Loader, TKProf, Explain Plan. 84 Months of Experience in star and snowflake schemas for effective reporting; and designing, developing and maintaining reports in Crystal Reports or Cognos, 72 months experience using Oracle Data Integrator and Oracle WebLogic Server. 72 months of experience using programming languages such as SQL, PL/SQL, PERL, Shell scripting. 60 Months of experience performance tuning complex SQL against an enterprise Oracle database. 24 Months of Experience designing and developing logical and physical data models and creating scripts for Oracle Service Cloud version 2012-current (Formally known as RightNow https://cloud.oracle.com/en_US/opc/service-cloud) Responsibilities Continue to build and maintain a data architecture based on the requirement. Design and develop Logical and Physical Data Model. Create DDL scripts to establish and maintain a database. Write complex SQL queries against an enterprise Oracle database. Create DML scripts to manipulate data. Work with project managers, solution architects, business analysts, application development teams and QA to ensure the quality of DDL and DML scripts. Performance tuning SQL to improve efficiency. Working with NYS Agency representatives to develop data conversion specifications and understand Agency business rules. Provide guidance and hands-on development for developing and maintaining reports in Crystal Reports or Cognos. Create clear and accurate documentation on data models, design for reports, and description of data usage in the application process flow.

Submit Resume For This Job (via email)

Don't See a Position Matching Your Skills? Click here to Email / Register your resume and be notified of future job openings.

About IIT:
Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include: Consulting for projects / IT Outsourcing IT staffing (Contract / Temporary / Contingent / Consulting) Custom Workforce Solutions Recruitment Process Outsourcing (RPO) Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include Winner of Inc-500 award 2 consecutive years Winner of Ernst & Young / USPAACC Fast-50 award 2 consecutive years Winner of USPAACC Top-10 Award in the Northeast US IBM Business Partner Oracle Business Partner Adobe Business Partner NYSA Member - New York Staffing Association - Regional Affiliate of ASA / American Staffing Association NYS MBE certified Our Consultants love working for IIT Competitive compensation W2 or C2C Biweekly Direct Deposit for W2 Consultants Visa and Green Card sponsorship opportunities for qualified individuals Local contact for you to meet and talk to anytime (not someone sitting overseas in a different time zone) Follow us on LinkedIn or Twitter or Facebook IIT is an Equal Opportunity Employer