Senior ETL Developer

$145,600 - $156,000/Yr

Randstad - Bethesda, MD

Full-time - Mid Level

Remote - Bethesda, MD

10,001+ employees

Administrative and Support Services

About the position

Our client is seeking a Senior ETL Developer to support a federal government client. The ideal candidate is able to work in a consultative approach with clients, has solid experience in ETL development, and the ability to lead other developers on the team. The Senior ETL Developer will be loading data on a weekly basis in a large Compliance Data Warehouse. This contract position is 100% remote, allowing for flexibility while working on critical data processes. The role requires a strong understanding of ETL processes, particularly with SAP/Sybase IQ databases, and the ability to create and maintain SQL scripts, stored procedures, and other program logic to manage data effectively. In this position, the Senior ETL Developer will be responsible for designing and implementing schema changes, managing indexes, and altering data objects to optimize performance. The developer will also design efficient data models based on business requirements and available use patterns, ensuring that entity relationships, referential integrity constraints, and primary key structures are well-defined. Additionally, the role involves creating and maintaining comprehensive 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. This position is crucial for ensuring the integrity and performance of the data warehouse, and the successful candidate will play a key role in leading the team towards achieving these goals.

Responsibilities

• Support extract, transform, and load (ETL) processes for SAP/Sybase IQ database and support programs and processes to load updates.
• 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.

Requirements

• Bachelor's Degree in Computer Science, IT, Computer Engineering, or related field.
• Experience as a Senior ETL Developer, with experience leading a team or leading a project.
• In-depth SQL development experience, data modeling, data warehousing, database security and developing data model schemas.
• In-depth database knowledge - SQL and NoSQL; understanding of database design & database architecture.
• Comprehensive knowledge on data modeling and data visualization skills.
• Working experience of data stores and distributed systems like Hadoop (HDFS).
• Programming experience using Python and SQL.
• Experience with Bash and Shell scripting, and the ability to map data to tables.
• Experience in data warehousing and ETL (Extract Transform Load) tools.
• Knowledge of/familiar with, SAP Data Services.
• Experience conducting ETL processes on large XML, flat files, and database table data sources.
• Experience working in Unix and Linux.
• Familiarity with tax and financial data a plus.

Nice-to-haves

• Familiarity with tax and financial data.

Benefits

• Comprehensive benefits package including health insurance.
• Incentive and recognition program.
• 401K contribution (based on eligibility).