Lead Data Conversion & ETL Specialist - Level III Job at Sligo Software Solutions, Albany, NY

ejZ4bmFCL1VSaCszd0FUNVBYZ1phZldvc3c9PQ==
  • Sligo Software Solutions
  • Albany, NY

Job Description

13+ Years of Total work experience

Nice to have prior govt client experience.

Must have 2 or more years of Lead experience.

Mandatory Qualifications:

  1. 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
  2. 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.
  3. 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:

  1. Three or more years of experience in government or public sector data systems.
  2. Experience with data conversion/migration projects, especially legacy-to-modern system transitions .
  3. Strong understanding of data warehouse/DataMart concepts (staging, dimensional modeling, etc.)
  4. 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.
  5. Working knowledge of Python for data processing or automation scripts, a plus.
  6. Experience supporting QA/UAT for data conversion testing.
  7. Strong written and verbal communication skills; ability to present data findings to technical and non-technical audiences.

Job Tags

Work experience placement

Similar Jobs

Jimmy John's

In-Store Team Member Job at Jimmy John's

Currently looking to hire a Team Member for Weekday Lunch shifts. In-Store Team Members are part of an Inshop tipping pool that is included on the employee's biweekly paycheck. In-Store Team Members are responsible for the successful execution of fast, accurate sandwiches... 

Feeser's Food Distributors

Marketing Manager Job at Feeser's Food Distributors

Marketing Manager Location: Harrisburg, PA - Onsite work required Company: Feesers, Inc. About Feesers, Inc. Founded in 1901, Feesers, Inc. is a family-owned and operated full-line foodservice distributor serving customers throughout the Mid-Atlantic region....

Confidential

Content Creator Job at Confidential

 ...improvingbuildings;itsabout creating perfect places that improve peoples lives. Transformthe everydaywith us! As the Content Creator for a global organization, you will collaborate with developers, testers, product managers, and other subject matter experts... 

Wendy's Deters Co

Farm Manager Job at Wendy's Deters Co

We are seeking an experienced Farm Manager to oversee and manage daily operations on our farm located in Independence, KY. This role involves leading a team to ensure efficient, sustainable, and profitable farming practices while maintaining high standards of safety and... 

Colorado Springs Therapy Center

School Setting SLP (Salaried positions available!) Job at Colorado Springs Therapy Center

Signing Bonus: $5,000 Pay Range: $50.00-$73.00 per hour About Us: Colorado Springs Therapy Center has two expanding outpatient clinics that offer speech, occupational, and physical therapy services to children and adults in caring environments centered on patients...