*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) -- 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.
