Job Description :
Tasks included but not limited to are:
§ Design and creation of programs for application in Oracle, Data warehouse and OLTP database using SQL, PL/SQL
§ Expertise with packages, procedures, function, triggers, Oracle objects, ETL, SQL with Unix shell scripts and Data modeling
§ Code various ETL and SQL processes.
§ Create/modify Stored Procedures
§ Handle performance tuning and optimization, including partitioning, indexing schemes, table compression, etc.
§ Participate in design and analysis sessions with technical leads/Delivery managers to ensure sound team decision-making, and come up with the best appropriate solutions.
§ Maintain data integrity with associated audits
§ Create data loads
§ Maintain data
Required competencies
5+ years of experience as PL SQL Developer.
Familiarity of Teradata preferred.
Experience in handling very large Data Warehouse applications.
Experience with complex stored procedures used for ETL, DQ and validation.
Experience leveraging all database features
Experience collaborating and standardizing on design and development processes
Experience documenting required changes
Excellent oral and written communications skills.
BS or MS degree in Computer Science or equivalent work experience.