ETL Developer; In Person and US - GC​/Citizenship

ETL Developer (In Person and US - GC /Citizenship Required )

This role is for an ETL Developer with a contract length of over 6 months, offering a pay rate of $85.00 - $90.00 per hour. Key skills include ETL development, SQL proficiency, Tableau dashboard creation, and Linux/UNIX expertise. U.S. citizenship required.

Location:

United States.

• Jira
• Bit Bucket
• GIT
• Tableau Desktop
• Ab Initio
• Greenplum
• Oracle
• Data Analysis
• BI (Business Intelligence)
• Data Architecture
• Linux
• Data Warehouse
• ETL (Extract #Transform #Load)
• Shell Scripting
• Agile
• Computer Science
• Informatica
• Data Pipeline
• Python
• Unix
• Automation
• Visualization
• Security
• Data Mapping
• Compliance
• Dev Sec Ops
• Scrum
• Bash
• Data Management
• PostgreSQL
• Documentation
• Tableau Server
• Scripting
• SQL (Structured Query Language)
• Migration
• Version Control
• Tableau
• Data Migration
• SQL Server
• Business Analysis
• Axon

Primary Responsibilities:

Design and develop Extract, Transform, and Load (ETL) processes to support MI/BIefforts, 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/Postgre

SQL, 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 Postgre

SQL 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, Postgre

SQL, Greenplum, and flat files. Tableau dashboard development experience including connecting to enterprise data sources, building calculated fields and parameters, designing interactive dashboards and…