[Hiring] ETL Modernization Architect @aKube Inc

Role Description

This is a remote position.

• Onsite/Hybrid/Remote: Remote
• Duration: 12 months
• Rate Range: $75 in W2
• Work Authorization: GC and US Citizens Only

Responsibilities

• Define the architecture and migration strategy for modernizing legacy ETL and ELT pipelines.
• Assess IBM DataStage jobs, databases, and data warehouses for migration readiness.
• Design scalable data solutions using Databricks Spark on AWS.
• Establish architecture standards, reusable frameworks, and governance controls.
• Design CI/CD pipelines for automated builds, testing, and deployment.
• Lead technical design reviews, migration planning, and artifact validation.
• Define parity, functional, UAT, regression, and performance testing strategies.
• Ensure schema validation, data quality, lineage, security, and production readiness.
• Guide cutover, go-live, hypercare, and operational stabilization activities.
• Oversee the decommissioning of legacy DataStage jobs and related components.
• Create operational documentation and conduct knowledge-transfer sessions.
• Provide technical direction to developers and engineering teams.

Qualifications

• Extensive experience designing enterprise ETL/ELT architectures.
• Hands-on experience with IBM DataStage and Databricks modernization projects.
• Strong experience with Databricks, Delta Lake, Unity Catalog, Photon, and Spark.
• Strong knowledge of AWS data services, including Glue, Redshift, and Lambda.
• Experience designing large-scale database and data warehouse migration programs.
• Proficiency in Python and Unix/Linux scripting.
• Experience with Terraform and automated deployment pipelines.
• Knowledge of data governance, observability, lineage, and operational readiness.
• Experience defining testing and production-readiness standards.
• Experience working in Agile/Scrum environments and PI planning.

Nice to Have

• GitLab or Azure DevOps experience.
• JIRA experience.
• Automated data-testing framework experience.
• Experience leading enterprise cutovers and hypercare activities.
• Experience mentoring data engineering teams.