Developer - Newport Beach, United States - Tata Consultancy Services

Description

Skill: PL/SQL and Informatica Developer

Key Responsibilities:

• Provide technical assistance, problem resolution and troubleshooting support.
• Provide time estimates and complete tasks in Agile development environment.
• Produce and maintain well-documented code.
• Issue tracking, analysis and reporting, perform code reviews, unit testing.
• Hands-on experience in software development.
• Oncall production support.

• Strong Hands on development experience using Oracle PL/SQL.
• Intermediate Hands on development experience and good Knowledge of using the informatica Tool.
• Experience in Data Warehousing, Data Warehouse models like Star Schema.
• Knowledge and experience of ETL tools, SQL loader, Materialized Views for incremental updates.
• Experience with Oracle Version 10g, 11g, 12c.
• Programming - Develop, design, test and implement complex database programs using Oracle sql developer and third party tools.
• Strong experience with oracle functions, procedures, triggers, packages & performance tuning.
• Experience in database migration projects.
• DevOps tools like GIT/SVN.
• Ability to work with business and technology users to elicit requirements and refine mapping documents.
• Very good analytical and debugging skills.
• Knowledge of Unix and shell scripting.

• Data modelling (logical & Physical).
• Experience with financial/investment data.
• Flexible work timings (mainly support PST hours).
• Excellent Communication Skills to work with Business Partners.
• Participate in day-to-day aspects of a formal Agile/Scrum process, including contributing to Agile meetings (backlog, planning, review, retrospectives, and daily stand-ups).Experience with ITSM tools like Service-Now.