Datastage, etl developer _ netacad advantage

Major Entertainment Company in Los Angeles is seeking a Senior ETL Developer for a 3 – 4 Month+ contract position. Database fundamentals Job description The job is to build a DataMart solution for one of the Application in TV Line of Business. Database concepts This role is for the ETL Developer who comes with hands on experience in different integration (ETL) tools like DataStage. Database icon Teradata experience in terms of understanding the MPP architecture, use of load utilities to process data is preferred.

Database versioning The Consultant will build a DataMart using data from different sources and considering the end reporting needs. Database 2013 Good understanding on data modelling especially physical data models to design the ETL mappings. Database cursor Will work with Business Users or Functional experts to identify the data sources for various reporting needs and construct data mapping rules from source to target DataMart. Database list The person will either come with Media Entertainment experience or will have a strong desire to learn. Database queries must be Expertise in Financial area is an added advantage. Database journal Should have good working experience in Agile development methodology. Data recovery boston Responsibilities include bull Interacting with Users and SMEs to understand reporting requirements and identify the data sources to fulfill those reporting requirements bull Develop source to target mappings bull Design, develop and test ETL data work flows. Database connection bull Building a reconciliation and exception processes to keep the data accurate for reporting and to keep checks and balances with source data bull Ensure to deliver optimized ETL design to achieve acceptable performance and utilize the database and ETL resources effectively bull Strong UNIX development skills to write wrapper scripts for scheduling ETL workflows bull Data analyst skills to determine root cause problems for data integrity and data quality issues identified through QA or by business report owners bull Working with Reporting teams to facilitate delivering the reporting solutions bull Should be able to estimate the work and provide delivery timelines bull 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. S memo data recovery 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. Database structure 10 Able to do Performance tuning of ETL jobs and reporting queries Qualifications bull 7+ of years of IT work experience and 4+ years in the similar role bull Hands on experience with DataStage is a must bull Data Warehouse database platforms ndashTeradata experience is a plus bull Knowledge on Business Objects and Tableau reportingdashboarding tools bull Knowledge and experience of at least one data profiling tool (experience with Information Analyzer is an added advantage) bull Experience on relational databases like Oracle bull Entertainment industry business models and data knowledge a plus bull Strong with data modeling concepts (star schemas, snowflake schemas, highly normalized data models), and familiarity with data modeling tools is an added advantage bull Familiar with physical database administration concepts such as table partitioning, materialized views, indexing strategies, aggregate navigation and their role within the decision support environment bull Familiar with source control tools such as SVN bull Excellent SQL programming skills bull Excellent problem solving skills bull Excellent communication skills with both business and technical customers bull Demonstrate a high level of integrity and maturity bull Escalate issues appropriately to management and project team bull Actively seek out feedback from management and peers, to improve own performance based on that feedback