Role: ETL Developer
Location: Chennai
Experience: 5+ years
Key Skills: ODI, OBIEEE, PowerBI
What will your role look like
- Build BI DW’s/performing Data Integration from source systems to EDW, ODS, BI Reporting solution systems using Oracle Data Integrator v.11g/10g (v 11.1.1.7/11.1.1.6 v/11.1.1.3/v.10.1.3.5)
- Implement complex business rules by creating ODI interfaces
- Analyze business requirement and design ETL flows accordingly
- Prepare unit test cases, test execution, and proof documentation
- Develop Slowly Changing Dimensions mappings using Change Data capture (CDC) Type1, Type2 and Type3 as a part of Performance Tuning
Why you will love this role
- Besides a competitive package, an open workspace full of smart and pragmatic team members, with ever-growing opportunities for professional and personal growth
- Be a part of a learning culture where teamwork and collaboration are encouraged, diversity is valued and excellence, compassion, openness and ownership is rewarded
We would like you to bring along
- Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services
- Experience on dealing with ODI Knowledge Modules like, LKM, IKM and JKM, CKM
- Experience in analyzing, requirement gathering, documenting and editing Business/User Requirements
- Proficient in using ETL Tools: ODI 12 C / 11g/10g, RDBMS: Oracle 11g/10g/9i/8i, OLAP Tools: OBIEE 11g/10g
- Expertise in programming languages: SQL, PL/SQL, C#, UNIX shell scripting, XML, HTML
- Expertise in Oracle Data Integrator and ETL loads
- Knowledge of ODI 12 C and other tools like OBIEE
- Excellent verbal and written communication skills
- Positive and fun attitude