Job Description
Insight Global is seeking a ETL Production Support resource with strong Teradata and SQL knowledge. EDST (Enterprise Data Science Tech) Application Production Support personnel is responsible for running the day to day operations of the Enterprise Information / Data Science Products owned and operated by the Enterprise Data Science Technology team that are operated and maintained on enterprise Teradata/SASGRID platforms. Work activities specific to Production Services roles include Problem/Incident Management, Release/Deployment support, Operational Readiness, Capacity/Availability Management, Application Monitoring, Service Level Agreement (SLA) maintenance, Production Governance, Triage, Audit support etc.
Typically 5-8 years of experience
Monitor Application ETL and Analytics data load jobs on the enterprise platforms (Teradata/SASGRID) requiring knowledge of complex SQL and ETL programming
Provide on-call (rotational) support to handle production failure scenarios (Incident Management)
Monitor and ensure adherence to daily/weekly/monthly Service Level Agreements (SLA) for data sourcing, processing and provisioning timings
Serves as the first line of support to investigate and resolve data quality issues and escalate to L2/L3 Support Team when required
Follow communication and escalation routines to prevent and handle SLA breaches contacting upstream data source applications for data delays, data quality issues, create and send user bulletins for data provisioning delays / issues
Provide capacity management support (ensure enough space allocation on database/server directories)
Provide application availability support (bringing application to Business-as-Usual (BAU) by running jobs after a platform Outage)
Manage Incidents, Service requests, Problems Change using ITSM tools and methodologies.
Work closely with Technology Infrastructure and Development Teams in supporting Integrated / Independent release deployments, software/hardware upgrades, server upgrades and also participate in Disaster Recovery and Resiliency testing exercises
Communicates effectively with L2/L3 Support, Development and internal business operations teams serving as an escalation point between the client/business area and internal management for the resolution of moderately complex unresolved problems, complaints and service requests
Collaborate with offshore team members for efficient production support shift handoffs
Required Skills:
Computer Science/Software Engineering (or related) degree
5-8 years experience with application production support on Teradata data-warehouse and analytical platforms
Experience monitoring, analyzing and fixing ETL job failures for SQL-based ETL and analytic workflows using native utilities (Teradata bteq, tpt, fastexport)
Experience analyzing data incidents and issues, and resolve simple/moderate quality issues
Very good knowledge of Unix/Linux shell Scripting and scheduling (like Autosys)
Excellent written, proactive communication and diagramming skills
Strong analytical and problem solving abilities
Speaking / presentation skills in a professional setting
Excellent interpersonal skills and a team player to work all along with Global teams and business partners
Positive attitude and flexible
Willingness to learn new skills and adapt to changes
Required Skills & Experience
- 5+ years in ETL Production Support role
- Strong Teradata skills
- Strong SQL knowledge
- Unix/shell scripting (Autosys)
Nice to Have Skills & Experience
- Financial domain background
- SAS
- Previous development background
Benefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.