Company:
ICONMA, LLC
Location: Plano
Closing Date: 28/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
Description:
Ability to analyze, design and support implementation of Oracle PL/SQL, Views, create/modify database tables based on business requirements and specifications
Responsibilities
Responsible to develop/modify PL/SQL, SQL Views in Oracle
Responsible to create a new tables/modify existing table structure.
Performance tuning and good understanding of explain plan
Normalization, renormalization and star schema
Develops stored procedures, database triggers and SQL queries
Must be able to work independently with minimum supervision.
Responsible to develop test cases and perform unit testing.
Must be able to interact and co-ordinate with distributed team.
Responsible to provide regular task status update to the management
Strong in Oracle version 11.x above
ETL / Informatica
Experience in Procedures, Functions, Packages, views, Materialized Views, Indexes, Triggers, Constraints, Snapshots, Synonyms, Sequences, Database Links, Bulk collect, Forall, ref cursor, partition tables, Analytical functions, collections, objects and writing complex queries
Any version control tool (SVN/Bitbucket)
Informatica, Autosys
Unix Concepts
Experience on SDM Adoption / Horizon onboarding tools (Bit Bucket, Datical, Jenkins)
Agile best practices
As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.
Description:
Ability to analyze, design and support implementation of Oracle PL/SQL, Views, create/modify database tables based on business requirements and specifications
Responsibilities
Responsible to develop/modify PL/SQL, SQL Views in Oracle
Responsible to create a new tables/modify existing table structure.
Performance tuning and good understanding of explain plan
Normalization, renormalization and star schema
Develops stored procedures, database triggers and SQL queries
Must be able to work independently with minimum supervision.
Responsible to develop test cases and perform unit testing.
Must be able to interact and co-ordinate with distributed team.
Responsible to provide regular task status update to the management
Strong in Oracle version 11.x above
ETL / Informatica
Experience in Procedures, Functions, Packages, views, Materialized Views, Indexes, Triggers, Constraints, Snapshots, Synonyms, Sequences, Database Links, Bulk collect, Forall, ref cursor, partition tables, Analytical functions, collections, objects and writing complex queries
Any version control tool (SVN/Bitbucket)
Informatica, Autosys
Unix Concepts
Experience on SDM Adoption / Horizon onboarding tools (Bit Bucket, Datical, Jenkins)
Agile best practices
As an equal opportunity employer, ICONMA provides an employment environment that supports and encourages the abilities of all persons without regard to race, color, religion, gender, sexual orientation, gender identity or express, ethnicity, national origin, age, disability status, political affiliation, genetics, marital status, protected veteran status, or any other characteristic protected by federal, state, or local laws.
Share this job
Useful Links