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 team
- Develop software design documents and work with stakeholders for review and approval.
- Collaborate with stakeholder to ensure application architecture is in alignment with business requirement
- Excellent knowledge in designing both logical and physical database model in Oracle and SQL server
- Experience preparing technology roadmap for supported applications
- Experience tuning SQL queries, scripts and troubleshoots issues using SQL, PL/SQL scripts
- Hands on experience Integrating software components into a fully functional software system
- Experience developing, prototypes, mockup for users review and approval.
- Exposure to flowcharts, screen layouts and documentation to ensure logical flow of the system requirements
- Experience working on large agile projects.
- Fine - tune data model to achieve consistent performance
- Good 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/SQL
- 10+ years of hands-on relational, dimensional, and/or analytic experience
- 10+ 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: 12-15 Years
