Current Job Openings

Data Migration Lead Developer: Albany, NY

Due Date:
Saturday, December 31, 2022 12:00 PM

Job Title:
Data Migration Lead Developer

Albany, NY

Scheduled Work Hours:
Full Time - TBD

Service Scope:
Work with the client and the data migration team to map data between the various staging environments. Design, develop, test and implement DataStage jobs to move data between the various staging environments for the data migration to the new system. Produce exception reports and logs to the data migration team. Resolve data migration ETL issues.

Complete analysis, documentation, data pipelining, staging, remediation, cleansing, quality assurance, and publication of all in scope data

Collaborate with the Data Migration team for actual data migration, data validation and system acceptance. Provide consulting support for data extract, stage, transform, and integrate the core data that is in- scope for delivery and access with the new solution.

Hisam will also double up as DM Lead; for now, Bala will continue to fill in for DM Lead until Hisam comes up to the speed.

Mandatory Skills:
The DataStage Developer should have 60 or more months of experience, in this role, with a combination of the experience described in the job function/description below.

Hands on experience in delivering DataStage projects of similar scale. At least 2 projects. (in DMV DQ&SI There are 130 data stores involving over 200M master records, 2 Billion overall records that will need to be analyzed, prepared, and migrated).

• Hands on experience in IBM InfoSphere® DataStage® at least 2 years
• Knowledge of whole IBM Information Server suite (Information Analyzer, Governance Catalog, DataStage, Quality Stage etc.)
• Ability to guide and advise clients in Data Management and Governance approaches, strategies, and best practices
• Agile project experience required
• Experience with MS Office products (MS Office,
Visio and Project experience
• Scripting - DOS/PowerShell/Unix Shell Scripting
• Experience with data quality tools
• Ability to write data rules using pseudo code

Desired Skills:
• Expert level experience in DataStage Design and Development, best practices and processes
• Experience with Other ETL/ELT technologies (Informatica, Pentaho, SSIS, Etc.)
• Experience in Data integration, data architecture and, project life cycle Phases, best practices and processes
• Strong data modeling (Relational Databases & Data Warehouse) and related technology skills (SQL etc.)
• Good understanding of Data Governance, MDM.
• Exposure to the latest technologies and frameworks in DQ.
• Experience with data lakes
• Strong written and verbal communication skills
• Experienced presenter
• Successful applicants will have strong interpersonal skills
• At least 5 years of experience with IBM InfoSphere DataStage
o Experience in handling pipeline and partition parallelism for improving performance
o Production problem solving experience using Peek, Row Generator and Column Generator Stages
o Experience in handling job sequences and job schedules to automate the ETL processes.
o Experience in handling feeds using multiple data sources such as z/OS DB2, MS SQL Server, Complex Flat Files, Delimited Files and XML files
o Experience in performance tuning and methodologies in DataStage

Preferred Skills and Education
• Ability to conduct analysis on the data using database querying, excel, and other methods
• Windows Server 2016
• ETL experience using SQL Server 2008, 2012, 2014, & 2016 as source or destination
• InfoSphere Information Server 11.7.1 or newer
• InfoSphere Information Server Microservices Architecture
• Bachelor’s degree in Computer Science or related field.

Apply for this job

« Back to Current Job Openings