CIEL HR Services Looking for CIEL/SEL/24166: IT Analytics – Asst Manager/ Sr Executive at Ahmedabad, Gujarat Full Time

Dear Candidates,

We are looking for IT Analytics – Asst Manager/ Sr Executive, One of the best Pharma company in Ahmedabad.

Roles & Responsibilities :
ETL

1· Analyse and translate business requirement into technical solution

2· Design & Develop ETL Jobs scheduling, debugging, troubleshooting errors/ exceptions, calling function module/RFC using SAP BODS

3· ETL maintenance and regular job monitoring

4· Troubleshooting for job failures and fixtures.

5· Testing the ETL back with legacy data (SAP)

6· Maintain up-to date documentation of design, implementation and ETL process

7· Backup and Managing of local and central repository

8 Experience in DCD, Full Load, Incremental Load

PowerBI

1· In-depth understanding of database management system, OLAP , ETL framework and DAX expression

2· Strong knowledge of SQL queries and DAX expression

3· Solid exposure to Microsoft .net and Microsoft technologies

4· Excellent knowledge connecting PowerBI desktop with various data sources

5· Designing and creating reports, dashboards, presentation, and graphs.

6· Ability to work independently to implement a solution with minimal guidance

7· Experience in data gateway data refresh, content packs (or apps)

Python

1· Writing scalable code using Python programming language

2· Integrating the python code with backend and front-end

3· Scheduling of python code

4· Knowledge of python packages and data science algorithms to implement analytics requirements like forecasting,

Essential

1· Strong Experience (4+ years) in ETL activities

2· Should have experience in designing and developing DWH using SAP or legacy system

3· Strong in writing SQL and PL-SQL Statements

4· Knowledge of Sybase and SQL Server is desirable.

5· Around 4+ years, Experience in PowerBI, PowerPivot, Power Query

6· Expert in OLAP, SQL server, SQL Data Warehouse, Azure Cloud services and toolsets Azure Data Factory, Databricks, Analysis Services etc. Exposure of SAP Business warehouse, HANA and related technologies

7· Master data management and Data Quality exposure to set up enterprise wise MDM framework and delivery solutions to keep master data clean and updated and have clear policies and governance for master data management

8· Flexible to learn new tools and technologies in short period of time and implement the same to solve real-time business problems.

Qualification – Bachelor’s degree, preferably in Software Engineering,

Information Systems, Computer Science, or related IT discipline.

Experience – 6 to 8 Years, Salary Range – 7 to 10 LPA