netPolarity, Inc. (Saicon Consultants, Inc.) · 1 day ago
Data warehouse/ Data-Mart Solution Engineer (PL/SQL, T-SQL, ETL Informatica)
San Jose, CA
Contract
Onsite
Senior Level, Lead/Staff
8+ years expnetPolarity, Inc. is seeking a Senior Data Warehouse/Data-Mart Solution Engineer to support backend development and enhancements for dashboards across various business teams. The role requires strong SQL and PL/SQL development skills, focusing on creating DataMart solutions and data pipelines.
DeliveryHuman ResourcesInformation TechnologyStaffing Agency
Hiring Manager
Sachin Naik
Responsibilities
Need a senior candidate - majorly supporting the back end development / Bug Fixes / enhancements for the dashboards for various business teams
Looking for someone in strong sql expr , heavy in pl/sql development/ solutions; analytical skills, code in a way modular code used many ways - (need a solutions cater to these requirements dimensions fact and aggregate the data)
Very good in Data warehousing background- creating DataMart solutions - required good warehousing concepts - solid in the backend side to creating these data solutions / Pipelines
Create single source /data layers; structures for 1 or 2 tables, exiting data source and how the data is being used/reporting
Create new query to build a dashboard for Business active customers
Do pull requests and deploying code to different environments
If they have design backend layer function like product; he/she should understand and kpi’s the revolve around where the data sources come from pull that data for the tableau users to utilise
ETL field will have a good understanding - More interested in people who have etl developer, sql developer, data warehouse - experience in the area of creating pipeline, creating data warehousing vs dashboards/requirement gathering/business analytics - would consider
Experience in Dimensional Modeling, Star and Snowflake Schemas design and maintaining dimensions using Slowly Changing Dimensions(SCD)
Tableau should be able to open it up and review it - at least in dashboarding (using tableau-to make changes)
Scripting is a plus like airflow, fronttab but to understand how these scripts work
8 to 12 year of experience; working in agile team; less ramp up time should be to collaborate and contribute
Qualification
Required
Need a senior candidate - majorly supporting the back end development / Bug Fixes / enhancements for the dashboards for various business teams
Looking for someone in strong sql expr, heavy in pl/sql development/ solutions; analytical skills, code in a way modular code used many ways - (need a solutions cater to these requirements dimensions fact and aggregate the data)
Very good in Data warehousing background- creating DataMart solutions - required good warehousing concepts - solid in the backend side to creating these data solutions / Pipelines
Create single source /data layers; structures for 1 or 2 tables, exiting data source and how the data is being used/reporting
Create new query to build a dashboard for Business active customers
Do pull requests and deploying code to different environments
If they have design backend layer function like product; he/she should understand and kpi's the revolve around where the data sources come from pull that data for the tableau users to utilise
ETL field will have a good understanding - More interested in people who have etl developer, sql developer, data warehouse - experience in the area of creating pipeline, creating data warehousing vs dashboards/requirement gathering/business analytics - would consider
Experience in Dimensional Modeling, Star and Snowflake Schemas design and maintaining dimensions using Slowly Changing Dimensions(SCD)
Tableau should be able to open it up and review it - at least in dashboarding (using tableau-to make changes)
8 to 12 year of experience; working in agile team; less ramp up time should be to collaborate and contribute
Preferred
Scripting is a plus like airflow, fronttab but to understand how these scripts work
Company
netPolarity, Inc. (Saicon Consultants, Inc.)
netPolarity, a subsidiary of Saicon, is a certified Woman and Minority-Owned Business Enterprise, a leading full-service workforce solutions provider delivering contingent workforce staffing, payrolling, temp-to-hire and direct-hire services to Fortune 500 companies nationwide.
201-500 employees
H1B Sponsorship
netPolarity, Inc. (Saicon Consultants, Inc.) has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2021 (2)
2020 (1)
Funding
Current Stage
Growth StageLeadership Team
Haixia Zhang
Chief Executive Officer
Company data provided by crunchbase