W2 - Programmer Analyst 3 (Design & review of logical & physical data model in SQL, PL/SQL) - Hybrid
Description:
The client is looking for:
Programmer Analyst 3 Interview Process:
Virtual Interview via MS Teams or on-site.
For virtual, please use laptop and be prepared so share screen if asked.
Use of headphones is strongly discouraged.
A screenshot photo of candidate will be required for any Teams interviews as well as a vendor present at beginning of interview to validate candidate.
Top Skills & Years of
Experience:
8
years designing and review of logical and physical data model in SQL and/or PL/SQL 6
years of hands-on relational, dimensional, and/or analytic experience 6
years of experience in writing SQL packages/functions/Triggers and Mass data updates and deletes.
3
year of experience in query optimization and performance tuning.
3
years of experience in data conversion between multiple systems and experience in data transformation strategies.
Duration:
1 year with possible extension.
Remote or On-site:
Will need to be onsite starting day 1 for hybrid work schedule.
NO REMOTE ONLY OPTION.
The hiring manager is only interested in candidates who are currently local (within a commutable distance of no more than 1.
5 hours) and will NOT be reviewing resumes for candidates who need to relocate to accept offer.
Provide technical guidance to the application development team, which includes designing, developing, and supporting complex applications.
The resource will be involved in collaborating with the business area to ensure the technical design of the application meets the business requirements.
The resource will provide technical guidance to the other developers in the department.
The programmer will also participate in a variety of analytical assignments for the enhancement, integration, maintenance, and implementation of projects and preparing technology roadmap for the supported applications.
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 guidance to the application development team.
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 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.
Skills:
8
years designing and review of logical and physical data model in SQL and/or PL/SQL 6
years of hands-on relational, dimensional, and/or analytic experience 6
years of experience in writing SQL packages/functions/Triggers and and Mass data updates and deletes.
3
year of experience in query optimization and performance tuning.
3
years of experience in data conversion between multiple systems and experience in data transformation strategies.
Pay range - $40 to $45 per hour on W2.
W2 - Programmer Analyst 3 (Design & review of logical & physical data model in SQL, PL/SQL) - Hybrid Recommended Skills Agile Methodology Analytical Business Requirements Data Conversion Data Modeling Database Design Estimated Salary: $20 to $28 per hour based on qualifications.
The client is looking for:
Programmer Analyst 3 Interview Process:
Virtual Interview via MS Teams or on-site.
For virtual, please use laptop and be prepared so share screen if asked.
Use of headphones is strongly discouraged.
A screenshot photo of candidate will be required for any Teams interviews as well as a vendor present at beginning of interview to validate candidate.
Top Skills & Years of
Experience:
8
years designing and review of logical and physical data model in SQL and/or PL/SQL 6
years of hands-on relational, dimensional, and/or analytic experience 6
years of experience in writing SQL packages/functions/Triggers and Mass data updates and deletes.
3
year of experience in query optimization and performance tuning.
3
years of experience in data conversion between multiple systems and experience in data transformation strategies.
Duration:
1 year with possible extension.
Remote or On-site:
Will need to be onsite starting day 1 for hybrid work schedule.
NO REMOTE ONLY OPTION.
The hiring manager is only interested in candidates who are currently local (within a commutable distance of no more than 1.
5 hours) and will NOT be reviewing resumes for candidates who need to relocate to accept offer.
Provide technical guidance to the application development team, which includes designing, developing, and supporting complex applications.
The resource will be involved in collaborating with the business area to ensure the technical design of the application meets the business requirements.
The resource will provide technical guidance to the other developers in the department.
The programmer will also participate in a variety of analytical assignments for the enhancement, integration, maintenance, and implementation of projects and preparing technology roadmap for the supported applications.
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 guidance to the application development team.
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 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.
Skills:
8
years designing and review of logical and physical data model in SQL and/or PL/SQL 6
years of hands-on relational, dimensional, and/or analytic experience 6
years of experience in writing SQL packages/functions/Triggers and and Mass data updates and deletes.
3
year of experience in query optimization and performance tuning.
3
years of experience in data conversion between multiple systems and experience in data transformation strategies.
Pay range - $40 to $45 per hour on W2.
W2 - Programmer Analyst 3 (Design & review of logical & physical data model in SQL, PL/SQL) - Hybrid Recommended Skills Agile Methodology Analytical Business Requirements Data Conversion Data Modeling Database Design Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
