Senior Data Mapping & ETL Specialist

Mega Cloud Lab; City of Albany (NY); On-site; USD 95,000 - 135,000; Full time

Job summary

Mega Cloud Lab is looking for an experienced Data Specialist to own data mapping and data requirements for a system migration. You will deliver complete, well-documented source-to-target mappings and validate them with stakeholders.

You will collaborate with SMEs, BAs, and development teams to develop As-Is to To-Be mappings, perform ETL activities, and write SQL against Oracle, SQL Server, and PostgreSQL. UNIX shell scripting is a plus.

Qualifications

• Must have 7+ years on complex data projects and 2+ years in leadership as a Specialist.
• Extensive experience with data conversion, metadata analysis, data mapping, profiling, cleansing, and validation.
• Broad SDLC experience for data conversion/data warehouse projects; proficient in SQL on Oracle/SQL Server/PostgreSQL.
• Strong UNIX shell scripting with performance tuning during data loads and transformations.
• Ability to design and implement To-Be data requirements and bridge/source-to-target mappings.
• Experience supporting QA/UAT for data conversion testing.

Responsibilities

• Own data mapping, data requirements, and validation for system migration.
• Gather, document, and maintain source-to-target data mappings and target data models.
• Perform ETL activities, data profiling, cleansing, and transformation rule definition.
• Develop and test SQL queries against Oracle, SQL Server, and PostgreSQL.
• Collaborate with SMEs, BAs, and development teams to validate data requirements.
• Coordinate data profiling and cleansing with business users and stakeholders.

Skills

Data mapping

Leadership

SQL querying

UNIX shell scripting

Data profiling

Data cleansing

ETL development

Tools

Oracle

SQL Server

PostgreSQL

Informatica

PL/SQL

T-SQL

PL/pgSQL

Job description

Mega Cloud Lab is looking for an experienced Data Specialist to own data mapping and data requirements for a system migration. You will deliver complete, well-documented source-to-target mappings and validate them with stakeholders.

You will collaborate with SMEs, BAs, and development teams to develop As-Is to To-Be mappings, perform ETL activities, and write SQL against Oracle, SQL Server, and PostgreSQL. UNIX shell scripting is a plus.