Keys to the role are: strong Informatica/ETL development, strong SQL query skills, and experience with Teradata.
In-person interview required *Consulting Assignment Duration: *10-12 months *Location: *NYC *Title: *ETL Developer *Position Summary:* The ETL developer, Royalty, is responsible for the data integration to support royalty data processing. The royalty data integration includes but not limited to, • Metadata Systems. • Playlist data for Live. • Playlist data for OnDemand Shows. • Playlist data for Third Party Shows. • Streaming data from various sources. Work closely with ETL Manager, ETL Developers and various business stakeholders to support and provide quality of delivery for data extraction, transformation and load needs through the development of new and/or enhancement of existing routines, or the management of contractor-sourced resources. Also implement quality control and audit practices to ensure continuous improvement of assets. *Position Responsibilities:* • Work with various business stakeholders to identify their information needs. • Work with Data Architecture team to understand the source and target data models. • Work closely with cross-functional business and business intelligence teams to document ETL requirements and turn them into ETL jobs. • Develop and be a proponent for Data Warehouse development standards, including ETL standards and best practices. • Provide documentation for all developed ETL processes, including process flow and source and target mapping. • Conduct ETL performance tuning and troubleshooting. • Work with Business Intelligence Operations team to ensure control objectives are implemented for all data movement processes, implement change control for production data, establish and follow proper incident management procedures. • Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data. *Requirements:* • Experience in writing complex SQLs to analyze and troubleshoot the issues/problems. • Strong data analysis and troubleshooting skills. • Experience in integrating technologies with internal and external data sources. • Goal oriented and creative personality with good interpersonal skills. • Ability to manage multiple assignments simultaneously and follow up on unfinished business. • Ability to work independently and in a team environment. • Ability to pay attention to the details and be organized. • Commitment to internal client and customer service principles. • Willingness to take initiative and to follow through on projects. • Excellent time management skills, with the ability to prioritize and multi-task in a fast-paced environment. • Excellent communication and motivation skills, and ability to interact appropriately with senior level colleagues and business users. *Minimum Qualifications:* • Bachelor’s Degree or higher or relevant equivalent experience. • Minimum of 5 years of experience in ETL development in Business Intelligence/Data Integration projects. • 5+ years of experience working with Informatica, GoldenGate, etc. • 5+ years of experience working with Relational Databases like Teradata, Vertica, Oracle, SQL Server, etc. • 3+ years of experience working with Unix Shell Scripts. • Knowledge of MS-Office Suite (Word, Excel, Powerpoint). -- *Nick G.* |* Technical Recruiter **| **Apetan Consulting LLC |* *Tel: 201-620-9700 * 141 **| **15 Union Avenue, office # 6, Rutherford, New Jersey 07070 | * *Mail :-** n...@apetan.com <n...@apetan.com> **| **www.apetan.com* <http://www.apetan.com/> | https://www.linkedin.com/in/nikhil-gupta-a4637391 -- You received this message because you are subscribed to the Google Groups "Oracle Developers" group. To unsubscribe from this group and stop receiving emails from it, send an email to oradev+unsubscr...@googlegroups.com. To post to this group, send email to oradev@googlegroups.com. Visit this group at https://groups.google.com/group/oradev. For more options, visit https://groups.google.com/d/optout.
