Salary5 - 9 INR (PA)
Job TypeFull Time
Job Location Bangalore,Karnataka,India

Skills

INFORMATICA ORACLE
Experience
4 to 8 Years
Industry
IT - Software Services
Functional Area
HR / Admin / PM / IR / Training
• Prepare functional and technical documentation for data warehouses
• Write new programs or modify existing programs to meet customer requirements, using ODI or OWB Tools(knowledge in other ETL tools and keen learning new tools is also preferred)
• Implement business rules via stored procedures, or through ETL tool
• Design and develop new reports and able to modify existing reports using QlikView (or knowledge on similar BI reporting tool)
• Provide Production-Support for a data warehouse environment and able to co-ordinate between different teams both onsite and offshore to meet the SLA
• Able to troubleshoot ETL issues both at a Data level and Functional level and provide Root Cause Analysis (RCA)
• Able to configure, create, manage and monitor jobs in Scheduling tool such as Tidal
• Analyze the performance of the Oracle jobs and able to suggest and implement performance enhancement techniques
• Ready to work in different shift timings as per the schedule
• Ready for onsite travel for short periods
• Review designs, codes, test plans, or documentation to ensure quality
• Verify the structure, accuracy, or quality of warehouse data
• Select methods, techniques, or criteria for data warehousing evaluative procedures
• Map data between source systems, data warehouses, and data marts
• Design and implement warehouse database structures
• Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow
• Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing
• Develop data warehouse process models, including sourcing, loading, transformation, and extraction
Required Skills Set
• Minimum 3 Years of ETL experience in with good hands on knowledge on ETL
• Tools - Oracle Data Integrator (ODI) or Oracle Datawarehouse Builder (OWB) Informatica (or similar ETL tool)
• Minimum 1 Year of Reporting experience in QlikView (or similar tool)
• Good knowledge on Datawarehouseconcept
• Involved in at least 1 end-to-end Datawarehouse project cycle
• Experience/Knowledgeon 1 or more Scheduling tool like Tidal
• Experience in scrum methodology is an added advantage

Company
Citagus Software Private Ltd
Location
Citagus Software Private Ltd
623, Balaji Arcade, 80 feet road, koramangala, Bangalore -560034
Website
http://careers.citagus.com
 
View Jobs By This Company

Looking for Talent ?

Find the right people, Hire them now


Post a Job, It's Free

Get Matching Jobs in your Inbox

(No Registration Needed)


Create a Job Alert

Similar Jobs