Job Title: IN-16261 (95891217)
SSRS/SSIS/SSAS Developer with .net, T-SQL, SSDT, web services, Tableau/Power BI, Mulesoft Anypoint Studio, PostgreSQL, Oracle, Erwin, TFS and Agile experience
Location: US-IN-Indianapolis IN (Dept. of Child Services)
Duration: 12 months
Visa: W2 only (GC/USC)
System functional design, technical design, and programming experience
Software design and development expertise with n-tier application system architecture including use of PostgreSQL, Microsoft SQL Server Enterprise 2008/2012, and Microsoft SQL Server Reporting Services including SSRS, SSIS, and SSAS.
Integration of SSRS Reports with Visual Studio .NET.
Write queries within Microsoft SQL Server Reporting Services.
Grouping, sub-grouping, formatting, conditional formatting, and creating complex formulas.
Test report output.
Export report output to Microsoft Excel format.
Software design and development in Microsoft SQL Server 2012 and PostgreSQL database environment using SQL and T-SQL for stored procedures and functions.
Data analysis and data design.
Performance tuning database stored procedures and functions.
Provide production system support and solving daily production issues
Communicate effectively with technical and non-technical personnel.
Plan work tasks and projects.
Research technical issues, problems, procedures, and methods and advise management.
Provides technical expertise and input on projects.
Microsoft Windows (Advanced)
Programming Languages/Development Tools
Microsoft SQL Server Reporting Services (SSRS) (Advanced)
Microsoft SQL Server Integration Services (SSIS) (Advanced)
Microsoft SQL Server Analysis Services (SSAS) (Advanced)
SQL SERVER Database Tools (SSDT)
XML, XML web services (Entry)
Tableau/Power BI (Intermediate)
Mulesoft Anypoint Studio (Entry)
Database Systems/Database Tools
Microsoft SQL Server RDBMS (Advanced)
Oracle RDBMS, PL/SQL (Intermediate)
SQL, Transact-SQL (Advanced)
CA Erwin Data Modeler (Intermediate)
Expertise with full software development life cycle including software system analysis, functional design, technical design, development, testing, code review and production system support (Entry)
Knowledge of Agile Development
Microsoft Team Foundation Server (Advanced)