Job Description :
Duties:
? Review and evaluate the existing data sources and analyze the conversion steps required.
? Design, develop, revise, and maintain SQL scripts, code, and queries for data translation, conversion, and reporting.
? Convert existing data, using ETL processes, creating queries and scripts to manipulate the data into the format needed.
? Conduct system testing and provide trouble-shooting to quickly and accurately find solutions to resolve issues.
? Provide post conversion issue resolution, inefficiencies and/or recommendations for existing process changes.
Education Qualification:
? A Bachelor''s Degree from an accredited college or university with a major in Computer Science, Information Systems, Engineering, Business, or other related technical discipline is required. A Master''s Degree is preferred.
? Knowledge in developing shell scripting.
? Knowledge in database servers such as DB2, PostgreSQL, Oracle, SQL Server
General Experience:
? At least six (6) years of experience in writing data conversion logic in Java, scripting languages such as SQL, Python, Linux Shell Script, Perl, Windows PowerShell.
? Experience in Child Support programs, Integrated Eligibility and/or Health & Human Services domain.
? Must possess knowledge of data conversion routines, protocols, and ETL processes.
? Knowledge of ETL processes, data migration, data conversion, and/or data integration routines and protocols.
Comfortable importing and exporting database files from multiple sources.