US Citizen
Green Card
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 18th May 2024
Responsible for developing and delivering complex software requirements to accomplish business goals. Ensures that software is developed to meet functional, non-functional, and compliance requirements.
As part of the PTS/R technology team providing services to internal clients the duties and responsibilities include but are not limited to:
• Serve as a fully seasoned/proficient technical resource. Will not have direct reports, however may provide technical leadership on projects and direct activities of a team related to projects.
• May collaborate with external programmers to coordinate delivery of software application.
• Routine accountability is for technical knowledge and capabilities.
• Work with minimal supervision, with general guidance from more seasoned team members.
• Drive process improvements and innovation
• Interpret business requirements into design solutions and understand design and development of project lifecycle
• Design the conceptual and physical data model
• Adapts best Database design and coding standards, Database coding, Code Unit Testing and Component Integration Testing.
• Creation and maintenance of system, functional and reference documentation.
• Provide support during testing phases as required, analysis and recommend bug fixes for production incidents, Performance tuning
• Report root cause of the incidents and present ideas on how to prevent the incidents from occurring in future
Primary Skill
Oracle SQL / PLSQL
Secondary Skill
Informatica
Tertiary Skill
Microstrategy
Required Skills
OS
• Linux
• Windows 7
RDBMS
• Oracle (Oracle 11g or higher) - 7 years must
• PL/SQL, Stored Procedure/Package development
• Query Tuning and Optimization
• Data Analysis
• Strong Communication Skills
Desired Skills
OS
• Hadoop
RDBMS
• SQLServer 2012-2014 experience - 3 years nice to have
• Teradata/Neteeza - 1 year nice to have
ETL development - 5 years (any of the tools below)
• SSIS
• Informatica
• DataStage
• Data Integrator