Write complex SQL queries involving inner and outer join, store procedures, triggers and user defined functions, Perform Performance Tuning, Query Optimization, Manage Alerts, Operators and Jobs through SQL Server Agent, Create Dimensional Modeling and ETL design. Work on ETL process using SSIS packages, Create packages to extract data from DB2 (AS/400), ORACLE, MS ACCESS and FLAT FILES and load it to SQL SERVER use DTS/SSIS and implement Incremental load in SSIS packages, Deploy SSIS Packages using Team Foundation Server and migrate SSIS packages, Design STAR, SNOW FLAKE Schemas, Report writing using SQL Server Reporting Services (SSRS) and create various types of reports like Drill Down, Drill Through, Parameterized, Cascading, Table, Matrix, Chart, Adhoc and Sub Reports, Creating Data Visualizations using Tableau/Power BI, Work with Data Modeling Tools like Erwin and Microsoft Visio, Good understanding of (SDLC) Software Development Life Cycle process methodologies and principles REQUIREMENTS: Master’s degree in Science, Electronics, Computer Science or equivalent and 2 years of experience SALARY: $77,501 per year HOURS: 9:00 A.M. - 5:30 P.M 40 hours per week POSITION LOCATION: Competent Systems Inc. 4080 McGinnis Ferry Rd Suite# 1504 Alpharetta GA 30005 USA.
May require travel to various unanticipated client sites nationally. CONTACT: Human Resources Manager, Competent Systems Inc. (Attn: 151004), 4080 McGinnis Ferry Rd Suite# 1504, Alpharetta GA 30005 USA. Email
[email protected] with “Attn: 151004” at the subject line.
