ETL Technical Specialist
ETL Technical Specialist
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
The ETL Technical Specialist works with business and technical teams to provide ETL technical analysis support and expertise for the large scale Claims Journey to the Cloud data transformation program of on-premise applications to the Cloud. The ETL Specialist will primarily focus on the Data Analytics and AI workstream and additional support to the Data Transformation stream.
Duties include the gathering of data requirements creation of Conceptual architecture providing technical leadership in planning analysis building configuration testing and post implementation support for the Claims Journey Data Analytics & AI landscape.
The ETL Specialist will work with management to provide technical assistance advice and guidance to client staff and business clients in response to enquiries on the functionality of BI/ETL tools and data in Legacy Data warehouses and Azure Data Lake platform.
Resource Responsibilities
- Provide technical design developing and implementing ETL solutions
- Assist to create the Report Rationalization strategy to rebuild existing BI products for Claims Transformation program
- Assist to assess high-level scope and effort for ETL development work for Azure and Legacy Reporting systems
- Assist in the development of Conceptual Logical and Physical architecture and documentation for the Data Analytics and AI solution
- Support and feedback for data modeling (i.e. conceptual logical and physical model design experience with Operation Data Stores Enterprise Data warehouses and Data Marts).
- Translate client business systems requirements and associated functional designs into technical design documentation ensuring that the solution(s) satisfy all business requirements.
- Work with Analysts Administrators and Testing teams to support configurations code customizations code migrations and testing from Unit System Integration User Acceptance and performance.
- Participate in technical sessions to prototype new system functionality.
- Participate in workshops with project teams to explain and gain consensus on the solution(s) to be developed.
- Work with systems analysts to ensure the solution meets the approved solution design.
- Perform code reviews to identify potential issues.
- Perform unit testing and troubleshoot coding issues.
- Provide support during systems integration testing.
- Provide knowledge transfer and create/update technical documentation.
- Provide coordination in release and change management processes
- Provide technical design developing and implementing ETL solutions
- Enforce Clients standards for ETL best practices
Requirements
Knowledge & Skills
MUST HAVE:
- 2 Years of experience in designing developing testing and implementing Extract/Transform/load (ETL) data pipelines with Azure data technologies such as Azure Data Factory Databricks Azure Synapse
- 5 years experience in data modeling and working with common data warehouse Models
- 5 years experience doing analysis and developing with SQL (e.g. Oracle MS SQL DB2) and PySpark.
- 5 years experience working IBM Datastage ETL tools or other industry leading ETL tools like Informatica or SAP BODS
- 5 year experience working with accepted methods standards techniques and best practices for development in agile/scrum practices
- Oral communication skills to work effectively with and discuss development approaches to clients/senior management and external stakeholders; written communications skills to document and communicate development specifications
NICE TO HAVE:
- Experience working with Guidewire Insurance suite applications (ie. Claims Center Policy center Billing center Contact Manager)
- Experience in working with Predictive Analytics and AI
- Experience working with MS PowerBI report/dashboards or Cognos reports
- Experience working with high volume data exchange and transaction processing systems Experience writing well documented unit tests and executing them
- Good knowledge of popular data standards and formats (e.g JSON XML Proto Parquet Avro ORC)
- Experience of reverse-engineering data mappings based on application-layer code highly desirable Ability to express complex technical concepts effectively both verbally and in writing
- Strong understanding of SDLC and Agile Methodologies
- Degree in computer science math engineering or equivalent work experience Excellent Communication Skills
Employment Type
Full Time
