*BI Data Warehouse Architect* *Client: Administrators for the Professions (AFP)*
*Location: Roslyn, New York* *Local* *Face to Face * *6-12 months* Job Description: *General Summary: *Provides technical leadership in the areas of Business Intelligence (BI) and Data Warehouse (DW) technologies and business processes to provide in-depth analysis of application/systems to assist in the development of solutions to meet business requirements, compare and evaluate options and recommend a course of action from a solution standpoint. Assists IT Management in establishing and implementing database architectural and development standards, as well as roadmaps for improving the performance and scalability of AFP’s enterprise database environments. *Education & Qualifications:* - Bachelor's degree (B.S.) in computer science or related field plus required experience - Minimum 3 years Data Warehousing/ETL experience - Minimum 2 years experience using Oracle - Minimum 2 years experience working with SAP Business Objects Information Design Tool (IDT) or SAP Business Objects Designer, SAP Data Integrator/Data service or other ETL tools - Possesses proven experience in the development and support of the Extract Transform and Load (ETL) processes necessary to deliver reports, analytics and dashboards in several functional areas across a global enterprise. - Demonstrated knowledge of database concepts of data modeling and mapping including normalization, dimensionality, referential integrity, indexes, keys, common dimensions, star and snowflake schemas, master data and metadata (MUST know how to read models and mappings) - Experience in developing ETL processes for Data Warehouse, Data Marts and/or Operational Data Stores, as well as, in operationalization of ETL and all dependent processes - Experience in identifying performance issues, SQL optimization, and designing high performing ETL processes - Experience in creating data foundation layer for SAP Business Objects Universes - Must possess a deep understanding of DW and BI concepts in a large organization using multiple applications and various data sources, as well as, knowledge of Data Modeling/ Analysis/Data Integration best practices - Must be able to troubleshoot existing ETL code to resolve issues (e.g. join and performance issues) - Experience working with transactional databases, MS Excel, Web Services, and various other formats as data sources - Demonstrated experience across numerous data warehousing/data integration projects, as well as, the ability to work with other project team members and business users to resolve moderately complex data integration issues - Must possess sound understanding of Software Development Life Cycle (SDLC) - Strong SQL and Oracle PL/SQL skills. Must be able to read and write, and optimize SQL - Proficient in a variety of computer programming languages in order to successfully complete the tasks of the role - DBA or database development experience (a plus) - Ability to multi-task with minimal supervision Knowledge of .NET (a plus) *Essential Duties & Responsibilities:* - Provide technical leadership and implementation assistance with respect to AFP’s data warehouse/ database environments - Analyze database environments and suggest methods to improve operational efficiency and scalability - Develop data warehouse architecture roadmap and implementation plans - Assist with performing proactive monitoring of database environments (backups, performance, capacity planning, job scheduling…) - Assist with planning and performing database upgrades and updates - Envision, plan and implement major database / application migrations - Provide technical leadership in the design and development of enterprise database applications - Create conceptual and technical design documents for approved business requirements - Create and maintain technical documentation as it relates to specific database applications - Create and maintain technical documentation as it relates to AFP’s database environments - Actively contribute to software development and coding activities - Responsible for translating complex designs for development, testing, troubleshooting, and integration of ETL code/packages. - Performs extractions, transforms and loads data involving complex data transformations, change data capture, and error handling from disparate application systems and various data sources using different formats into a data warehouse/BI environment utilizing Oracle PL/SQL - Utilizes the data warehouse tables to build SAP Business Objects Universe data foundation layers using Information Design Tool (IDT) - Work closely with the Software Develop Management, Programmer/Analyst, and Project Management Office (PMO) to understand business requirements, source to target mappings, data models, and universe designs in order to develop highly efficient and highly scalable ETL processes and Universe data foundation ensuring delivery of business needs in a timely manner - Actively contributes innovative solutions to difficult challenges - Complete and update documentation for ETL design, universe and implementation - Provides production support for existing ETL and universes - Responsible for learning, applying, refining established ETL development standards *Regards, Meenu Yadav* *IT-Technical Recruiter Source Infotech Inc. **3840 Park Avenue, Suite C-205, Edison, NJ-08820* *Phone#: 609-608-0466|| Fax: 732-909-2282 || Email: * *mya...@sourceinfotech.com* <mya...@sourceinfotech.com> *------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------* *Disclaimer: *Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail cannot be considered Spam as long as we include contact information and a remove link for removal from our mailing list. To be removed from our mailing list, reply with remove in the subject heading and your email address in the body. Include complete address and domain to be removed. Pursuant to Federal law, if you do not wish to receive future email messages from us, please reply with "remove" to the same id. -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to us_itgroups+unsubscr...@googlegroups.com. To post to this group, send email to us_itgroups@googlegroups.com. Visit this group at https://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.