Tableau Developer

Job Title: Senior Tableau Report Developer Location: Hartford CT (Hybrid) Duration: Contract In this role, the following services are required: • Develops Tableau Reports. • Assist in the design and development of the database architecture including relational data structures, data marts, data dictionaries and logical and physical data models. • Develop strategies for data acquisitions, data quality and data discrepancy. • Assist in migration and integration of data and processes from legacy systems to new applications and new technologies. • Develop and maintain efficient, well documented custom SQL scripts, stored procedures, triggers using Microsoft T-SQL in accordance with defined business rules and requirements to support application development. • Must have the ability to access data stored in a variety of database management systems such as DB2, SQL Server and other. • Design, develop and implement ETL/ ELT solutions for data ingestion, cleansing, business rules execution and Data Distribution. • Implementing Data Analytics best practices in designing data modeling, ETL Pipelines, Near time data solutions. • Coordinate with Business Analyst and users to validate requirements. • Implementing solutions to integrate external data with inhouse data. • Perform tests and validate data flows and prepare ETL processes according to business requirements. • Designing and implement a data conversion strategy from legacy to new platforms. • Perform design validation, reconciliation and error handling in data load processes. • Optimize SSIS Package execution and SQL execution to optimize data load performance. • Design SSIS packages using data exchange tasks such as File transfer and Secured File transfer. Ability to import and export files from FTP/SFTP. • Involvement in all stages like Requirements gathering, Data mapping, Data extraction, Data loading, Data testing, Troubleshooting, documentation, performance optimization and maintenance. • Development of different kind of reports using Tableau as per user requirement and deploying to report server/ integrated SharePoint report server. • Experience using dynamic grouping fields, dynamic group sorting, on-demand sub reports, drill down and summary reports, and creating cross tab reports highlighting key summary information. 10 or more years of prior experience demonstrating the following knowledge and skills: 1. More than 5 years of Experience with Tableau. 1. More than 5 years of experience writing complex SQL queries 1. More then 5 years Expertise with TSQL, SSRS, SSIS or Talend 1. Experience with debug and improve query performance 1. Experience with deploying SSIS packages using git check-in, setting up environmental variables and creating respective jobs in SQL Agent. 1. Experience with Transact-SQL and stored procedures desired. 1. Experience with creating, deploying and maintaining of Tallend reports. 1. Experience with code control/version Team Foundation. 1. Strong problem solving, cross-functional analysis and forward-thinking abilities 1. Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines Additional Preferred Qualifications: 1. Experience with Salesforce 1. MuleSoft.