Description

You will design, develop, and support database solutions and ETL processes.

Responsibilities

• Create stored procedures, views, triggers, functions, and indexes using T-SQL.
• Develop and maintain SSIS ETL packages and SSRS reports to meet business needs.
• Elicit data requirements through interviews, document analysis, and workshops.
• Perform unit testing, regression testing, and troubleshooting for database procedures and ETL packages.
• Translate business requests into complex SQL queries and ad hoc reports independently.

Required Skills

• 5+ years of experience with extensive knowledge of Agile process development.
• Proficiency in T-SQL and writing complex queries.
• Hands-on experience with SSIS ETL development and data extraction/migration tools.
• Experience with SQL Server 2012 and later versions.
• Knowledge of performance tuning and SQL Profiler.
• Experience with all aspects of the System Development Life Cycle (SDLC).
• Ability to review table structures and existing stored procedures to understand processes.
• Bachelor's Degree in Computer Science, Information Systems, or equivalent work experience.

Preferred Skills

• 7 years of experience in SQL development.
• Experience with System analysis, SoftwareAG webMethods, InRules, or MS Team Foundation Server.

Key Skills

Education

Any Graduate