This site uses cookies. To find out more, see our Cookies Policy

Senior Business Analyst/Assistance Manager – ETL + BI (3-7 years) in Gurugram at Crescendo Global

Date Posted: 8/6/2018

Job Snapshot

  • Employee Type:
    Full-Time
  • Location:
    Gurugram
  • Job Type:
  • Experience:
    3 to 7 years
  • Date Posted:
    8/6/2018

Job Description


A challenging opportunity to deep dive in the area of data analytics. Exploring tools like SSIS, Informatica, cognos, oracle database, AB Initio and being an expert in R and Python. Data modelling, data extraction, transformation, loading, mining, data ware housing, business intelligence. Proving insights and making the sense out of data.

LOCATION:

Gurgaon

YOUR FUTURE EMPLOYER:

A leading, global firm providing creative and strategic analytics, IT and consulting solutions for the entire enterprise value chain.

YOU WILL BE RESPONSIBLE FOR:

  • Application designing, development and implementation of Informatica PowerCenter 10.x/9.x/8.x, Oracle 12c/11g/10g, IBM DB2, UNIX, Cognos 10, MS SQL Server 2012/2008, SSAS OLAP cubes, IBM Datastage 11.x/8.5, Informatica IDQ, SSIS
  • Building data models using R or Python
  • Developing new Graphs and Plans. 
  • Good working experience with the components of Ab initio. Creating, Executing, Testing and maintaining the graphs in Ab initio.
  • Preparation of documentations for all the developed codes.
  • Good understanding about Fact and Dimension tables.
  • Good understanding of data warehouse environment and data models
  • Developing seventy BO reports in first phase for Credit Risk using two universes based on SSAS cube and Oracle database.
  • Participate in business, detail design and technical documentation for ETL standards, procedures and naming conventions, worked under the ETL process.



Job Requirements

THE SUCCESSFUL CANDIDATE:

  • 3-7 years of experience in SSIS/informatica/cognos/oracle DB/ Ab initio and R or Python
  • Bachelors of engineering, statistical or maths
  • Extensive handson experience in designing and developing Business Applications using Informatica, SSIS and AbInitio as ETL tool, and Business Objects as the Reporting tools with Oracle, Teradata and DB2 Database.
  • Excellent coding experience in R or Python
  • Strong Technical Knowledge in AbInitio, Business Objects Universe Designing and Report Development, SSIS, Sql, Oracle, MS-SQL Server
  • Data Warehousing using SAP Business Objects, Ab Initio, Informatica, SSIS, SQL, PL/SQL
  • Knowledge on using other ETL tools like Informatica and Business intelligence tools like IBM Cognos.

WHAT IS IN IT FOR YOU:

  • An opportunity to work with a blue–chip firm in a high visibility role as a part of the analytics team
  • A meritocratic culture with great career progression.
  • Fast track career growth.

REACH US:

If you think this role will add value to your career, kindly write me an email along with your updated CV on nikitasharma@crescendogroup.in or contact me on 7087413515 for a confidential discussion on the role


CHECK OUT OUR SIMILAR JOBS

  1. Business Analyst Jobs
  2. Systems Analyst Jobs