Lead Etl/Teradata Developer F2F Must)

Techtriad Team - T3 New York City , NY 10020

Posted 3 months ago

Title: Lead ETL Developer with Teradata ( F2F Interview Must)
Duration:
Long Term
Location: Washington, D.C & NY ( Two Locations)
Interview process: Telephonic/In-Person

Job Description:
The Lead Developer, ETL is responsible for the data integration to support the end-to-end process for streaming services. The streaming services integration includes but is not limited to: metadata, playlist data, OnDemand, direct licensor metadata, MDM integration, consumption, listen crunch and partner payment data. This position works closely with the ETL manager, business intelligence director, ETL and business intelligence developers, 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.
Duties and 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, adhere to, 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.

Minimum Qualifications:
bachelors degree or equivalent, relevant experience.
Minimum of 10 years of experience in ETL/ELT development in business intelligence/data integration projects.
Minimum of 10 years of data analysis and data quality.
10+ years of experience working with ETL tools like Informatica, Golden Gate, etc.
10+ years of experience working with Relational Databases such as Teradata, Vertica, Oracle, SQL Server, etc.
5+ years of experience working with Unix Shell Scripts.
Requirements and General

Skills:
Good public speaking and presentation skills.
Interpersonal skills and ability to interact and work with staff at all levels.
Excellent written and verbal communication skills.
Ability to work independently and in a team environment.
Creative writing ability.
Excellent time management skills, with the ability to prioritize and multi-task, and work under shifting deadlines in a fast-paced environment.
Excellent communication and motivation skills, and ability to interact appropriately with senior level colleagues and business users.
Strong data analysis and troubleshooting skills.
Experience in integrating technologies with internal and external data sources.
Technical Skills:
Experience with data analysis, data architecture, data cleansing and data quality.
Experience with data integration tools like Informatica, Data Stage.
Experience with databases technologies like Oracle, Teradata and Vertica.
Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data.
Experience in writing complex SQLs to analyze and troubleshoot the issues/problems.
Thorough knowledge of MS-Office Suite (Word, Excel, PowerPoint, Access).

Arif Shaik
Techtriad Team Inc T3

Skills:
ETL,Teradata,Informatica, UNIX,Teradata, Vertica, Oracle, SQL Server,
Contract


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Datastage Developer W/ Xml/Need USC & GC
New!

Key Business Solutions, Inc.

Posted Today

VIEW JOBS 11/18/2018 12:00:00 AM 2019-02-16T00:00 Senior Datastage Developer w/ XML/Need USC & GC<br /> Location: NYC,NY<br /> Mode of Interview: SKYPE<br /> Duration: 1+ year<br />  <br /> Job Description: <br /> ***Please Note: Candidates MUST have strong XML Data Input/Output Experience***<br /> The Data Integration Specialist will own the design and development of the data integration processes. They will also have the responsibility for managing and administering the IT tools supporting the IBM Information Server Platform, while ensuring high levels of data quality and privacy. <br /> Responsibilities:  <ul> <li style="padding: 0; margin: 0;">Responsible for the implementation ETL / ELT jobs form various business systems to MDM and other systems. This will include file, based, web service based, and database based processes.</li> <li style="padding: 0; margin: 0;">Work closely with other teams to provide expertise, especially with the MDM and Service Integration teams to determine the appropriate integration approach, mapping and quality of sourced data.</li> <li style="padding: 0; margin: 0;">Assist in maintain the data model and documentation via data modeling and architecture tooling</li> <li style="padding: 0; margin: 0;">Own the technical administration of the applications (not the infrastructure)</li> <li style="padding: 0; margin: 0;">Support any data quality profiling required periodically by the business or when onboarding new data sources.</li> <li style="padding: 0; margin: 0;">Participate in the regular Data Governance Council meetings</li> <li style="padding: 0; margin: 0;">Understand and ensure adherence to all PII and Master Data Governance policies and procedures</li> <li style="padding: 0; margin: 0;">Understand, adhere to, and monitor all SLAs and accuracy ratios for creating and updating data</li> <li style="padding: 0; margin: 0;">Maintain consistency, uniformity, and accuracy of all data passing through the Data Integration Platform</li> </ul> Requirements: <ul> <li style="padding: 0; margin: 0;">A degree in computer science or overall IT knowledge.</li> <li style="padding: 0; margin: 0;">5 – 8 years minimum experience with DataStage. </li> <li style="padding: 0; margin: 0;">Strong in Datastage</li> <li style="padding: 0; margin: 0;">Oracle/SQL</li> <li style="padding: 0; margin: 0;">Unix</li> <li style="padding: 0; margin: 0;">Extensive experience in creating complex XML output from Datastage.</li> <li style="padding: 0; margin: 0;">Very strong experience where the datastage jobs covert data and write to XML files.</li> <li style="padding: 0; margin: 0;"> <div><b>Kiran Kumar</b></div> <div><b><a href="mailto:kiran@keybusinessglobal.com" target="_blank">kiran@keybusinessglobal.com</a></b></div> <div><b>Key Business Solutions, Inc.</b></div> <div><b>|| Office: 916 646 2080 Ext 224 || Fax: 916 646 2081 || Email: </b><a href="mailto:kiran@keybusinessglobal.com" target="_blank">kiran@keybusinessglobal.com</a><b> || Website: </b><a href="http://www.key-soft.com/" target="_blank" title="http://www.key-soft.com/">www.key-soft.com</a><b> || Yahoo: kirankeysoft Gtalk: <a href="mailto:kiranjabukeysoft@gmail.com" target="_blank">kiranjabukeysoft@gmail.com</a></b></div> <div><b>Note:</b> This email is not intended to be a solicitation.  Please accept our apologies and reply in the subject heading with REMOVE to be removed from our Mailing list.</div>   </li> </ul>  <br />  <br />  <br />   Key Business Solutions, Inc. New york city NY

Lead Etl/Teradata Developer F2F Must)

Techtriad Team - T3