*Title: ETL DataStage role,* *Location: Culver City, CA 90232(southern California)*
*Length: 3 month contract* *Phone then F2F* The job is to build a DataMart solution for one of the Application (C2C) in TV Line of Business. This role is for the ETL Developer who comes with hands on experience in different integration (ETL) tools like DataStage. Teradata experience in terms of understanding the MPP architecture, use of load utilities to process data is must. Build a DataMart using data from different sources and considering the end reporting needs. The person will either come with Media & Entertainment experience or will have a strong desire to learn. Expertise in Financial area is an added advantage. Should have good working experience in Agile development methodology. *Responsibilities include:* • Interacting with Users and SMEs to understand reporting requirements and identify the data sources to fulfill those reporting requirements • Develop source to target mappings • Design, develop and test ETL data work flows. • Building a reconciliation and exception processes to keep the data accurate for reporting and to keep checks and balances with source data • Ensure to deliver optimized ETL design to achieve acceptable performance and utilize the database and ETL resources effectively • Strong *UNIX* development skills to write wrapper scripts for scheduling ETL workflows • Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners • Working with Reporting teams to facilitate delivering the reporting solutions • Should be able to estimate the work and provide delivery timelines • Should be familiar with *HADOOP or any other BI Cloud technologies like Snowflake etc * *Core Responsibilities:* 25 % Understands the business requirements and translates them into Technical requirements. 50% Develop the ETL mapping docs, design ETL work flows and develop the same 15% Understands the basic needs of reporting and help reporting teams design the reporting layers. 10% Able to do Performance tuning of ETL jobs and reporting queries *Qualifications:* 8+ of years of IT work experience and 5+ years in the similar role • Hand on experience with DataStage and *Teradata is must* • Data Warehouse database platforms –Teradata experience is must • Knowledge on *Business Objects and Tableau reporting/dashboarding tools* • Knowledge and experience of at least one data profiling tool (experience with Information Analyzer is an added advantage) • Experience on *relational databases* like *Oracle* *• Entertainment industry* business models and *data knowledge a plus* • Strong with data modeling concepts (star schemas, snowflake schemas, highly normalized data models), and familiarity with data modeling tools is an added advantage • Familiar with physical database administration concepts such as table partitioning, materialized views, indexing strategies, aggregate navigation and their role within the decision support environment • Familiar with source control tools such as* SVN* • Excellent *SQL programming* skills • Excellent problem solving skills • Excellent communication skills with both business and technical customers • Demonstrate a high level of integrity and maturity • Escalate issues appropriately to management and project team • Actively seek out feedback from management and peers, to improve own performance based on that feedback · *Media and Entertainment background* Priyanka Katiyar Technical Recruiter Nityo Infotech Corp. Direct: 609-378-1139 Email: priyanka.kati...@nityo.com Gtalk: puja123h...@gmail.com -- You received this message because you are subscribed to the Google Groups "SAP Workflow" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-workflow+unsubscr...@googlegroups.com. To post to this group, send email to sap-workflow@googlegroups.com. Visit this group at https://groups.google.com/group/sap-workflow. For more options, visit https://groups.google.com/d/optout.
