Job Description :
Education and qualifications:
BA/BS degree in Computer Science, MIS, or related field required
Minimum of 7+ years’ experience in data warehouse ETL/BI development, preferably utilizing Oracle Data Integrator.
Advanced knowledge of ETL development tool Oracle Data Integrator a must, particularly within OBIEE (Oracle BI Enterprise Edition
Knowledge of data warehouse, data governance, and data quality concepts
Exposure to Financial reporting and Accounting concepts.
Database knowledge in Oracle 9i and above, including SQL and performance tuning.
Ability to translate functional requirements into technical deliverables/solution, and then work towards architecture, development, unit testing, UAT migration and QA testing support, Prod cut-over, and providing support during warranty phases of the projects
Proficient in MS Office (Word, Excel, Outlook, Power Point, Project)
Able to communicate technical solutions to business stakeholders
Strong communication skills both verbal and written
Excellent organizational and data analysis skills with attention to details
Excellent analytical, problem solving, time management and interpersonal skills
Must be able to work independently and as part of a team
Primary responsibilities:
Assess, develop, and deploy ETL/BI technical deliverables utilizing Oracle Data Integrator within Client’s BI realm; take into account necessary mappings, procedures, packages and scenarios required to deliver towards current projects and future footprint
Leverage EPMO established framework, PM, BA, and Tech Leads to ensure all project deliverables, including Solution Architecture, are delivered
Design ODI/ETL mappings and flows by interacting with the in-house BI technical Lead, business analyst and other team members
Tune ETL processes and provide assessment/resolution of the performance issues
Create deployment artifacts for migration of the solution on various environments following the stages of the project
Provide documentation on all above deliverables
Serve as Technical SME for ETL processes throughout the delivery. Work closely with Marketing, Finance, Supply Chain, ELOA, and other parties involved