Steneral Consulting

We need: A senior Oracle Data Modeler/PL/SQL Developer with experience in PL/SQL programming, Hands on experience in performance tuning Oracle database and SQL and understanding of ETL tools (Data Stage and IICS Informatica preferred) and business intelligence reporting, with some exposure to Cognos and PowerBI.. Must be proficient in OLTP/3NF (Online transaction processing, 3rd normal form) as well as dimensional/data mart modeling (star schema, snowflake) – Minimum of 5 years. Experiences in Data modeling in Snowflake Database, Oracle Database, and in Salesforce. Complete understanding of ETL tools (Data Stage and IICS Informatica preferred) and business intelligence reporting, with some exposure to Cognos and PowerBI.. Some experiences in Snowflake database administration Job involves, profiling, creating, advising and reviewing data models for our data warehouse atomic as well as data mart areas.

sql developer

<ul><li>We need: A senior Oracle Data Modeler/PL/SQL Developer with experience in PL/SQL programming, Hands on experience in performance tuning Oracle database and SQL and understanding of ETL tools (Data Stage and IICS Informatica preferred) and business intelligence reporting, with some exposure to Cognos and PowerBI. **Candidates must have Long Projects/Good Tenure, Excellent communication skills and a State issued ID (Not Bills) showing they are Local. </li></ul>Candidates must be LOCAL to the NEW YORK or NEW JERSEY or TROY, MI area and COMMUTE into the office THREE TIMES A WEEK. NO RELOCATION CONSIDERED. Provide Qualifying Answers 1. How many years working with: Oracle Data Modeling <ul><li> How many years working with: PL/SQL programming</li><li> How many years working with: Hands on experience in performance tuning Oracle database and SQL</li><li> How many years working with: ETL </li></ul>Job Description Data Modeler Some basic skillset requirements we are looking for… <ul><li> Must be proficient in Oracle and SQL coding (with recent experience) – Minimum of 5 years</li><li> Must be proficient in OLTP/3NF (Online transaction processing, 3rd normal form) as well as dimensional/data mart modeling (star schema, snowflake) – Minimum of 5 years</li><li> Must be proficient in data analysis and SQL skills – Minimum of 5 years</li><li> Experience with SDLC / Scaled agile delivery frameworks for data warehouse projects – minimum of 7 years</li><li> PL/SQL programming of at least 2 years is preferred.</li><li> Experiences in Data modeling in Snowflake Database, Oracle Database, and in Salesforce</li><li> Good communication skills</li><li> Complete understanding of ETL tools (Data Stage and IICS Informatica preferred) and business intelligence reporting, with some exposure to Cognos and PowerBI.</li><li> Hands on experience in performance tuning Oracle database and SQL.</li><li> Some experiences in Snowflake database administration Job involves, profiling, creating, advising and reviewing data models for our data warehouse atomic as well as data mart areas. Should be able to provide design of the table structures with proper data analysis and mapping capabilities. Will be responsible to change, maintain the data models and be able to work closely with the business team to understand the requirements and provide guidance on the design to the development team. Should be able to assist both developers and testers to ensure that data processing is accurate, efficient and complete. Should be able to prioritize work activities to meet the timelines.</li></ul>

START NEW SEARCH