ETL Data Stage Developer

Apptad Inc.
Charlotte, United States of America
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Charlotte, United States of America

Tech stack

Unix
Cloud Database
Data Infrastructure
Data Integrity
ETL
Data Structures
IBM DB2
Relational Databases
Database Storage Structures
IBM InfoSphere DataStage
JSON
Python
PostgreSQL
Simple Object Access Protocol (SOAP)
SQL Databases
Systems Integration
XML
Data Processing
Generative AI
Data Pipelines
Api Management

Job description

  • Analyze Data Sources & ETL Processes - Lead the assessment of data sources, ETL workflows, and database structures.
  • Identify Data Gaps - Detect data and process gaps; propose remediation and long term improvements.
  • Work with ETL & RDBMS Technologies - Utilize tools such as IBM DataStage, DB2, PostgreSQL, and others.
  • Handle Complex Data Formats - Work with XML, JSON, CSV, and other heterogeneous data structures.
  • Test REST/SOAP Integrations - Leverage a strong understanding of API integrations.
  • Build Python Automation - Develop Python tools for cross format data comparison and automated validation.
  • Communicate with Stakeholders - Translate technical insights into business friendly language for all levels, including leadership.
  • Act as a Business Data Liaison - Provide data driven insights that influence business strategy.
  • Manage Multiple Projects - Deliver high quality outcomes in a dynamic, research oriented environment.
  • Collaborate with Business Units - Document business needs, reporting requirements, and process challenges.
  • Design Scalable Pipelines - Build robust, efficient data pipelines using existing ETL frameworks.
  • Create Synthetic Datasets - Analyze source systems and generate test datasets.
  • Develop Automated Validation Tools - Ensure data integrity and generate comparison reports.
  • Apply Best Practices - Maintain quality across development, integration, and testing.
  • Use Generative AI - Enhance analysis, accelerate development, and improve documentation.
  • Perform Statistical Analysis - Identify patterns and generate actionable insights.
  • Provide Strategic Recommendations - Partner with business leaders to improve processes and inform decisions.

Preferred Experience

  • Insurance Domain Knowledge - Experience in insurance data environments is a strong plus.
  • Any ETL/Cloud Data Engineer Certification - Certification is beneficial but not mandatory.

Requirements

Sr DataStage Developer Charlotte NC Full Time Must Have Technical/Functional Skills Expertise in IBM DataStage version 11.5 or above,Cloudpak,DB2, Unix and SQL. Possess a…

Apply for this position