ETL Developers

ETL Developer

Location:

Woodlawn, MD Primary Responsibilities:

Design and develop Extract, Transform, and Load (ETL) processes to support MI/BI

efforts, with strong knowledge of data warehousing concepts. Develop advanced and complex ETL pipelines and custom shell/Python scripting. Design, develop, and maintain Tableau dashboards and data visualizations to support

business intelligence and management reporting needs; connect Tableau to enterprise

data sources including Greenplum/PostgreSQL, DB2, SQL

Server, and Oracle. Perform data mapping and source-to-target analysis across multiple data sources

including DB2, Oracle, Greenplum, and flat files. Read, debug, modify, and create complex SQL code associated with a data warehouse

environment. Load and integrate data from multiple source systems into Greenplum MPP database;

apply expert knowledge of data distribution, table partitioning, and compression

strategies. Design, develop, test, and optimize ETL solutions for processing large volumes of data;

implement efficient migration processes to move ETL objects across development, test,

and production environments. Translate business requirements into technical specifications; collaborate with Business

Analysts, Data Architects, Enterprise Architects, and ETL Architects to ensure solutions

meet requirements. Identify and promote reuse of ETL components and services to avoid duplicative

implementations and reduce technical debt. Work with configuration management to maintain software versions using Bitbucket/Git;

prepare and deploy software packages per SSA change management standards. Prepare and maintain comprehensive technical documentation; deliver knowledge

transfer sessions to SSA staff as needed. Ensure compliance with SSA security, privacy, and data management policies

throughout all development activities. Mentor junior team members in developing, documenting, and modifying ETL

components and best practices. Participate in all design reviews, requirement sessions, and team problem-solving

efforts; communicate technical concepts effectively to both technical and non-technical

stakeholders.

Minimum Qualifications:

Bachelor s degree in Computer Science, Information Technology, or a related field with

10+ years of relevant ETL development experience. Additional years of relevant

experience may be accepted in lieu of degree. Linux/UNIX proficiency including Bash shell scripting and Linux OS administration in a

database and ETL context. Hands-on experience with ETL tools such as Informatica, Ab Initio, and

Syncsort/Precisely; proficiency with PSQL, file transfer protocols (FTP/SFTP), and

Bitbucket for version control. Experience scripting in a Linux environment to automate ETL solutions and data

migration jobs. Strong SQL proficiency across multiple platforms; experience with PL/pgSQL for

PostgreSQL and Greenplum environments, and PL/SQL for Oracle environments; ability

to select the appropriate approach based on platform and use case. Extensive experience with SQL mapping and integration across DB2, Oracle, and

Greenplum database platforms. Strong experience extracting data from multiple source systems including DB2, Oracle,

PostgreSQL, Greenplum, and flat files. Tableau dashboard development experience including connecting to enterprise data

sources, building calculated fields and parameters, designing interactive dashboards

and scorecards, and publishing workbooks to Tableau Server for BI/MI reporting. Full comprehension of SQL, cardinality, levels of granularity, normalized vs. de-

normalized data models, and data architecture best practices. Hands-on experience designing and developing ETL solutions involving large volumes of

data; experience with large-scale, complex data migration efforts. Strong understanding of data recovery and job rerun procedures in an ETL environment. Working knowledge of developing optimal code to maintain high performance when

processing large volumes of data. Strong attention to detail with excellent analytical, organizational, and troubleshooting

skills. Excellent written and verbal communication skills. Ability to obtain and maintain a Public Trust clearance (U.S. citizenship or lawful

permanent residence required).

Desired Qualifications:

Active Public Trust or higher-level security clearance. Prior experience supporting federal government clients, particularly SSA or other large

civilian agencies. Strong Database skills. Experience with Python scripting for ETL automation, data pipeline development, and

operational tasks. Familiarity with Agile/Scrum methodologies and DevSecOps practices in a federal IT

environment. Experience with Jira and Confluence. Knowledge of FISMA compliance requirements and experience working within an ATO

(Authority to Operate) framework. Tableau Desktop Specialist or Tableau Certified Data Analyst certification. Informatica AXON or Ab Initio professional certification.