Jobs
>
Frankfort

    Technical lead - Frankfort, United States - HCL Technologies

    HCL Technologies
    HCL Technologies Frankfort, United States

    3 weeks ago

    Default job background
    Description


    Having 11+ years of professional experience in Data-warehouse, SQL Server Development and BI tools (SSIS, SSRS, SSAS) and Power BI.

    Having good experience over T-SQL statements and having three years of experience in pl/sql.
    Created stored procedures, triggers, UDFs, views, tables, and generated T-SQL script for application.

    Design and Configure new Pizza, Sides, beverage products using Webtools and Crafter and Design, Develop & Test Enhancements for new products & Promotions configuration Changes on web applications.

    Good understanding in Data Marts and Data Warehousing concepts (OLTP & OLAP) and worked with Data mining and slowly changing dimensions (SCD).

    Extensive experience in database tuning, server logins and database permissions.
    Creating and monitoring jobs for automating daily tasks like backups, checking integrity of databases, updating statistics.

    Experience in creating and managing fragmentation of Indexes to achieve better query performance that increases my ability in Performance Tuning, Query Optimization.

    Experience in building Star schema and Snowflake schema depending on business requirements.

    Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data base applications.

    Manage SSIS packages, stored procedures, jobs, and utilize Server-Side tracing to identify performance issues with deadlocks & other locking issues.

    Proficient in designing and developing SSRS reports such as Parameterized, Linked, Snapshot, Cached, Ad-hoc, Click-through, Drill-down, Drill-through, and Sub reports.

    Working with sql server agent jobs to call and schedule SSIS packages.

    Generated various reports using Power BI desktop and shared them using Power BI Service to the decision makers in the organization for strategic planning.

    Explored data in a variety of ways and across multiple visualizations like Pie Chart, Bar Charts, Donut Chart and Line Graphs etc.

    using Power BI.
    Strategic expertise in design of experiments, data collection, analysis and visualization.

    Utilized slicers and various filters to create different analytical dashboards that depicts critical KPIs enabling end users to make interactive analysis.

    Experience in creating Calculated Columns and Calculated Measures using various DAX queries as part of the Data modelling in Power BI reports.

    Implemented Power BI On-Premises data gateway for multiple users to share and analyze Power BI reports and Dashboards.
    Working knowledge in Agile/Scrum Environment and used TFS team foundation server for source control.
    Excellent skills in understanding business needs and providing technical solutions.

    Good experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS).

    To ensure process compliance in the assigned module, and participate in technical discussionsorreview as a technical consultant for feasibility study (technical alternatives, best packages, supporting architecture best practices, technical risks, breakdown into components, estimations).

    To prepare and submit status reports for minimizing exposure and risks on the project or closure of escalations.
    To develop and guide the team members in enhancing their technical capabilities and increasing productivity

    To be responsible for providing technical guidance or solutions ;define, advocate, and implement best practices and coding standards for the team.

    #J-18808-Ljbffr


  • Diverse Lynx Frankfort, United States

    Role name: · Technical Lead · Role Description: · Responsibilities: · •Lead and own all technical aspects of ETL projects from requirement till implementation. · •Strong technical skills in Ab Initio, UNIX shell scripting, SQL(Teradat & Hadoop) and other scheduling tools. · •H ...


  • Oracle Frankfort, United States

    Oracle · Consulting Technical Manager, HCM Cloud, Integration Lead · Frankfort , · Kentucky · Apply Now · Consulting Technical Manager, HCM Cloud, Integration Lead · Location, United States, Remote/Travel · Oracle's mission is to help people see data in new ways, discover in ...


  • TCI Technology Consulting Inc Shelbyville, United States

    TCI has an immediate need for a Technical Support Manager in Shelbyville, KY. This is not a Corp2Corp opportunity. This is a Direct Hire opportunity. · SUMMARY · The Technical Support Manager will support a national LED sign company whose products are installed at retail shopping ...


  • Atlas Dynamics Frankfort, United States

    Frankfort GA-tec Building and Plant Technology GmbH, a subsidiary of the Sodexo Group, is one of the leading providers of technical building equipment and technical facility management. With more than 1200 employees from numerous branches throughout Germany, we continuously striv ...


  • Radiant Ventures Frankfort, United States

    As a transmission system operator, we ensure the electricity supply for 11 million people - and ensure the success of the energy transition. Around 1,300 employees make our region ready for the future with a dynamic, intelligent grid and turn Baden-Württemberg into an innovative ...

  • Frankfort Regional Medical Center

    Rn Step Down

    1 week ago


    Frankfort Regional Medical Center Frankfort, United States

    **Introduction**: · Do you have the career opportunities as a(an) RN Step Down you want with your current employer? We have an exciting opportunity for you to join Frankfort Regional Medical Center which is part of the nation's leading provider of healthcare services, HCA Healthc ...

  • Frankfort Regional Medical Center

    Rn Step Down Prn

    1 week ago


    Frankfort Regional Medical Center Frankfort, United States

    **Introduction**: · Do you want to join an organization that invests in you as a(an) RN Step Down PRN? At Frankfort Regional Medical Center, you come first. HCA Healthcare has committed up to $300 million in programs to support our incredible team members over the course of three ...


  • Bird Control Group Lexington, United States

    Full-time, Eastern USA, remote · Because of you, our Technical Service team works effectively and efficiently, and the installations of our systems for effective, environmentally friendly bird deterrents are done perfectly You know how to install in the field, solve problems on ...


  • Booz Allen Hamilton Lexington, United States Full time

    Job Number: R0193741 · Technical Program Manager, LeadKey Role: · Design, implement, and maintain strategic, multi-disciplinary IT programs in support of corporate strategy. Apply leading-edge principles, theories, and concepts, and contribute to the development of new principle ...

  • Kentucky Personnel Cabinet

    Systems Engineer IT

    2 weeks ago


    Kentucky Personnel Cabinet Frankfort, United States

    Advertisement Closes 5/31/2024 (8:00 PM EDT Systems Engineer IT Pay Grade17 Salary $4, - $6, Monthly Employment Type EXECUTIVE BRANCH | FULL TIME | INELIGIBLE FOR OVERTIME PAY | 18A | HR/WK Hiring Agency Education & Labor Cabinet | Department of Education Location 300 Sower Boule ...


  • Sazerac Company Frankfort, United States

    Job Description/Responsibilities: Responsible for managing the departmental activities of bottling operation. Leads, plans, and directs the resources to meet safety expectations, production requirements, continuous improvement project activities, and stretch targets for the depar ...


  • Sazerac Company Frankfort/Kentucky/US, United States

    Job Description/Responsibilities: Responsible for managing the departmental activities of bottling operation. Leads, plans, and directs the resources to meet safety expectations, production requirements, continuous improvement project activities, and stretch targets for the depar ...

  • Kentucky Personnel Cabinet

    Systems Consultant IT

    2 weeks ago


    Kentucky Personnel Cabinet Frankfort, United States

    Advertisement Closes 5/30/2024 (8:00 PM EDT Systems Consultant IT Pay Grade17 Salary $4, - $6, Monthly Employment Type EXECUTIVE BRANCH | FULL TIME | INELIGIBLE FOR OVERTIME PAY | 18A | HR/WK Hiring Agency Education & Labor Cabinet | Department of Education Location 300 Sower Bou ...

  • Kentucky Personnel Cabinet

    Staff Attorney III

    3 weeks ago


    Kentucky Personnel Cabinet Frankfort, United States

    Advertisement Closes 5/16/2024 (8:00 PM EDT Staff Attorney III Pay Grade18 Salary $6, - $7, Monthly Employment Type EXECUTIVE BRANCH | FULL TIME | INELIGIBLE FOR OVERTIME PAY | 18A | HR/WK Hiring Agency Energy & Environment Cabinet | KY Public Service Commission Location 211 Sowe ...


  • Fortive Corporation Frankfort, United States

    Job Description - Senior Manager, Global Tax Controversy (FOR001211)Job DescriptionSenior Manager, Global Tax Controversy · - · FOR001211About Us · : · Fortive Corporation OverviewFortive's essential technology makes the world stronger, safer, and smarter. We accelerate trans ...

  • Frankfort Regional Medical Center

    RN Step Down

    2 weeks ago


    Frankfort Regional Medical Center Frankfort, United States HOS

    Description · Introduction · Do you have the career opportunities as a(an) RN Step Down you want with your current employer? We have an exciting opportunity for you to join Frankfort Regional Medical Center which is part of the nation's leading provider of healthcare services, H ...


  • Frankfort Regional Medical Center Frankfort, United States HOS

    Description · Introduction · Do you have the career opportunities as a(an) Radiology Technician you want with your current employer? We have an exciting opportunity for you to join Frankfort Regional Medical Center which is part of the nation's leading provider of healthcare ser ...


  • Kerry Automotive Group Frankfort, United States

    Job SummaryKerry Automotive is seeking an Automotive Service Advisor to join our growing team in Florence, Kentucky. This person will be responsible for individual customer service during a service visit, set up complete and accurate estimates for vehicle repairs and work as part ...


  • Kalepa Insurance Services, LLC Frankfort, United States

    AVP, Surety Underwriting Officer or VP, Senior Underwriting Officer · 108148 · Zurich is currently looking for a · Surety AVP · Underwriting Officer or VP, Senior Underwriting Officer, to join our North Central Contract Surety team in Indianapolis, IN. Although our preference ...


  • Frankfort Regional Medical Center Frankfort, United States

    Description · Introduction · Do you currently have an opportunity to make a real impact with your work? With over 2,000 sites of care and serving over 31.2 million patient interactions every year, nurses at Frankfort Regional Medical Center have the opportunity to make a real im ...