Job Information
PamTen, Inc. Data Engineer in United States
Job Description:
SQL Server DB developer: Experience in developing stored procedures, functions, triggers, indexes, and SQL querying skills.
Power BI and SSRS: Must have 2 years of recent work experience from an overall 7-10 years of total experience with some Power BI administering knowledge.
SSIS: Create and maintain new/existing packages defining ETL processes, connecting to multiple data types.
Troubleshooting : Strong debugging skills in all the above technologies.
Power Pivot: Support business users in fixing Excel spreadsheets for data analysis.
PowerShell scripting: Manage the existing scripts that interact with Power BI tenants.
SharePoint: Manage the existing reporting portal which is in SharePoint.
VBA: Understand and manage existing custom legacy reports/dashboards.
Mandatory skills,:
Strong in SQL skills (complex queries, overall SQL knowledge)
Strong in SSRS, PowerBI, Shell scripting. Hands on experience required.
SSIS – needed, if not someone who write Azure stack for ETL(some exp is good)
Should be working in Maintenance projects but completely hands on and work with customer for tickets.
Handson development for maintenance projects , Ability to fix tickets and issue the maintenance support.(small tickets for 40 hours)
Must have experience with end-to-end operations and can manage on his/her own (independent)
Must be good in requirement gathering skillset.
Must involve in an end-to-end DWH.
Working experience in Data warehouse L2, L3 type of production support engagements
Independently able to work with business users to understand changed required or understand issue or defect. Then work independently to resolve the issue.
Able to hand off some issues to India team and work with them for closure.
Report status back to customer lead daily and highlight, escalate when required without delay.