BI Analytics - Gurgaon, India - Indigo Airlines

Indigo Airlines

Verified Company

Gurgaon, India

1 week ago

Posted by:

Deepika Kaur

beBee Recuiter

Description

Job Description:

Should have technical experience in working on MSBI technologies - SQL Server Integration Services (SSIS), ETL Design, SQL Server Reporting Services (SSRS).

.NET Core experience

Delivery oriented attitude, Airport domain knowledge is required.

Onsite experience of activities like requirement gathering, coordinating with Offshore team, etc.

Rich experience in all stages of SDLC, including knowledge transition, requirement gathering, designing and documenting, development, testing, implementation, post-implementation support and following Quality.

Handled performance issues with source system by implementing looping in SSIS and reading only required partitions on source

Experienced in programming tasks-Stored Procedures, Triggers, Cursors using SQL Server 2012 with T-SQL.

Experienced in SQL code optimization and tuning using various best practices

Expertise in job scheduling using SQL Server Agent to perform hourly/daily/nightly updates

Expertise in generating different types of reports such as drill through/drill-down reports, parameterized reports, sub reports using SSRS.

Good experience in creating simple and complex ad-hoc reports using drilled through reports, cascading parameter and Grouping reports in SSRS.

Highly qualified in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE, Table Variables and strong knowledge of SDLC principles.

Skilled in performing data transfers between different heterogeneous systems (CSV, Flat Files, XML file, Database) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks.

Professional in usage of SSIS Control Flow items (for each Loop, execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Union all).

Hands-on experience on various tools like TFS, Jira, SVN, Asana, GitHub, Bit Bucket.

Good team player, strong interpersonal and communication skills combined with self-motivation, and initiative and quick learner.

Experience in Dimensional Data Modelling Star and Snow Flake Schemas.

Ability to work independently and as part of a team.

Excellent troubleshooting and problem-solving skills