Job Description :
Job Title: T-SQL/ Report Writer
Work Location: Norristown, PA
Position Description/Responsibilities:
T-SQL/ Report Writer
Location: Norristown, PA
Duration: 3 mos (likely to go longer)
Need: ASAP
Please see vendor comments for more information.
Key skills:
Tableau
T-SQL
SQL
PL/SQL
Cyrstal Reports
Local candidates to Norristown, PA preferred.
Experienced T-SQL Developer and Report Writer
This person will write and tune queries and stored procedures against normalized transactional data. He or she will build reports in SAP Business Objects and Tableau. This candidate will drive report standardization and recommend areas for consolidation/standardization and leverages BI best practices to propose areas for improvement.
Skills:
Oracle 11g and Oracle SQL Developer
SQL Server 2012 and SQL Server Management Studio
SAP Business Objects Enterprise 4.2 and Crystal Reports
Tableau 10
Informatica PowerCenter
MetaData Manager
Required Skills
Experience in T-SQL development utilizing Oracle 11g and SQL Server 2012
Proficient in writing and optimizing queries and stored procedures including the analysis of query execution plans
Experience building warehouse reports with Crystal reports and Tableau
Comfortable working with views, user defined functions, complex joins
Experience in adjusting indexes and updating statistics
Comfortable working within a formal SDLC
Excellent communication skills
Experience with JD Edwards table structure a plus