Job Seekers, Please send resumes to resumes@hireitpeople.com

Job Duties: 

Oversee IV-D data conversions. Work with the Implementation team to facilitate smooth and timely data migrations. Use creative techniques to compare data with conflicting data types and resolve issues Collaborate with the Quality Assurance team to verify correct conversion completion and effectively communicate with Project Managers. Collaborate with the Development team to ensure vast quantities of data can be moved into the system without affecting performance. Oversee analysis of databases with the goal of producing the initial Data Mapping /Table Mapping for the ETL Extract process. Evaluate code/scripts to Load the data into the target database. Help to implement tools, scripts, queries or applications for accessing and analyzing data and migrating data. Understand technical specifications for ETL processes or components; He/she needs to be able to develop/evaluate production migration steps and documentation. Perform unit and system integration testing and performance test. Document step-by-step guides of the entire process from running reports, to combining and tweaking data, to importing via the tool. Provide accurate conversion timelines. Evaluate conversion manuals.  Use cloud services to integrate different data sources and develop data lakes. Provide recommendations to optimize data pipelines and data warehouse queries. Implementing data solutions using SQL Serer, Redshift & SSIS. Acquire data from multiple data sources and maintain resulting databases, data warehouses, and/or data lakes. Conduct data analysis and capture, develop, and document data definitions, business rules, and data quality requirements. Collect, analyze, and validate data prior to it being used or stored. As a SQL Developer transformation factory associate work to build a project management tool to help internal teams manage the transformation and migration process. The tool should enable and capture workflow changes mid-flight, provide lightweight workflow solutions to manage changes, visualize data, and generate reports. Manage the transformation process from onboarding, managing, reporting, to execution of various migration factories. Strong data analytic skills: Ability to troubleshoot data questions/discrepancies. Design/analyze database schemas and optimize database design. Strong T-SQL script creation, used in ad-hoc analysis and object creation. Design, develop, and test database objects (tables, views, stored procedures, indexes, functions, constraints) that are highly optimized. Work with other Report developers and provide stored procs for Click report calls. 

Education: The minimum qualification required for the performance of the above specialty occupation duties is a bachelor's degree or equivalent in Computer Science or equivalent in a related field or a foreign equivalent is required closely related field with relevant experience.