Programmer/Developer

$114,400 - $114,400/Yr

Generis Tek - Hartford, CT

Full-time - Mid Level

Hartford, CT

Professional, Scientific, and Technical Services

About the position

The Programmer/Developer role is a contract position based in Hartford, CT, requiring a highly organized and self-directed individual to lead development efforts. The primary focus is on developing Tableau reports, designing database architecture, and implementing data analytics best practices. The role demands strong problem-solving skills and effective communication to coordinate with business analysts and users.

Responsibilities

• 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 MS T-SQL in accordance with defined business rules and requirements to support application development.
• Access data stored in a variety of database management systems such as DB2, SQL Server and others.
• Design, develop and implement ETL/ELT solutions for data ingestion, cleansing, business rules execution and Data Distribution.
• Implement Data Analytics best practices in designing data modeling, ETL Pipelines, Near time data solutions.
• Coordinate with Business Analyst and users to validate requirements.
• Implement solutions to integrate external data with in-house data.
• Perform tests and validate data flows and prepare ETL processes according to business requirements.
• Design 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.
• Involvement in all stages like Requirements gathering, Data mapping, Data extraction, Data loading, Data testing, Troubleshooting, documentation, performance optimization and maintenance.
• Development of different kinds of reports using Tableau as per user requirement and deploying to report server/integrated SharePoint report server.

Requirements

• 10 or more years of prior experience in IT.
• More than 5 years of experience with Tableau.
• More than 5 years of experience writing complex SQL queries.
• More than 5 years of expertise with TSQL, SSRS, SSIS or Talend.
• Experience with debugging and improving query performance.
• Experience with deploying SSIS packages using git check-in, setting up environmental variables and creating respective jobs in SQL Agent.
• Experience with Transact-SQL and stored procedures desired.
• Experience with creating, deploying and maintaining Talend reports.
• Experience with code control/version Team Foundation.
• Strong problem solving, cross-functional analysis and forward-thinking abilities.
• Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines.

Nice-to-haves

• Experience with Salesforce
• MuleSoft.

Benefits

• Contract role with a pay rate of $55/hr on W2.
• Project duration of 6+ months.