Hello, Please share resume to [email protected] *Title: ETL/Informatica Consultant*
*Location: **Denver, CO* *Duration: 3-6 Month * *Interview: Skype & (Face to face local prefer)* *Start Date: ASAP * Responsibilities: • Responsible for the design, documentation, development, testing, installation and support of complex data extract transformation and load (ETL) programs in a data warehouse environment. • Will be accountable for defining level of effort and ensuring that all standards and processes are followed and enforced. The role will work closely with business and data analysts on projects of various scope impacts; impacting individual departments to company-wide. • Know how to read and translate logical data models and use ETL skills to load the physical layer • Understand timing of a data load, how the data should be transformed and optimizing ETL load performance is a critical part of the job • Ability to effectively interact with various levels of technologists for devising an effective solution to meet business requirements • Working knowledge of data warehousing and data mart architectures, concepts and processes required • Detailed knowledge of extract, transform and load procedures, technologies, techniques and test approaches • Responsible for providing test approaches and best practices for data management projects • Interact with business stewards, subject matter experts and stakeholders to relate data and difficult technical concepts in business terms, constantly working to create strong working relationships, adoption and interaction with business areas • Works with infrastructure teams to ensure adequate capacity and performance planning Responsible for the design and development of ETL code to extract, cleanse, aggregate, and load data into an analytical data warehouse • Participate in all phases of the systems development life cycle, including requirements analysis, design, development, testing and deployment • Work with the production support team in Daily/Nightly/Weekend job failures. *Requirements*: • Informatica 9.X • Autosys • Strong SQL, DDL and DML • Experience in SQL Server and Oracle. • Cognos (Nice to have) • ETL -- You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-vendor. For more options, visit https://groups.google.com/d/optout.
