Job duties include:

• Perform data cleansing and data quality.
• Profile Data and perform Data Simplification and warehouse creation.
• Involve in verification of data that is quantified and qualified after ETL process compared to the original source Data and validate.
• Write complex SQL queries, store procedure, develop packages to retrieve the data form sources system and to count and validate the data and data set.
• Involve in Data Migration from source to target Database.
• Demonstrate understanding of code repository strategies, code promotion strategies, and recovery using Team Foundation Server (TFS).
• Perform database validation to check the updated data in the database using SQL.
• Utilize complex SQL Queries and validating the UI values against the database. Using various DML commands like Select, Insert, Sub Queries, Inner Joins, Outer Joins, and Union.
• Utilize Xcelys as first generation of data source and querying against it to validate the primary source of data.
• Work with project manager in identifying the project Scope and approach.
• Verify data integrity of large number of Fact and Dimension tables.
• Create packages to generate the data files from oracle and SQL server databases.
• Incorporate EMS model while generating the data files and delivering via ECG.
• Analyze the data from the source database and design in the existing model to the target database and design crosswalk tables if required.
• Load the data from source to target with necessary business rules using SSIS and performing unit testing.
• Schedule the jobs according to the execution process in SQL server as it’s a relational database model.
• Involve in resolving the issues related with the migration of designs from Development Server to Production Server

Requirements: Master’s degree in CS, IT, Information System or related with at least 6 months of experience. Salary from $88,150 to $92,000. Send resume to: hr@vuegen.com including the JOB ID. Travel and relocation to various unanticipated client locations throughout the United States may be required. Equal Opportunity Employer.