VIVA USA Inc Big Data/ETL Lead Developer in Denver, Colorado
Req Ref No: AMCOBD10 Location: Denver, CO Duration: 12.0 months
Seeking an experienced and highly self-motivated Big Data/ETL Develop to support Reporting on various Medical related data (claims, member, provider, EMR etc) and Statistical Reporting. Hands on experience in Matillion ETL software is a must. In this role, you will design, develop, test, and implement ETL/ELT solutions in addition to developing complex queries to mine data from the Enterprise Data Warehouse and the Big Data Platform. You must excel at working independently as well leading scrum teams and show an appropriate sense of urgency, multi-task across multiple teams, all while providing production support. Job Responsibilities:
• Be part of a development team to build and maintain the ETL processes • Analyze the needs and the environment to make sure the solution you're developing considers the current architecture and operating environment as well as future functionality and enhancements • Develop, test, debug, document and help operationalize various ETL applications leveraging industry best practices • Work closely and collaborate with various cross functional IT teams to identify, troubleshoot and fix data issues, and resolve data gaps that impact the fulfillment of the business's functional requirements • Lead team members and customers to gather and validate requirements as well as deliver features/enhancements • Collaborate with other functions involving architects, team leads and team members to architect and design solutions to meet functional and technical requirements • Responsible for writing complex SQL queries for mining of operational data
Minimum 3-5 years of experience with traditional Relational Database Systems like Oracle, Microsft SQL, Stored Procedures and a must have experience with Snowflakes. Minimum 3 years of experience with AWS PaaS solutions especially AWS Glue, AWS S3, AWS SNS. Delivered at-least 2 to 3 end-to-end ETL solution using Matillion software. Minimum 3-5 years of experience with manipulating and transforming large and complicated datasets Experience with developing, tuning and debugging code, stored procedures, functions and packages. Strong functional and analytical skills. Minimum 2 years of experience in developing high volume transaction processing solutions Experience in Data Profiling
Hands-On experience on Metillion is a must. 2+ years of experience in designing and developing efficient and robust ETL/ELT workflows using tools such as Metillion, Informatica, Ab Initio, Talend or Apache Spark if above experience is not available. Work with large streams of data (>1TB.) in a large enterprise environment Experience in Linux/UNIX scripting and SQL Experience with Healthcare space Experience with TFS or GIT Experience with advanced Data Warehousing concepts and skills Experience with sourcing data across multiple platforms including Salesforce, FTP, Data Warehouse, ESB) Experience with JSON and XML Experience with Agile methodologies and developing Project Artifacts Experience with Application Systems and Data Analysis
VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status.