What are the responsibilities and job description for the Senior ETL Developer position at Horizontal Talent?
Projects the candidate will be working on:
- This is to work on additional T&M hours approved with CA MIS/DSS Amendment 04.
- This position is for a Medi-Cal Data Warehouse project for State of California in Sacramento.
- The Senior ETL Developer will work on Work Authorization projects, including requirements, design, development, testing and implementation.
- Expert hands-on development experience in required skills.
- Strong ETL experience using IBM Datastage V7 or higher – 5 years
- Strong knowledge on Teradata architecture and loading utilities like TPT, TEQ, FLOAD and MLOAD – 2 years
- Strong SQL writing ability and data analysis skills – 2 years
- Responsible for analysis of source systems to determine required transformations.
- Writes the design and mapping specifications for ETL development.
- Identifies methods of improving performance in ETL design and development.
- Analyses customer requirements, improving performance on existing scripts /process/procedures, and document detailed user requirements and program functions.
- Monitors database performance, support application users, determine cost of database changes, and train team members on applications.
- Coordinates the work of others to develop, test, install, and modify programs and establish physical database parameters
- Bachelor’s Degree in Computer Science, Information technology (or related fields) from an accredited college or university or equivalent work experience.
- Strong ETL experience 5-6 years using IBM Datastage V7 or higher
- Strong knowledge on Teradata architecture and loading utilities like TPT, TEQ, FLOAD and MLOAD • Strong SQL writing ability and data analysis skills
- Unix commands and shell scripting
- Good understanding of IT fundamentals, architecture, and the system development life cycle.
- Ability to reason logically and creatively, and use a variety of analytical and research techniques to solve complex problems.
- Communicate effectively both verbally and in writing with a variety of audience types
- Knowledge of 837 and NCPDP HIPAA Transactions
- Experience using Erwin to design data models
- Knowledge of Healthcare with Medicaid or Public Health data
- Experience using XML with DataStage
- Experience reading, understanding and importing COBOL copybooks into InfoSphere DataStage
- Experience using QualityStage and Information Analyzer technologies.
- Automate, schedule and performance tuning of existing mappings/jobs.
- Experience in address profiling using QualityStage and obtain address coordinates using Geolocator.
Horizontal facilitates valuable and productive conversations between you and potential employers. We can assist you in growing your career by partnering you with employers that offer challenging assignments. For those that join the team, we offer competitive compensation and benefits including medical, dental, vision, and retirement. Check out all we have to offer and how you can become part of the Horizontal Talent Team. The pay range for this role is $65 - $76 per hour. This is not a guarantee of compensation, as final offer amount may vary based on factors including but not limited to experience and geographic location.
Location/Region: Sacramento, CA
Salary : $65 - $76
Senior Applications Developer (Enterprise Applications)
City of Sacramento -
Sacramento, CA
Senior Database Analyst/PowerBi Developer
WELLSPACE HEALTH -
Sacramento, CA
Senior Java Developer - 3Year with extension
Two95 International Inc. -
Sacramento, CA
