Epicareer Might not Working Properly
Learn More

Technical Analyst - SQL

$ 5,000 - $ 7,000 / month

Checking job availability...

Original
Simplified

Responsibilities

· Develop, test, manage and implement SSIS Packages from development server to production server using package configuration.

· Work on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

· Ability to automate the execution of SSIS packages using SQL Server Agent Jobs.

· Develop ETL specifications, data mapping and other documentation required for ETL development.

· Use SQL, data models, data element dictionary and schema to perform data and business analysis.

· Understand business data and perform quality assurance testing to ensure the data presented is correct.

Skills/Requirement

· Bachelor’s degree in computer science, Information Systems, Engineering or a related field

· 2+ years of applications design and development experience with SQL Server/MS-SQL scripting and SSIS

· Analytical and data analysis skills using Microsoft SQL

· Previous team leadership experience to include analyzing, mentoring and monitoring.

· Knowledge in Unix and Control-M is an added advantage.

Responsibilities

· Develop, test, manage and implement SSIS Packages from development server to production server using package configuration.

· Work on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

· Ability to automate the execution of SSIS packages using SQL Server Agent Jobs.

· Develop ETL specifications, data mapping and other documentation required for ETL development.

· Use SQL, data models, data element dictionary and schema to perform data and business analysis.

· Understand business data and perform quality assurance testing to ensure the data presented is correct.

Skills/Requirement

· Bachelor’s degree in computer science, Information Systems, Engineering or a related field

· 2+ years of applications design and development experience with SQL Server/MS-SQL scripting and SSIS

· Analytical and data analysis skills using Microsoft SQL

· Previous team leadership experience to include analyzing, mentoring and monitoring.

· Knowledge in Unix and Control-M is an added advantage.