Lead Data Conversion & ETL Specialist - Level III

Greetings from Sligo Software Solutions, Inc. !!

This is Dasharatham from SLIGO. We have an urgent requirement for Lead Data Conversion & ETL Specialist - Level III position with our client.

Title : Lead Data Conversion & ETL Specialist - Level III

Location : Albany, New York

Duration : 2 year(s) 6 month(s) 2 day(s)

Client : Sligo Software Solutions - N/A

Job ID: SLG - 26 - 12426

Respond by: 09/28/26 2:00 PM

13+ Years of Total work experience

Nice to have prior govt client experience.

Must have 2 or more years of Lead experience.

Mandatory Qualifications

• Level III- More than seven (7) years of experience working on complex projects with 2 or more years in a leadership role as a Specialist
• More than seven (7) years working on data conversion/data warehouse projects, including: source system metadata analysis, documentation, and validation; source-to-target data mapping; data profiling and data cleansing rules; To-Be system data requirements gathering, analysis, documentation, and validation; data synchronization and bridging requirements; and data conversion quality assurance testing; experience with UNIX shell scripting with performance tuning of queries during data loads and transformations.
• More than seven(7) years of experience working across the full Software Development Life Cycle (SDLC) for data conversion/data warehouse projects, including requirements gathering, design, development, testing, and deployment phases as a Data Analyst and ETL developer in data warehousing or data integration projects; writing SQL statements and queries against RDBMS platforms such as Oracle, SQL Server, and PostgreSQL as part of development and validation; developing and executing ETL processes using any industry-standard ETL tool or scripting-based approach (e.g., Informatica, T-SQL, PL/SQL, PL/pgSQL).

Desirable Qualifications

• Three or more years of experience in government or public sector data systems.
• Experience with data conversion/migration projects, especially legacy-to-modern system transitions .
• Strong understanding of data warehouse/DataMart concepts (staging, dimensional modeling, etc.)
• Five or more years of experience with Data Quality processes, approaches, measurement techniques, and business cases for data profiling, cleansing, standardization, and match and merge functionality.
• Working knowledge of Python for data processing or automation scripts, a plus.
• Experience supporting QA/UAT for data conversion testing.
• Strong written and verbal communication skills; ability to present data findings to technical and non-technical audiences.