Lead
Raytheon Technologies
Embassy Tech Village, th Floor Building B, Marathahalli, Devarabeesanahalli Village, Varthur Hobli, Bangalore, India
5d ago

Overview

At Collins Aerospace, we work side-by-side with our customers to tackle the toughest challenges in aerospace and defense.

We’re combining boundless imagination with a broad portfolio and an unmatched dedication to customers all to make the skies and spaces we touch smarter, safer and more amazing than ever.

We are redefining aerospace. Collins Aerospace is looking for a highly motivated self-starter and a change agent with experience and desire to drive the organization to be successful on BI, T-SQL, SSIS ETL development.

In-depth understanding of SQL relational database design, ETL processing, and Data Warehouse. As a Business Intelligence Developer, you will be responsible for becoming a key player in various BI initiatives in support of key business strategies.

The individual will participate in designing, developing and maintaining various BI solutions primarily in Microsoft and SAP environments.

The person will be responsible for adhering to our agile processes, producing quality artifacts and managing BI solutions through the entire development life cycle.

Job Title :

Lead - Business Intelligence Analyst

Job responsibilities

  • Responsible for gathering and analyzing requirements from business users and creating technical specification documents (design documents, flow chart, and relationship diagram) for the report.
  • Designing databases and ensuring their stability, reliability, and performance.
  • Design, create and implement database systems based on the end user's requirements.
  • Develop database schemas, tables, dictionaries, indexes, stored procedures and triggers.
  • Memory management for database systems.
  • Responsible for scheduling the reports to run automatically.
  • Used ETL (SSIS) to develop jobs for extracting, cleansing, transforming and loading data into the data warehouse.
  • Test databases and perform bug fixes.
  • Execution Plan, SQL Profiler and Database engine tuning advisor to optimize queries and enhance the performance of databases.
  • Provide end-user support, release / upgrade management, testing, and user training.
  • Qualifications :

  • Engineering graduate with 2+ years of experience with T-SQL development.
  • Strong knowledge of SQL, MS SQL Server, SSRS, and SSIS.
  • Knowledge of data warehousing (DW / BW) concepts and ETL process.
  • Design and manage databases, including database objects.
  • Light database administration skills; indexing, performance tuning, optimization, etc.
  • Ability to write efficient, complex queries against very large data sets.
  • Ability to model, analyze and manage large volumes of data.
  • Configure SSIS Package for run time parameters and configuration file.
  • Conversant with migration / up-gradation process of MS SQL Server, SSIS and SSRS.
  • Experience in using third party scheduling tools such as TIDAL for SSIS.
  • Experience in any real-time replication tool, such as Attunity or SAP SLT.
  • Experience in the development of SAP BW / SAP HANA or TERADATA systems.
  • Experience in any other ETL Tools (Informatica / SAP Data Services / Data Stage) and BI tools is an advantage.
  • Collins Aerospace, a Raytheon Technologies company, is a leader in technologically advanced and intelligent solutions for the global aerospace and defense industry.

    Collins Aerospace has the capabilities, comprehensive portfolio and expertise to solve customers’ toughest challenges and to meet the demands of a rapidly evolving global market.

    The next chapter of our future as an aerospace company is here, and we are excited about what this means for our employees and customers! Get onboard the Collins Aerospace Operations team and play a part in managing our innovative products from inception to delivery.

    The Operations team continues to grow and aims to strengthen the connection of Manufacturing Operations, Supply Chain and Environment, Health & Safety (EH&S) across Collins Aerospace.

    In this dynamic environment, you will have the opportunity to network across our businesses and functions, all while improving the productivity, quality and efficiency of our operations worldwide.

    Collins Aerospace Diversity & Inclusion Statement :

    Diversity drives innovation; inclusion drives success. We believe a multitude of approaches and ideas enable us to deliver the best results for our workforce, workplace, and customers.

    We are committed to fostering a culture where all employees can share their passions and ideas so we can tackle the toughest challenges in our industry and pave new paths to limitless possibility.

    WE ARE REDEFINING AEROSPACE.

    Some of our competitive benefits package includes :

    Benefits package includes :

  • Transportation facility.
  • Meal coupons
  • Group Term Life Insurance.
  • Group Health Insurance.
  • Group Personal Accident Insurance.
  • Entitled for 22 days of vacation and 7 days of contingency leave annually.
  • Employee scholar programme.
  • Work life balance.
  • Car lease programme.
  • National Pension Scheme
  • Fuel & Maintenance / Driver wages
  • Meal vouchers
  • Nothing matters more to Collins Aerospace than our strong ethical and safety commitments. As such, all India positions require a background check, which may include a drug screen.

    Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form