Data Transformation, Data Engineering Lead
- Fixity Technologies
19 Hours Ago
110000-12 per Annum
Yearly
Charlotte NC-NC
8-12 Years
Required Skills: Data Engineering, ETL Development, Data Integration, IBM DataStage, IBM CloudPak, Advanced SQL, PL/SQL programming, Oracle, DB2 databases, Data Modeling, data validation, Linux, Unix environments, stakeholder management
Job Description
We are seeking an experienced Data Transformation & Data Engineering Lead with deep expertise in IBM DataStage and IBM CloudPak for Data (CP4D) to lead enterprise-scale data integration and transformation initiatives. The ideal candidate will have extensive experience designing, developing, and optimizing ETL solutions, data pipelines, and large-scale batch processing environments while working with Oracle and DB2 databases.(Multiple Openings)
This role requires strong technical leadership, data modeling expertise, and the ability to collaborate with cross-functional teams to deliver high-quality, scalable data solutions.
Key Responsibilities
- Lead the design, development, and implementation of enterprise data transformation and ETL solutions using IBM DataStage.
- Design and maintain scalable data integration workflows within IBM CloudPak for Data (CP4D) v4.5.
- Develop and optimize SQL/PLSQL scripts, stored procedures, and complex database operations.
- Design, implement, and support large-scale batch processing environments.
- Perform data modeling, data validation, and ensure data quality across enterprise systems.
- Optimize ETL jobs for performance, scalability, and reliability.
- Troubleshoot production issues and provide root cause analysis.
- Collaborate with business stakeholders, architects, and development teams to deliver data solutions.
- Support Linux/Unix-based ETL deployments and automation.
Required Skills
- 12+ years of experience in Data Engineering, ETL Development, or Data Integration
- Strong hands-on experience with IBM DataStage
- Experience with IBM CloudPak for Data (CP4D) Version 4.5
- Advanced SQL & PL/SQL programming
- Experience with Oracle and DB2 databases
- Strong knowledge of Data Modeling
- Experience designing and supporting large-scale batch processing
- Performance tuning, troubleshooting, and data validation expertise
- Experience working in Linux/Unix environments
- Excellent communication and stakeholder management skills
Preferred Skills
- Experience with CockroachDB or MemSQL (SingleStore)
- Python scripting for automation
- Oracle GoldenGate
- CDC (Change Data Capture) technologies
Why Join Us?
- Work on enterprise-scale data modernization initiatives.
- Opportunity to lead high-impact data transformation projects.
- Collaborate with experienced architects and engineering teams.
- Exposure to modern cloud data platforms and enterprise integration technologies.
