Senior Consultant focusing on data migrations within Master Data Management for Scheer group. Engaging in project leadership, consulting, and strategy development for data migration projects.
About the role
- Software Engineer with strong ETL experience to design and build data transformations at 3Core Systems, Inc. Focusing on file-to-table data transformations using IBM InfoSphere DataStage.
Responsibilities
- Design, develop, and maintain IBM DataStage ETL jobs that ingest file feeds (CSV, fixed-width, delimited) and load curated destination tables in SQL Server.
- Build end-to-end ETL flows, including staging, transformations, validations, and publishing to downstream schemas.
- Perform source-to-target mapping and implement transformation logic based on business and technical requirements.
- Use common DataStage stages and patterns (e.g., Sequential File, Transformer, Lookup, Join/Merge, Aggregator, Sort, Funnel, Remove Duplicates), with attention to partitioning and parallel job design.
- Write, optimize, and tune SQL Server queries, stored procedures, and T?SQL scripts used in ETL workflows.
- Implement restartable and supportable jobs: parameterization, robust logging, reject handling, auditing columns, and reconciliation checks.
- Apply data quality controls (format checks, referential checks, null/duplicate checks, threshold checks) and produce clear exception outputs for remediation.
- Monitor and troubleshoot ETL runs using DataStage Director/Operations Console and SQL Server tooling; perform root-cause analysis and fix defects.
- Improve performance through job design tuning (partitioning strategy, sorting choices, buffering, pushdown where appropriate) and SQL tuning (indexes, statistics, set-based logic).
Requirements
- Hands-on IBM DataStage ETL development experience, including data mapping and transformation implementation.
- Strong SQL Server experience with advanced T?SQL (joins, window functions, CTEs, temp tables, indexing basics, query plans).
- Solid understanding of file-based ingestion and parsing (CSV, fixed-width, headers/trailers, control totals, encoding, delimiters, quoting/escaping).
- Experience designing ETL jobs with good operational characteristics: parameter-driven design, logging, error handling, restart/re-run strategy, and auditability.
- Ability to troubleshoot data issues end-to-end (source file – stage tables – target tables) and communicate findings clearly.
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Data Engineer developing ETL processes and BI solutions for RUF Lebensmittelwerk. Collaborating on data models in a cloud environment with Microsoft technologies.
Manager leading data and analytics projects to enhance client operations across multiple states at PwC. Focusing on strategic planning, mentoring junior staff, and project success.
Data Engineer II specializing in automated systems for data processing and analysis in property taxation. Collaborating across teams to ensure accuracy and deliver timely solutions.
Data Architect leading scalable cloud - based architectures at Fidelity. Collaborating with cross - functional teams to modernize brokerage recordkeeping systems and ensure data compliance.
Salesforce Solutions Architect specializing in Data Engineering at Pottencial, integrating Salesforce with analytical platforms. Leading governance and scalable solutions in CRM environments.
Data Engineer developing complex software systems for a multinational IT services company in Switzerland. Utilizing data engineering techniques and high - level programming languages.
Senior Data Management Engineer at a leading IT Consulting firm. Designing enterprise data solutions ensuring data quality and governance using Informatica tools.
Senior Data Management Engineer designing and implementing enterprise data solutions for a global IT leader. Collaboration with stakeholders to ensure data quality and scalability.
Senior Data Management Engineer designing and implementing data solutions for a global IT consulting leader. Collaborating with teams to ensure data accessibility, quality, and governance.