Analyze, design, develop, integrate, deploy, and implement software applications and databases using ETL, MySQL, SSIS, SSDT, SSRS, SQL Server, T-SQL, and TOAD technologies, languages, databases, and tools.
Design, develop, deploy, and test ETL mappings and workflows. Evaluate data models and databases for variances and discrepancies. Create and deploy SSIS/SSDT packages for ETL tasks.
Write SQL queries to extract, transform and load data to and from heterogeneous and homogenous sources. Support daily production tasks and resolve.
Create and deploy SQL Server reports. Schedule and maintain SSIS packages in terms of data validation and consistency. Write store procedures to generate account statements.
Design and develop SQL SSIS Packages to extract data from various data sources into SQL server 2008 for further data analysis and reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
Use Script task in SSIS to write custom code using Vb.net and C#. Work with T-SQL to create Tables, Views, and triggers and stored Procedures.
Use indexes to enhance the performance of individual queries and enhance the stored Procedures. May require travel to unanticipated work locations.
Required skills and experience
Require Master of Science in Computer Science, Computer Information Systems, Electrical/Electronic Engineering, or related field and 2 years’ experience in the job offered, Software Developer, Systems/Programmer Analyst, Consultant, or related field.
How to Apply:
Please mail your resume to USA InfoTech, Inc., 5012 Lindera Ct, Ellicott City, MD 21042