Team Lead, DWH/ETL/BI/Data Architect - 13863
Posted more than 30 days ago
Specialization:
Team Lead
Considering options
Full-time office work
Part-time work
Remote work (full-time)
Freelance (one-time projects)
Relocate
I have extensive team management experience, experience in banks development, in DWH development, experience of data analysis, system analysis skills, experience in developing operational and analytical reports.
Extensive team management experience.
- Extensive experience in Oracle Data Integrator. Designed and developed the Workflows, Mappings, Transformations and schedule the Workflows and Sessions.
- Interacted with end-users and functional analysts to identify and develop Business Specification Documents (BSD) and transform it into technical requirements.
- Strong experience with Oracle Data Integrator tools.
- Designed and development of database structure.
- Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse.
- Having strong hands on experience in extracting the data from various source systems ranging from Oracle, MSSQL, Flat Files, VSAM files, etc. to Oracle
- Designed and developed Dimensional Models using Star schema and Snowflake schema techniques used in relational, dimensional and multidimensional modeling.
- Worked on optimizing the mappings by creating re-usable transformations. Created debugging and performance tuning of sources, targets, mappings, transformations and sessions.
- Worked on Oracle BI reporting tool for Business reporting, Dashboard set up and end to end testing.
- Exposure in overall SDLC including requirement gathering, data modeling, development, testing, debugging, deployment, documentation, production support.
- Excellent analytical, problem solving and communication skills with ability to interact with individuals at all levels.
- Experience in CI/CD implementation
- Experience to technical leadership to teammates through coaching and mentorship
Similar candidates