Sr. ETL Developer DBA 7 views

Millennium Technologies Current Looking for a Sr ETL Developer Consultant in the D.C area 100% Remote for Now, some in person meeting my needed for time to time.

Job Description

Looking for a Sr. ETL Developer with a least 10 year experience able to get clearance.

Collaborate on Dataset Design
i. Understand the requirements and develop the appropriate documentation as needed
to ensure a common understanding
b. Creation of ETL Processes for New Data Sources
i. Once DMD management provides the data sources, review all new data feeds and
applicable documentation for completeness and accuracy.
ii. Coordinate with DMD and the applicable source system contacts to resolve any
questions, issues, or concerns.
iii. Be prepared for data sets can be in a variety of formats such as various
databases, Excel, and other formats
iv. Develop the necessary scripts for the extraction, transformation, and loading
(ETL) of new data sources into the Compliance Data Warehouse (CDW) Sybase
stage data environment or other locations as needed
v. Coordinate with DMD to understand the CDW standard guidelines and ensure that
ETL processes and resulting datasets meet these guidelines
vi. Ensure that all processes will follow best practices to ensure efficient and
effective loading of large datasets into the CDW environment.

c. Complete Recurring Data ETL Processes
i. Establish the ETL process frequency based upon the Governments needs and
monitor them to ensure they are performing as expected
ii. Once the ETL processes are complete, review, analyze, and synthesize the data
loads to eliminate duplication, formatting errors and ensure other anomalies are
resolved to increase quality for data analytics
iii. Ensure high quality and trustworthy data as a variety of users will be accessing
data sets and potentially integrating them with other data sets based upon their
needs

d. Enhancing the processes and quality of data sets as part of continuous improvement tasks to
ensure high-quality data in the CDW
i. Identify and track risks and open actions that could impact CDW customers or
stakeholders and develop strategies for resolving them
ii. Present the risks, open actions, and strategies to the DMD personnel for joint
discussion and approval prior to implementation
iii. Document processes and changes consistent with IRS guidelines.
iv. Collaborate with other database administrators that may be Federal employees
or other contractor teams by attending biweekly Data Working Group meetings.

Requirements

Key Priorities of the Job:
The key activities that you perform regularly must be completed at the highest level of performance to
meet the expectations of your direct supervisor/company leadership.
1. Report to the Project Manager.
2. Ensure that the projects being managed are healthy and maintain high client satisfaction.
3. Ensure that 95% of all assigned actions are completed by the due date.
4. Maintain 100% scheduled utilization on billable projects.

Key Technology for the Job:
Key proficiency with the technology that is required to perform and be successful in this position.
1. Sybase Database
2. Oracle Database
3. MS SQL Server
4. PostGres Database
5. EFTU Electronic File Transfer Utility
6. Secure CRT Terminal
7. Secure FX Terminal
8. ETL (Informatica PowerCenter)
9. SQL
10. UNIX / LINUX

How To Apply

How candidate can apply for your job. You can leave your contact, please include your linkedin URL