Job Description
We are seeking an ETL/ODI developer to join our data warehouse team based out of Hyderabad ODC. You are expected to have a minimum of 3+yrs experience in designing, implementing, customizing, and integrating DWH and ETL processes, and providing ongoing support and future enhancements of those solutions. You shall ensure the ETL/ODI mappings are designed to meet evolving business requirements and standards for accuracy, scalability and performance. Experience in any Big Data related technologies is an add-on.
Skills Required
- Complete Data warehouse lifecycle management
- Experience in design and implementation including data modeling for dimensional models
- Experience with normalized OLTP, MDM and dimensional modeling techniques, Star & Snowflake schemas, modeling slowly changing dimensions, dimensional hierarchies, and data classifications
- High level of experience in ETL/ELT implementation using ODI or Pentaho
- Strong design and development experience in Oracle SQL and PL/SQL
- Exposure to software development lifecycle and AGILE/Scrum practices
- Effective verbal and written communication skills with both technical and non-technical people
- Knowledge in data modeling tools like Oracle Designer, Erwin, TOAD, and DB Artisan, etc.
- Any Big data experience like Hadoop/Spark, Hive is a plus
Roles & Responsibilities
- Analyzing and understanding the source data
- Understanding the requirements for the target system
- Work with the reporting/analytics team to understand their reporting needs
- Understanding the OLAP process
- Creating Source to Target mapping documents
- Creating ETL routines to transform and load the data as per the specifications provided
- Writing unit-test cases as per the ETL logic
- Writing SQL scripts to execute the unit-test cases and validate the data
- Creating process flows to integrate he different ETL routines as per the modules
- Follow defined standards to improve the performance of the ETL routines
- Develop strategies for resolving issues and preventing future occurrences
Experience
3 6 years
Education Qualification
B.E/B. Tech/MCA