Talent.com
Senior ETL / Report Developer 1 Year Contract Hartford, CT 06106 (Hybrid)

Senior ETL / Report Developer 1 Year Contract Hartford, CT 06106 (Hybrid)

Lorven TechnologiesHartford, Connecticut, United States
job_description.job_card.30_days_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
job_description.job_card.job_description

Job Title : Senior ETL / Report Developer

Location : Hartford, CT 06106 (Hybrid)

Duration : 1 Year Contract

Specific Services Required :

  • Must be very organized, pro-active and self-directed.
  • Must be self-starter and driven. Must Drive the work from requirements to implementation.
  • Must have very strong abstract thinking and problem-solving skills.
  • Must have very good verbal and written communication skills.

Required Skills :

  • Develops general and detailed design specifications for moderate to complex systems.
  • 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.
  • Create and troubleshoot stored procedures and queries performances using SQL Server Profiler, Performance Monitor, DBCC Commands, Database Engine Tuning Advisor and Execution plans. Recommend query and index improvements to increase performance.
  • 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 SSRS 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.
  • Use Microsoft Team Foundation Server (TFS) and / or Azure Dev Ops to manage changes to code

    • Required Skills and Experience

  • Experience in the analysis and design of application solutions within appropriate standards.
  • Ability to write complex SQL queries
  • Expertise with TSQL, SSRS, SSIS required and Power-Bi, SSAS a plus
  • Experience with debug and improve query performance
  • Experience with deploying SSIS packages using git check-in, setting up environmental variables and creating respective jobs in SQL Agent.
  • Significant experience in real-time, multi-tiered data processing systems
  • Experience with Transact-SQL and stored procedures desired.
  • Experience with creating, deploying and maintaining of SSRS reports.
  • Experience with code control / version Team Foundation.
  • Experience with enterprise data integration technologies including Java, SQL, XSLT, Graphical, and XML
  • Strong problem solving, cross-functional analysis and forward-thinking abilities
  • Flexibility to adapt to changing situations, handle multiple tasks, and meet tight deadlines

    • Preferred Qualifications :

  • Experience with SSIS connectors like KingswaySoft or Cozyroc is plus
  • Experience with DB2, Dynamics, Salesforce.
    • serp_jobs.job_alerts.create_a_job

    Senior Year Contract • Hartford, Connecticut, United States

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    Senior Solutions Engineer

    Senior Solutions Engineer

    VirtualVocationsSpringfield, Massachusetts, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Solutions Engineer.Key Responsibilities Build trusting relationships with prospective customers during technical and business discussions Act as a technical par...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Sr. ETL Developer

    Sr. ETL Developer

    Resource Informatics Group IncHartford, CT, US
    serp_jobs.job_card.full_time
    Understand the data and Data extraction technics from application.ETL tools like Data Stage, Tableau, and informatica.Familiar with BizTalk, Sterling Commerce, Azure Integration platform.serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior HRIS Analyst

    Senior HRIS Analyst

    VirtualVocationsSpringfield, Massachusetts, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior HRIS Analyst.Key Responsibilities Support the iCIMS platform and lead the Workday recruiting implementation Manage project timelines, coordinate meetings, and o...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior ERP Developer

    Senior ERP Developer

    VirtualVocationsHartford, Connecticut, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior ERP Developer to support and enhance their SQL-based Sage ERP system.Key Responsibilities : Lead the design and architecture of ERP customizations using.NET, SQL ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Senior Workday Reporting Analyst - Hybrid (Windsor)

    Senior Workday Reporting Analyst - Hybrid (Windsor)

    SS&C TechnologiesWindsor, CT, US
    serp_jobs.job_card.part_time
    As a leading financial services and healthcare technology company based on revenue, SS&C is headquartered in Windsor, Connecticut, and has 27,000+ employees in 35 countries.Some 20,000 financial se...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Quality and Risk Management Coordinator / Full time / 40 hours / Wallingford

    Quality and Risk Management Coordinator / Full time / 40 hours / Wallingford

    Gaylord HospitalWallingford, CT, US
    serp_jobs.job_card.full_time
    Gaylord Specialty Healthcare is a health system dedicated exclusively to medical rehabilitation.We provide inpatient and outpatient care for people at every point in their journey from illness or i...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Senior Azure Integration Engineer

    Senior Azure Integration Engineer

    VirtualVocationsHartford, Connecticut, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Azure Integration Engineer.Key Responsibilities Architect, develop, and implement end-to-end integration solutions using Azure services Lead technical discussio...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Data Integration Lead

    Data Integration Lead

    VirtualVocationsSpringfield, Massachusetts, United States
    serp_jobs.job_card.full_time
    A company is looking for a Data Integration Lead.Key Responsibilities Develop and manage SAS coding, reporting, and data management processes Perform data validation, manipulation, and analysis ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Senior Facets Configuration Analyst

    Senior Facets Configuration Analyst

    VirtualVocationsHartford, Connecticut, United States
    serp_jobs.job_card.full_time
    Facets Config Analyst to design and implement configuration solutions within the Facets platform for Medicaid and Medicare programs. Key Responsibilities Conduct requirements discovery sessions to...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Senior SDET

    Senior SDET

    VirtualVocationsHartford, Connecticut, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior SDET Contractor to support High Usage Scenario Testing for the Mortgage LOS initiative. Key Responsibilities Design and implement automated test cases for high-us...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Physical Therapist - Team Lead $10K Sign on Bonus

    Physical Therapist - Team Lead $10K Sign on Bonus

    Healthpro Heritage, LLCDeep River, CT, United States
    serp_jobs.job_card.full_time +1
    HealthPro Heritage has a great Physical Therapist / Team Lead Opportunity in Waterford, CT.Open to a Team Lead Role or Staff PT Position . Home Health Setting, All Adults.Competitive Rates / Mileage...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior LLM Engineer

    Senior LLM Engineer

    VirtualVocationsSpringfield, Massachusetts, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior LLM Engineer.Key Responsibilities Support the self-hosted implementation of GitLab Duo and AI gateway in a high-security environment Coordinate networking effor...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Sales Tools Analyst

    Senior Sales Tools Analyst

    VirtualVocationsHartford, Connecticut, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Sales Systems Analyst - Sales Tools.Key Responsibilities Administer and configure core sales tools such as Salesforce CRM and SalesLoft, including user profiles ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Cognos BI Report Developer

    Cognos BI Report Developer

    VirtualVocationsHartford, Connecticut, United States
    serp_jobs.job_card.full_time
    A company is looking for a Cognos BI Reports Developer.Key Responsibilities : Develop, enhance, and maintain Cognos BI reports and dashboards based on business requirements Collaborate with busin...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Oregon Licensed Epic Developer

    Oregon Licensed Epic Developer

    VirtualVocationsSpringfield, Massachusetts, United States
    serp_jobs.job_card.full_time
    A company is looking for an Epic Caboodle & Healthy Planet Developer (Application Engineer, Sr.Key Responsibilities Ensure data integrity and validity of the Epic application and define system st...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Senior C++ Developer

    Senior C++ Developer

    VirtualVocationsSpringfield, Massachusetts, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior C++ Developer to design and deliver high-performance software.Key Responsibilities Design and develop cloud microservices for core domains such as order and subs...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Consultant

    Senior Consultant

    VirtualVocationsSpringfield, Massachusetts, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Consultant.Key Responsibilities Lead and architect solutions for complex business problems Develop strategies and project plans across multiple client teams Me...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior Integration Analyst

    Senior Integration Analyst

    VirtualVocationsSpringfield, Massachusetts, United States
    serp_jobs.job_card.full_time
    A company is looking for a Senior Integration Analyst to facilitate integration between the healthcare ecosystem and their platform. Key Responsibilities Lead feature development for workflows bet...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    ETL Developer

    ETL Developer

    VirtualVocationsHartford, Connecticut, United States
    serp_jobs.job_card.full_time
    A company is looking for an ETL Developer to design and build data pipelines for analysis and reporting.Key Responsibilities Design, develop, and optimize ETL workflows using various tools and pl...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    MDS Coordinator (RN)

    MDS Coordinator (RN)

    Greentree Manor Nursing and Rehabilitation CenterChester, CT, US
    serp_jobs.job_card.full_time
    Greentree Manor Nursing and Rehabilitation Center is a trusted Skilled Nursing Facility committed to providing high-quality, person-centered care in a supportive and collaborative environment.We ar...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30