Job Description :
Greetings From Canopy one Solutions
Hope you’re Doing great
We have the below requirement , Hence please glance the requirement and respond us back with your finest Consultant / Updated Resume ASAP
Note : H1b’s accepted only with Passport number and Client ID
Job Title: PL/SQL - Netezza Consultant
Job Location: Knoxville, TN
Job Duration: 6+months

Skill matrix :
Mandatory Skills Skill Proficiency
Years of Experience Basic Knowledge Medium Expert
Netezza 6 Expert
SQL 6 Expert
AWS 2 Basic

Job Description :
Responsible for design decisions for the enterprise data warehouse model supporting business intelligence (BI) reporting requests
Create detailed ETL specifications supporting all the EDW/Data Lake modeling Review and provide oversight of code and data content results with Data Engineers/Developers
Participate in the development and implementation of BI standards processes and tools
Provide technical expertise to guide and educate BI report developers in designing queries
Integrate master data management to streamline data sharing, enhance business processes and enrich data available to all systems and processes
Act as the focal point for understanding data from the corporate perspective and presenting the data in a manner that can be understood uniformly throughout PFJ
Support multiple projects in building new data sets and data structures as needed by the business
Teach new design techniques optimized for BI data structures to the project level ETL Developers
Mentor junior team members
Ensure all activities are in compliance with rules, regulations, polices, and procedures Complete other duties as assigned
Ability to work independently with no to minimal supervision
Strong communication skills
Apply domain Knowledge of Retail Data Warehousing while designing dimensional models
Familiarity with JIRA and Confluence is a plus

Technical skills:
Must have knowledge of Netezza, Strong SQL skills mandatory
Redshift on AWS knowledge is a big plus
DataStage knowledge preferred
Knowledge of Dimensional modeling, star schema, snowflake
Basic SQL server /T-SQL knowledge
Basic Python scripting
Basic understanding of AWS cloud terminologies , handling json, web service apis etc