*I still have an available ETL Developer position in NY, NY - Informatica, SQL, UNIX Scripting, and Teradata! Candidates MUST be able to interview in person :)*
*Location: NYC | NY * *Please send who you have that can do an IN PERSON interview. * *Rate $55-60/HR* *Duties and Responsibilities:* • Developing and maintaining thorough business knowledge of source / target data in Teradata and Vertica • Working closely with cross-functional business and business intelligence teams to document ETL requirements and turn them into ETL jobs • Implementing business-driven requirements using Informatica • Performing source target mapping in support of report and warehouse technical designs • Conducting ETL performance tuning, troubleshooting, support and capacity estimation • Developing, adhering to, and being a proponent for Data Warehouse development standards, including ETL standards and best practices • Working with business intelligence analyst and project teams to understand analysis and reporting requirements; ensuring work product meets users’ needs • Creating and maintaining logical data maps identifying information linkages between critical operational systems and Enterprise Data Warehouse • Maintaining thorough understanding of business processes and ETL processes, and identifying efficiencies and needed controls to fine-tune ETL operation • Supporting validation and testing of developed workflows and business intelligence system integration testing • Providing documentation for all developed ETL processes, including process flow and data mapping • Developing audit reporting and quality improvement processes to ensure accurate and consistent delivery of data • Providing schedule and status reporting • Acting as liaison between various business units and technology • Work with BI Architecture and Innovations group to craft solution for data integration and business layer • 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 • Work with BI Operations – Tier I and Tier II teams to rollout data controls and define incident management process for data issues. • Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data *Supervisory Responsibilities:* • There are no supervisory responsibilities associated with this position *Minimum Qualifications: * • At least five (5) years of experience in database development, data warehouse experience and Informatica ETL development required • Bachelor’s degree or equivalent in Computer Science, Information Systems or related course of study required *Requirements and General Skills:* • Experience in writing complex SQL to implement business rules, extract and analyze data • Excellent Analysis skills • Ability to manage multiple assignments simultaneously and follow up on unfinished business • Excellent data analysis skills • Experience deploying self-service capabilities in Reporting/BI • Experience integrating technologies with both internal and external data sources • Demonstrated ability to manage multiple projects with competing deadlines and priorities • Leadership and project management experience • Goal oriented and creative personality with good interpersonal skills • Experience working with outsourced vendors • Ability to work independently and in a team environment • Ability to pay attention to details and be organized • Commitment to “internal client” and customer service principles • Ability to handle multiple tasks in a fast paced environment • Willingness to take initiative and to follow through on projects • Excellent time management skills, with the ability to prioritize and multi-task, and work under shifting deadlines in a fast paced environment • Must have legal right to work in the U.S. *Technical Skills:* • Excellent SQL skills required • 5-7 years of experience with ETL tools like Informatica, Golden Gate, etc., • Experience with various databases like Teradata, Vertica, Oracle, etc., • Knowledge of Unix • Thorough knowledge of MS-Office Suite (Word, Excel, PowerPoint) *Thanks* *Ricky |* *Head-Resource Manager* | *Apetan Consulting LLC* Tel: 201-285-8031 <201-448-3198> * 103 | | 72 Van Reipen Avenue # 255 Jersey City, NJ 07306 ri...@apetan.com | www.apetan.com <http://www.facebook.com/Apetanconsulting> <http://www.linkedin.com/company/apetan-consulting-llc?trk=top_nav_home> <http://twitter.com/ApetanLLC> *Disclaimer:* We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at rem...@apetan.com and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e mails to you. We are sorry for the inconvenience. -- You received this message because you are subscribed to the Google Groups "mainframe" group. To unsubscribe from this group and stop receiving emails from it, send an email to mainframe+unsubscr...@googlegroups.com. To post to this group, send email to mainframe@googlegroups.com. Visit this group at http://groups.google.com/group/mainframe. For more options, visit https://groups.google.com/d/optout.