Hi,
Please find the requirement below , If you find yourself comfortable with the requirement please reply back with your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number *423-509-8437/ 423-402-0963* Please share the profile at *[email protected] <[email protected]>* *Position:* *Datastage ETL lead* *Location: Pleasanton , CA* *Duration: 6+ month/ Contract* *Interview: Phone and Skype* *Job Description:* The Data Integration Architect – Datastage ETL lead Consultant resource will provide Alignment of IT strategy and planning with State Fund’s business goals. Optimization of information management approaches through an understanding of evolving business needs and technology capabilities. Promotion of shared infrastructure and applications to reduce costs and improve information flows. Ensure that projects do not duplicate functionality or diverge from each other and business and IT strategies. Work with solutions architect to provide a consensus based enterprise solution that is scalable, adaptable and in synchronization with ever changing business needs Direct or indirect involvement in the development of policies, standards and guidelines that direct the selection, development, implementation and use of Information Technology within the enterprise. Data Integration Architect – Datastage ETL lead will perform professional software development and maintenance functions to include, but not be limited to any combination of the following: Review current state activities to include the review of the goals and objectives of the Information Management group within State Fund, the oversight responsibilities, and strategic involvement recommendations. Assist in the creation of an enterprise operational data store and analytical data warehouse. Review of existing reporting and analytics tools for potential reduction in technology footprint. Build Datastage ETL interfaces to aggregate, cleanse and migrate data across enterprise-wide MDM, ODS and Data Warehousing systems using staged data processing techniques, patterns and best practices. Implement full lifecycle management to capture and migrate various Datastage ETL metadata including data mapping and other data integration artifacts (such as schedulers, scripts, etc.) across environments including the establishment of standards, guidelines and best practices. Recommend and write advanced SQL and stored procedures (in DB2 and/or Oracle Database Platforms) to include designing solutions for optimal performance and handling other non-functional aspects of availability, reliability and security of Datastage ETL Platform. Recommend normalized and dimensional data models and other data integration techniques such as database replication, change data capture (CDC) etc. and familiarity of SOA and ESB technologies and patterns. Work with various application development teams to provide data integration architecture services and data modeling services *Technical Knowledge and Skills*: The Data Integration Architect – Datastage ETL lead shall possess most of the following technical skills and experience: Extensive hands-on experience in building ETL interfaces using Datastage 9.1 to aggregate, cleanse and migrate data across enterprise-wide MDM, ODS and Data Warehousing systems using staged data processing techniques, patterns and best practices. Strong experience in full lifecycle management of capturing, versioning and migrating various Datastage ETL metadata including data mapping and other data integration artifacts (such as schedulers, scripts, etc.) across environments using vendor platforms such as Data Stage, or other equivalent tools (including open source) by establishing standards, guidelines and best practices. Combined experience of advanced SQL and stored procedures (in DB2, SQL Server, and/or Oracle Database Platforms) with hands-on experience of designing solutions for optimal performance and handling other non-functional aspects of availability, reliability and security of DATASTAGE ETL Platform. Experience with both normalized and dimensional data models, hands-on knowledge of other data integration techniques such as database replication, change data capture (CDC) etc. and familiarity of SOA and ESB technologies and patterns. Technical knowledge in predictive analytics architecture and in development and deployment of predictive models is a plus. *Demonstrable Skills:* *The Consultant resource should possess most of the following skills:* Strong analytical skills with the ability to analyze information identify and formulate solutions to problems. Provides more in-depth analysis with a high-level view of goals and end deliverables. Over 5 years of proven work experience in DataStage version 9.1. Complete work within a reasonable time frame under the supervision of a manager or team lead. Plan and manage all aspects of the support function. Extensive knowledge of and proven experience with data processing systems, and methods of developing, testing and moving solutions to implementation. Strong knowledge in project management practices and ability to document processes and procedures as needed. Work collaboratively with other support team members and independently on assigned tasks and deliverables with minimum supervision Communicate effectively with users at all levels, from data entry technicians up to senior management, verbally and in writing. Self-motivated, working closely and actively communicating with person to accomplish time critical tasks and deliverables Ask questions and share information gained with other support team members, recording and documenting this knowledge Elicit and gather user requirements and/or problem description information, and record this information accurately Listen carefully and act upon user requirements Convey and explain complex problems and solutions in an understandable language to both technical and non-technical persons Present technical solutions to management and decision makers Follow the lead of others on assigned projects as well as take the lead when deemed appropriate Think creatively and critically, analyzing complex problems, weighing multiple solutions, and carefully selecting solutions appropriate to the business needs, project scope, and available resources Take responsibility for the integrity of the solution *Submittal format:* Candidate Name: Job #: Address: Phone: Email: Total IT Experience Total US Experience Monthly Rate to CAI: Salary or Roll over salary for CTH: Work Status (H1B, EAD, GC, US Citizen): If H1B, who holds the visa? Last 4 digits of SSN Skype ID DOB Will candidate Interview F2F (Yes or No): Education Details(Years, Degree & Univ. Name) Name of the individual at your firm who the candidate spoke with about the position: Vishal Skills as they relate to the job: *# years DataStage version 9.1.:* *# years SQL and stored procedures:* *# years database replication, change data capture:* *# years SOA and ESB technologies:* Thanks & Regards, [image: http://www.hanac.us/wp-content/uploads/2015/08/HANAC-blue-LOGO_v2-300px.png] *Vishal Kumar* Resource Manager *HANAC Staffing Solutions LLC* 1474 37th St. NE, Cleveland, TN, 37312 * Phone: 423-509-8437/ 423-402-0963* *Email: **[email protected] <[email protected]>* *G-Talk:* req.vishal/ vishalkumar.econo *www.hanac.us <http://www.hanac.us/>* *Note: Under Bill s.1618 Title III passed by the 105th U.S. Congress, this email cannot be considered Spam as long as we include Contact information and a method to be removed from our mailing list. If you are not interested in receiving our emails than please reply with a “remove” in the subject line and mention all the email addresses to be removed with an email addresses which might be diverting the email to you.* -- You received this message because you are subscribed to the Google Groups "R-help-archive" 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 https://groups.google.com/group/r-help-archive. For more options, visit https://groups.google.com/d/optout.
