IT - Business Intelligence(ETL Developer)

We have an immediate contract requirement for IT - Business Intelligence(ETL Developer) with one of our direct clients in San Francisco Bay Area, CA USA.

• 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 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 communications 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. - in E TL, XML parsing Y 8 5+
• Soft Skills -Good Communication Skills,
• Ability to discuss - project scope with business Y 7 5+
• Software Skills - in Shell Script, Sql Y 7 5+
• Technical Skills - in IBM Datastage, Unix, Oracle DB2 Datastage Y 9 7+