Job Seekers, Please send resumes to resumes@hireitpeople.com

Position Summary:

 

Support new and existing development projects with data and process modeling activities. Provide entity, logical and physical data models;Perform database design across multiple platforms;Provide technical leadership to the application development teamDevelop software design documents and work with stakeholders for review and approval.Collaborate with stakeholder to ensure application architecture is in alignment with business requirementExcellent knowledge in designing both logical and physical database model in Oracle and SQL serverExperience preparing technology roadmap for supported applicationsExperience tuning SQL queries, scripts and troubleshoots issues using SQL, PL/SQL scriptsHands on experience Integrating software components into a fully functional software systemExperience developing, prototypes, mockup for users review and approval.Exposure to flowcharts, screen layouts and documentation to ensure logical flow of the system requirementsExperience working on large agile projects.Fine - tune data model to achieve consistent performanceGood knowledge of metadata management, data modeling, and related tools (Erwin or ER Studio or others) required.

 

 

Skill Descriptions:

 

12+ years designing and review of logical and physical data model in SQL and/or PL/SQL10+ years of hands-on relational, dimensional, and/or analytic experience10+ years of experience in writing SQL packages/functions/Triggers andand Mass data updates and deletes.8 + year of experience in query optimization and performance tuning.5+years of experience in data conversion between multiple systems and experience in data transformation strategies.

Experience required: 3-6 Years