SAP Data Services (also called Data Integrator) - CO..

Role: SAP Data Services (also called Data Integrator)

 Denver CO 

8 PLUS months  duration.

Skype

# of positions: 3

· Experience with full lifecycle activities with SAP Data Services (also called Data Integrator) – ETL design, data modeling and scheduling jobs

· Designed and developed Data Services jobs to load data into dimension tables and implemented Slowly Changing Dimensions

· Worked with transformations like Query, History Preserving, Table Compare, Map Operation, Map_CDC_Operation

· Understand the concept of pushdown SQL for performance

· Used Lookup function to populate fields from other tables

· Implemented initial (Full) and delta (Incremental) load for Fact tables

· Fully understand CDC (Change Data Capture) used in Data Services and native to RDBMS platform

· Tested the data for correctness using SQL queries

· Created complex SQL queries and optimized the performance of the queries

· Created new indexes on tables to optimize job performance and designed the job accordingly

· Used the Data Services interactive debugger to troubleshoot errors and monitor the data at various points in a job

· Documented the projects using Auto-Documentation Feature

Questions

• Information Steward significantly - along with Data Quality and Data Profiling ?
• Self-rating on reading datamodel on the scale of 1 to 10: ?
• How much experience with Oracle, SQL Server, DB2 ?
• PL/SQL experience ?
• What is the  difference between local and central repositories?
• How to use ATL files and how to promote between Dev/QA/etc.?
• What is  Datastore /System Configuration and how too export/import them when promoting across environments?
• What is Projects/Jobs/WorkFlows/DataFlows : ?
• Knows Scripts and Data flows can show up in Workflow ?
• What are Conditionals and While Loops in Work flows?
• Transforms in a DataFlow: ?
• Explain Map Operation Transform: ?no idea
• How to used Data Transfer Transform to improve performance by leveraging pushdown SQL -exp
• Should know the concept of pushdown SQL (database engine executing vs job server doing the heavy lifting)
• How to use Display Optimized SQL
• Should be able to Explain all types of slowly changing dimensions ?
• Should Know Query/Table Comparison/History Preserving/Key Generation transforms for Type-2 SCD...
• Explain lookup functions (Lookup, Lookup_Seq, Lookup_Ext) and should know using JOIN as an alternative
• Should have worked on  SQL Transform currently
• Knows Target Tables are physical...couldn't really explain Template Tables
• Understands Try/Catch concept and explained how to raise exceptions and send emails.
• Should be good in Performance Tuning and should not  struggle in explaining different techniques (number of rows to fetch, pushdown SQL)
• Should know Target Based Change Data Capture
• Should know Source Based or features within Data Services
• Should Know how to create documentation, schedule jobs, review log files, and assign rights within Management Console

 

Regards,

Manju Shree

Sr IT Recruiter
IDC Technologies, Inc. 1851 McCarthy Boulevard, Suite 116,Milpitas, CA, USA, 95035
Phone: 408-418-5779 ext 1012 |Fax: 408-608-6088 |

Email: manju@idctechnologies.com| Web: www.idctechnologies.com

 

--
You received this message because you are subscribed to the Google Groups "SureShotJobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to sureshotjobs+unsubscribe@googlegroups.com.
To post to this group, send email to sureshotjobs@googlegroups.com.
Visit this group at http://groups.google.com/group/sureshotjobs.
For more options, visit https://groups.google.com/d/optout.