Vacancy expired!
Software Guidance & Assistance, Inc., (SGA), is searching for an ETL Production Support Engineer for a Full-Time assignment with one of our premier Insurance Services clients in A Remote Role ideally west coast or central time to cover batches during the evening. Weekend support rotation will be required. Our team is looking for a data driven person who has supported critical applications and is experienced in ETL, data warehousing and setting up data pipelines across the enterprise. This professional will need to interface with the Investments business and IT management, providing them with data solutions, timely and accurate status updates, short-term / long-term plans, release plans, etc. in a clear consistent manner that emphasizes performance metrics, strategic planning, continuous improvement and adherence to industry best practices. The candidate will display technical and functional competence in data management standards. Responsibilities :
- Monitor and evaluate daily production activities and priorities to meet service level agreements and mitigate operational risks
- Manage production support responsibilities, including after hours, weekend, and remote support, as well as on-site when necessary
- Evaluate performance and effectiveness of current operations and identify opportunities for improvement
- Develop and maintain operational procedures documentation
- Provide Front and Back office customer service and support
- Coordinate technology weekend validation of IT shared services patches, upgrade and hardware changes
- Develop and maintain data pipelines and build out new integrations to support continuing increases in data volume and complexity
- Implement processes and systems to monitor data quality, ensuring production data accuracy and assist in data analysis to troubleshoot and resolve data issues
- Work with relational/non-relational databases and understanding of storage technologies like SQL Server. Work with DBA and other staff as necessary, to instantiate physical databases based on the models.
- Interface with business units, internal IT, customers, and management in the performance of duties
- Provide 24X7 support as needed (Ort)
- 5+ years of strong SQL, PL/SQL, SQL Server, and stored procedures experience
- In-depth experience working with enterprise scheduler BMC Control-M.
- Experience with Data Integration Informatica, SSIS, or related ETL tools
- UNIX Shell Scripting experience with Windows and Linux
- ETL concepts with Informatica or SSIS knowledge
- Data sourcing, data mapping and data analysis skills.
- Database skills creating and optimizing queries and data structure
- Significant experience interfacing with business end-users
- Excellent written and verbal communication skills.
- Creative problem-solving skills.
- Attention to detail and ability to work and learn independently as well as in a team environment required
- Ability to self-manage tasks to meet delivery targets.
- Relational database concepts; Strong experience data integration
- Strong RDBMS knowledge.
- Bachelor's Degree in Computer Science, Information Systems or related fields
- Experience with Investment or financial services domain knowledge a big plus!
- Python experience
Vacancy expired!