ETL Data Warehouse Technical Lead
<p align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> Job Description: <p align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> <p align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> We are looking for a Technical Lead for Data Movement product within the Technology group who has vast experience in ETL domain. The Tech lead will be responsible to lead a team of 4-5 team members in India / US. ETL Batch Framework is one of the main offering of the Data Movement product. This helps to serve the immediate needs of a Data warehouse Projects across various divisional IT teams to bring business feeds from external vendors into Asset management business. The framework provides improved time to market, since all the important ETL functions for Data ware housing project are developed in a re-usable fashion. The end developer uses this framework to cater to the Data ware housing needs of the project <p align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> <p align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> Technologies used in developing this product are <p align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> <div align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> Good knowledge of UNIX systems and environments <div align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> <span style=`mso-fareast-font-family: symbol; mso-bidi-font-family: symbol; mso-ansi-language: en-us`> <span style=`font: 7pt 'Times New Roman'`> Unix Shell Scripts to create re-usable components <div align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> Autosys for scheduling job <div align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> <span style=`mso-fareast-font-family: symbol; mso-bidi-font-family: symbol; mso-ansi-language: en-us`> <span style=`font: 7pt 'Times New Roman'`> Informatica as ETL tool <div align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> Oracle DB for storing framework metadata. <p align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> The candidate should be an expert in Unix shell scripting with the awareness of several shells like KShell, Bourne shell and Cshell. Also the candidate should have fair knowledge of Informatica workflow development or Informatica Administration. The individual should be able to provide technical leadership to the Data Movement delivery team in delivering solutions to the IT partners. Job duties include Data Movement Framework related project assignments by closely working with the Architect and engineering team and taking service requests to support Data Movement Framework in Non-Production space. Job duties also include consultation on Informatica Power center and Data Movement Framework. The successful candidate will be able to work collaboratively with development, Architecture, System Analysis and team members based in U.S. <p class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px; margin-left: 0.25in; vertical-align: baseline; mso-layout-grid-align: none; punctuation-wrap: simple`> <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Understand and review the backlog requirements from IT partners / System Analyst <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Understand and review the Architecture / proposed solution from the Architect <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Design and guide the development to team members based on the Architecture defined by Architect <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Have an eye on re-usable solutions versus specific customized solution, since STS solutions are used by more than 1 division at any given point of time. <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Oversight on the development practices, design review, code review of the modules churned by developers. <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Participate and guide the team in unit, integration, and non-functional testing <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Provide technical guidance to the offshore development team. Coach and mentor the technical team <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Ensure development teams follow coding guidelines and practices, and conduct formal code reviews. Participate in defining the technical & coding standards and guidelines for the team or group <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Participate in critical problem solving and advanced technical troubleshooting to assist the organization <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Promote User group meeting and Adoption of new components to application teams. <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Collaborate with supporting organizations effectively - like Operations team, TSO, Network team, Risk team and DBA s. <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Providing day to day support for Data Movement Framework usage throughout the India-based Engineering organization <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Must be self-motivated and a self-starter, able to work independently on a project from start to finish with little supervision and deliver finished product within projected times. Must be able to multi-task efficiently and adjust priorities accordingly. <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Be able to break up a project into milestones & activities and report status to management. <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l1 level1 lfo1; mso-layout-grid-align: none; punctuation-wrap: simple`> Willing to learn and adapt to different work environments Qualifications Qualifications <p align=`justify` class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px`> Key Requirements: <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Bachelor s degree <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> 10+ years experience. Recent ETL development experience is a must. Must have considerable experience in ETL domain and design principles <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> 7+ yrs experience in Shell scripting (UNIX). <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Experience in any of the ETL tools Informatica / DataStage / Ab-inito <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> 3+ yrs experience in Administration / Informatica tools / Informatica workflow development <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Experience in any of the databases - SQL, PL/SQL and fair knowledge of Entity Relationship models <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Autosys scheduling tool knowledge a plus. <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Knowledge of Software configuration management tool. <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Experience in developing shell scripts that interact with relational db or Informatica command line <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Requires excellent verbal & technical writing skills to effectively communicate technical concepts and communicate processes and design to technical staff. <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Familiarity with software development methodology / Agile process. <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Must have experience in defining solutions and the needed architecture to enable it. Ability to take the functional and non functional requirements and propose a solution that will meet the business needs <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Ability to analyze business problem, understand big picture and develop technical solutions. <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Ability to build support among senior management and key stakeholders for proposed solutions <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Should be able to provide technical leadership to the development teams in preparing the design artifacts and implementation of solutions. Should be able to identify integration points between various design areas and should be able to track the implementation of integrations. The candidate should be able to mentor the members of the development teams <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Should be able to work on projects that cut across divisional boundaries in FIMT <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Should be able to work on Proof of concepts independently <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Should be a quick learner be able to adapt to new technologies in the Informatica tools <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Should have excellent presentation, documentation and communication skills as well as skills to present/sell technology in business context to the stakeholders <li class=`MsoNormal` style=`vertical-align: baseline; mso-list: l0 level1 lfo1; tab-stops: list .5in; mso-layout-grid-align: none; punctuation-wrap: simple`> Experience in Financial Services Industry especially in Buy side investment management is highly desirable <p class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px; margin-left: 0.5in; vertical-align: baseline; mso-layout-grid-align: none; punctuation-wrap: simple`> <p class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px; margin-left: 0.5in; vertical-align: baseline; mso-layout-grid-align: none; punctuation-wrap: simple`> Primary skill sets ETL domain knowledge, Unix shell scripting, Tech lead <p class=`MsoNormal` style=`margin-top: 0px; margin-bottom: 0px; margin-left: 0.5in; vertical-align: baseline; mso-layout-grid-align: none; punctuation-wrap: simple`> Secondary skill sets Experience in any ETL tool, Informatica Admin knowledge, Informatica workflow development experience, Exposure to any DB ( Oracle / MSSQL / SYBASE ) Job Information Technology Primary Location NC-Durham Princeton Information is one of the nation's top five privately-held IT consulting firms, in business since 1985. Princeton Information services a clientele of primarily Fortune 500 companies nationwide. With annual revenues over $120 million, Princeton Information operates across the US from multiple regional offices. Our Commitment to Our Consultants As a privately held company, Princeton Information is solely committed to the success of clients and consultants - not to any shareholders. PI's success is grounded in the relationships we build with our consultants. We seek the best people; provide career path counseling; as well as the most challenging opportunities in business and in IT. As part of its culture of loyalty and commitment to its consultants, Princeton Information is committed to doing all we can to ensure our consultants have the best possible search, placement and work experience possible. Our Services Working with one Princeton Recruiter will gain you access to over 500 open requirements with the top clients in the US across all industries (finance, insurance, pharmaceutical, commercial, telecom, media, manufacturing) nationwide. Our local recruiters have in-depth knowledge of our clients and opportunities. They will work with you to find you the best possible opportunities for you and your career. Our Relationships Our relationships with our clients, as well as our consultants, are critical to our success! We have a robust sales organization that ensures that Princeton has the inside track on what attributes a person needs in order to be successfully placed and engaged at our clients. We know the technical and non-technical skills that our clients are looking for and we ensure that you are educated about the client prior to your interview with them. Princeton is committed to going above and beyond to ensure that each meeting you have with a client is a successful one!
|
Durham, NC
|
Expired |
Jeanette Hayden
Software Developer
View profile
Yuri Taran
Translator
View profile
BalkanBrothers
Web Designer
View profile
Related projects
Search for freelance jobscan’t wait for more clients
and advertising. Thank you."