morgenall-logo

Business Intelligence Data Integrator/ETL Developer / 5 - 7 Years / Bangalore

Bangalore

Posted 11 Jan 2018 (164 days ago)


Job Description

Job Responsibilities
 
 Responsible for design and development of data integration processes.   Work centers on the transformation of various production and corporate data sources into to the enterprise data warehouse.  Responsible for analyzing source systems for transition and acquisition of data to the enterprise data warehouse  Define a suitable architecture for data integration from multiple, disparate data sources (including legacy systems, relational databases, and XML/JSON/ASCII files).  Define and implement the required business transformation rules and logic to the ETL scripts to load the data warehouse  Design and develop exception handling and data cleansing / standardization procedures  Work directly with users of data and support personnel to ensure optimal ETL performance and adherence to data quality standards  Design /Develop various enterprise reports/Dashboards using open source BI tools 
 
Required:     Five plus years experience in data warehousing, data modeling and data integration for enterprise data environments.     Experience  in design of large scale ETL solutions integrating multiple / heterogeneous  systems     Experience in data analysis, modeling ( logical and physical data models)  and design specific to a data warehouse / Business Intelligence environment (normalized  and multi dimensional modeling)     Experience with ETL tools primarily Talend and/or any other Data Integrator tools (Open source / proprietary), extensive experience with SQL and SQL scripting (PL/SQL & SQL query tuning and optimization) for relational databases such as PostgreSQL, Oracle, Microsoft SQL Server and MySQL etc., and on NoSQL like MongoDB and/or document based databases.       Experience with Linux / Unix / Windows platforms  Good understanding of overall data warehouse design principles and best practices.  Bachelor’s degree in Computer science/Engineering, management information systems or equivalent additional experience business administration, finance.  Must be detail oriented, highly motivated and work independently with minimal direction.  Excellent written, oral and interpersonal communication skills with ability to communicate design solutions to both technical and non-technical audiences.
 
Desired 
 Experience with Open source BI reporting tools primarily SpagoBI   Experience on any scripting languages – Python, Perl, JavaScript and shell etc.  Experience in Configuration / Change management tools (esp. JIRA/Remedy/Mercurial etc.)  Worked in product organizations  Technical/Business Skills and Knowledge in Healthcare industry/HL7  Experience in No-SQL/ Big Data environment is highly desirable   Experience with programming web applications with Java, specifically with Servlets and JSP


Key Skills

ETL, SQL, Data Integrator


Industry

Information Technology And Services

Employment Type

Full Time

Job Function

Information Technology


Experience Required

5 - 7 Years


No Of Positions


Salary Offered

INR 0 - 0


Interview Locations

Client Location - Not Mentioned(Interview Mode - Face 2 Face)


Also Matched Jobs


Senior PL/SQL Developer

Not Mentioned,India

Posted 08 Jun 2018(16 days ago)


Wind chill

Not Mentioned,India

Posted 04 Jun 2018(20 days ago)


Enovia

Not Mentioned,India

Posted 04 Jun 2018(20 days ago)


Web SQL - Team Lead

Not Mentioned,India

Posted 09 May 2018(46 days ago)


PostgresSQL developer

Not Mentioned,India

Posted 09 May 2018(46 days ago)