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


Posted 11 Jan 2018 (401 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.
 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


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

Java Development Lead


Posted 05 Jul 2018(226 days ago)

DotNet Developer


Posted 05 Jul 2018(226 days ago)



Posted 28 Jun 2018(233 days ago)

Data Architect

Not Mentioned,India

Posted 28 Jun 2018(233 days ago)

Senior PL/SQL Developer

Not Mentioned,India

Posted 08 Jun 2018(253 days ago)