Title: Business Intelligence (ETL Developer)
Location: REMOTE
Duration: 12 months
Job Description
- Responsible for the design and implementation of data mart models.
- Map source system models and data mart models. Designs, develops and maintains ETL code.
- Defines and captures metadata and rules for ETL. Defines and develops ETL Validation code. Source system understanding and profiling.
Skill Set
- BS/MS in Computer Science or equivalent. Dimensional modeling experience.
- 2 years hands-on experience in a large-scale, high-availability data warehouse.
- Hands-on experience with SQL and Oracle.
- Experience in writing complex transformation logic in PL/SQL to implement ETL business rules.
- Experience with STAR schema design.
- Hands-on working knowledge of Oracle PL/SQL.
- Experience and Knowledge of SQL performance tuning in Oracle environment.
- Experience with software development life cycle.
- Strong problem-solving skills.
- Ability to adapt quickly in a rapidly changing environment while working closely with users and lead cross-functional teams.
- Experience with Datastage ETL Tool is a plus.
- Experience with MicroStrategy is a strong plus.
- Must be self-motivated.
- Must possess excellent problem-solving capabilities.
- Must be able to handle and achieve completion on multiple projects and priorities simultaneously.
- Must have excellent oral and written communication skills. Work experience in an Agile development environment is a plus.
Category Skill names Required (Y/N) Importance (1 thru 9 scale) Experience (in years) Area Of expertise ETL, XML parsing Y 8 5+
Soft Skills Good Communication Skills, Ability to discuss project scope with business Y 7 5+
Software Skills Shell Script, SQL Y 7 5+
Technical Skills IBM Datastage, Unix, Oracle, and DB2 Datastage Y 9 7+
#TB_EN
Job #: 24-15505