Data Engineer

We’re hiring at Power Staffing Solution! 🔹 Senior Data Engineer (IBM DataStage) – Consultant  🔹 Location: Orlando, FL (Hybrid 3-Days onsite) 🔹 Type: Contract 🔹 Duration: Contract with opportunity for extension Power Staffing Solution seeking a Senior Data Engineer – Consultant with strong ETL and data integration expertise to design, build, and support filetotable data transformations using IBM InfoSphere DataStage. In this role, you will convert inbound file feeds into reliable, auditable, and highperformance SQL Server table loads, ensuring consistent operations, clear error handling, and repeatable processes. Key Responsibilities: * ETL Development: Design and maintain end-to-end DataStage jobs (Sequential File, Transformer, Lookup, Join, etc.) for file ingestion (CSV, fixed-width) to SQL Server. * Data Logic: Map source-to-target requirements and implement staging, validation, and publishing logic. * SQL Mastery: Write and optimize T-SQL queries, stored procedures, and scripts. * Operational Excellence: Build restartable jobs with parameterization, robust logging, reject handling, and reconciliation checks. * Data Quality: Implement schema validation, referential integrity, and null/duplicate detection with exception reporting. * Optimization: Tune DataStage (partitioning, buffering) and SQL (indexes, execution plans) for peak performance. * Support & Collaboration: Monitor executions (Director/Console), perform root-cause analysis, and collaborate with QA/DevOps teams on documentation and releases. Required Skills & Experience: * Education: Bachelor’s degree in CS, Engineering, or equivalent experience. * DataStage: Hands-on experience with IBM InfoSphere DataStage and complex mappings. * SQL Server: Advanced T-SQL (Window functions, CTEs, Indexing, Execution plans). * File Handling: Deep knowledge of parsing CSV/fixed-width, headers/trailers, and encoding. * Architecture: Proven ability to design parameter-driven, auditable, and troubleshootable ETL solutions. Preferred Qualifications: * Technical Tuning: Experience with DataStage Parallel Jobs and data skew handling. * Environment: Proficiency in UNIX/Linux shell scripting and job schedulers (Control-M, Autosys). * DevOps: Familiarity with CI/CD and Git version control. * Data Modeling: Knowledge of Warehouse patterns (SCDs, delta loads, surrogate keys). * Governance: Awareness of metadata management, lineage, and data security. How to Apply: Send your resume to [Upgrade to PRO to see contact] #PowerStaffingSolution #Power #Staffing #Solution #Hiring #DataEngineering #IBMDataStage #InfoSphere #ETLJobs #SQLServer #TSQL #DataIntegration #DataWarehouse #DataStageConsultant #BigData #DataPipeline #DatabaseEngineering #TechJobs #ConsultingCareers