Dataware house consultant

Job Description

Datawarehouse consultant

Location: New York, United States

This is a Hybrid role. Resource has to go to office 2 to 3 days a week in New York.

Responsibilities
• Understand requirements relating to change needs of business and design solution accordingly.
• Code development and/or changes as per the business requirements.
• Perform testing of code changes for change function and regression.
• Follow the required policies and procedures for the incident, problem and change management
• Ensure service performance expectations are met with service levels and quality
• Raise/escalate any service related issues and risks to track lead and/or BCI lead
• Good understanding of SDLC lifecycle.
• Must have experience in application development and testing using Unix & Sybase/Oracle PL/SQL.
• Oracle is mandatory i.e. Advance PL/SQL programming through Oracle 12g, Sybase is a plus.
• PL/SQL performance tuning and optimization on Oracle 12g + and Sybase.
• Shell scripting is mandatory i.e. Good level of knowledge and experience in Unix scripting.
• L3 Support for Unix/DB applications
• Must have experience in Perl and Object Oriented Perl language.
• Ability to work directly with business clients to translate requirements into technical solutions.
• Must have strong trouble shooting and analytical skills.
• Excellent communication skills (verbal and written).
• Strong desire to understand functional aspects of applications.
• High energy, results driven person with strong interpersonal skills.
• Able to work under minimal supervision.

Qualifications
Minimum qualifications
Graduate or post graduate in Engineering or Technology with Computers or IT stream
OR
Graduate or post graduate in any stream with course in Computers or IT stream
Preferred Skills:
• Working experience in applications related to accounting & financial reporting or Credit Risk in banking environment.
• Configuration Management, Build and Deployment.
• Conceptual understanding of data warehouse design / modeling approaches.
• Knowledge of Control-M or other scheduling application
• Meet defined SLAs and KPIs related to application development and support
• Improvements and optimizations to stabilize the plant