*Informatica / DWH Lead * *Location - Buffalo NY* *Right to hire role - Need GC / Citizen*
Lead one or more simultaneous Data Warehouse projects for BI and data warehousing initiatives. This position requires leading an ETL team , create functional requirements and technical specifications as well as design, develop, test, document, implement, manage, and maintain solutions utilizing Informatics’ technology stack, including Informatica Power Center/Data Quality Tools and Teradata. Also work along with ETL/Data Analysts and EDW Architects in designing/enhancing ETL architecture. Perform hands on development and mappings using Informatica Power center. Responsibilities include full lifecycle project management, solution design, and overall ETL design and development. *Essential Responsibilities: * • Ability to create high complexity detailed technical design specifications, Develops detailed analysis, design, construction and testing specifications ensuring technical compatibility and integration • Recommend, design and code efficient and effective solutions for challenging problems for medium to large work efforts of medium to high complexity • Comply with ETL standards and guidelines related to the design, construction, testing, and deployment activities within the Delivery Management environments • Ability to act as a lead developer responsible for the planning, completion and coordination of work activity for projects involving more than one developer • Ability to lead walk though of design documents and provide technical leadership over programming team • Strong analytical and technical aptitude. • An understanding of a variety of modeling and/or diagramming techniques, with the ability to create process flow diagrams and the ability read data flow and entity relationship models • Effective communications with all levels of internal and external customers and staff, including issue resolution, negotiation of project related priorities, and completion dates • Demonstrate collaborative skills working within a project team of diverse skills • Bring strong communication skills including oral, written and presentation skills plus creativity, and problem solving skills to a challenging environment • Provide guidance and direction to less-seasoned staff • Execute hands on Informatica Mapping and Development. • Coordinate with deployment and support resources to ensure the solutions gets implemented smoothly into QA and Production environments. • Take an active role in joint solution design and be an advocate for long term quality in the process. • Work closely with Data analysts, end users, developers and QA team to ensure technical compatibility. *Required Qualifications: * • Bachelor’s degree or equivalent work experience. • Strong understanding of data integration and ETL methodologies. • 5+ years of experience working in a high volume Informatica Power Center, Metadata Manager environment and 10+ years in ETL. • Strong knowledge in Different data base technologies like Oracle , SQL server • Experience in converting specifications to programs and data mapping in an ETL Informatica environment • 8+ years’ experience with Oracle, SQL Server in Unix environment . • Provide High Level and Low Level Architecture Solution/Design to the project • Strong expertise with PL/SQL and T-SQL , Experience writing complex SQL statements and analyzing SQL Tunning/performance is a must. • Excellent communication skills. • Excellent teamwork. • Outstanding analytical skills. • Excellent troubleshooting skills. • Ability to learn new or existing systems quickly • 2+ years ETL Team Lead experience. -- *Thanks & Regards* *Subodh * *Param Consulting Services Inc.* 732-404-0411/0466 Ext 5562 | [email protected] | http://www.pcsionweb.com *Gtalk :* subodhparam
