ETL Developer

Summary

Analytica is seeking a remote ETL Developer to support a federal government client. The ideal candidate has solid experience in ETL development, strong SQL skills, and knowledge of SAP Data Services. The role involves weekly data loading in a large Compliance Data Warehouse and the company offers competitive compensation with opportunities for bonuses, employer-paid health care, training and development funds, and 401k match.

Requirements

• Bachelor’s Degree in Computer Science, IT, Computer Engineering, or related field
• Strong SQL development experience, data modeling and database security
• Knowledge of /familiar with, Sap Data Services
• Experience using SQL tools
• Experience conducting ETL processes on large XML, flat files, and database table data sources
• Experience working in Unix and Linux

Responsibilities

• Support extract, transform, and load (ETL) processes for SAP/Sybase IQ database and support programs and processes to load update
• Create and maintain SQL scripts, stored procedures, and other program logic to create, update, and delete data
• Design and implement schema changes, manage indexes, and alter data objects to optimize performance
• Design efficient data models from a logical design based on business requirements and available use patterns
• Identify entity relationships, referential integrity constraints, and primary key structures. Perform analysis of tradeoffs between alternative schemas
• Create and maintain documentation that includes file specifications, schema, core record layouts, programs, business requirements, test plans, and other artifacts used in the administration, creation, and execution of database operations

Preferred Qualifications

Familiarity with tax and financial data a plus

Benefits

• Competitive compensation with opportunities for bonuses
• Employer-paid health care
• Training and development funds
• 401k match