Data Stage Developer - MI..
Data Stage Developer Lansing, MI 10 month contract Phone and Skype *Position Description:* 5 years’ technical consultant in support of ETL development in support of data warehouse. Experience in data requirements analysis, data profiling, and develop source to target mappings. Design and development of ETL Datastage jobs for handling enterprise inbound/outbound data and handling heterogeneous inputs. Data profiling activities to validate and confirm on expected transformation rules *Skills Required:* Expertise in ETL architecture design and experience in job design, optimization, scheduling, containers, job sequences, configurations, and transformer stages, involving data quality, testing and information delivery and access to the data warehouse. *Skills Preferred:* Data profiling, data model design, review, ETL jobs design using DataStage. Experience in design data conversions, creating/validating data conversion rules. *Experience Required:* · 5 years expertise in Teradata and Data Stage. · 5 years writing SQL queries and stored procedures. · 5 years of design and development of ETL Datastage jobs for handling enterprise inbound/outbound data and handling heterogeneous inputs. · Data profiling activities to validate and confirm on expected transformation rules. Writing shell scripting for various ETL needs and automation. · Development of Source to Target Mapping Specifications, and supporting data modeling efforts. o Expertise in building Teradata BTEQ scripts and utilizing Teradata utilities such as TPT, fast load, fast export, MLOAD to meet various business requirements *Experience Preferred:* Data Base administration, data architect, and performance tuning. Interactions with project stake holders for design, business transformation rules and System testing/UAT activities. Good working knowledge of Waterfall & Agile Development Methodologies. *Education Preferred:* BS in information technology -- You received this message because you are subscribed to the Google Groups "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at https://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/d/optout.
Need for ETL DATA STAGE DEVELOPER @@@@ MI ---- Rate $45/hr
Greeting’s Reply to sa...@sureitinc.com and satya.sur...@gmail.com *Title: ETL / Data Stage Developer* *Location: Detroit MI* *Duration: 12 Months* * * *Need 100% Matching resume, all required skills must be there in the resume. * * * We have an immediate need for an ETL / Data Stage Developer for the metro Detroit, MI area who has skills in DataStage and ETL. Healthcare exp. a definite plus. Please provide the following info when submitting a candidate to me: * * *JOB DESCRIPTION* *PRIMARY OBJECTIVE* Responsible for developing ETL mappings, data transformations and movement of data between source and target systems within the corporate operational data store and enterprise data warehouse on the InfoSphere / DataStage platform. Must adhere to ETL standards and technical and business level road mapping and the BI Strategic plan. Will be a key source of expertise in analyzing and understanding data from various sources in order to validate data quality and help to ensure that business reporting needs are fulfilled through a formal, manageable process. *DUTIES AND RESPONSIBILITIES* *1. Provide ETL Tool specific knowledge (DataStage) to the organization Provide expertise in formal processes, methodologies, and artifacts for executing ETL functions in a controlled and repeatable manner with minimum duplication of effort Provide accurate assessments of time required to produce transformations in chosen ETL toolset Provide mentoring to other ETL developers new to the tool and its functions Provide expertise in semantic transformations and understanding of complex data structures Work closely with the Business Intelligence Tool Specialist (Cognos) and Enterprise Data Architect and database administrators to ensure optimum performance of the ETL data processes. *2. Design and develop in the Infosphere / DataStage toolset Analyze and understand source and target data’s meaning Produce ETL mappings in DataStage that “transform” (i.e. translate) data from one system’s semantic structure to another Work closely with the enterprise data architect to validate accuracy of transformations and works closely with data stewards to validate data dictionaries and other metadata content Utilize best practice standards in ETL mapping development efforts and documentation of ETL requirements Work with business users, report writers and enterprise data architect to refine/adapt/maintain ETL mappings as business user needs change or the data environment changes Work closely with data stewards to validate data dictionaries and other metadata for reporting data sources to ensure semantic meanings are carried forward form OLTP source data systems to target operational data stores and the enterprise data warehouse 3.Ability to clearly understand and communicate the nature of any gaps in the semantics of any source data intended to create target data 4. Ability to clearly understand business needs to create ETL logic encoding business rules in transformation processes 5. Perform other related duties as assigned. * Essential Functions B.* Experience* Two (2) + years of experience as a DataStage developer Data analyst experience relevant to requirements gathering, analysis and design functions preferred ETL developer experience in other toolsets relevant to data movement and transformations will also be considered Track record of successful implementations and innovative ETL development with highly satisfied business users *C. Abilities* Ability to understand data requirements, translate them into ETL designs while dealing with complexities of integration of complex data and business concepts and put it all together so it can be organized and easily transferred and delivered in a repeatable process to our operational data store and enterprise data warehouse. Technical knowledge, analytical skill, reliability and initiative required to implement quality ETL system processes and deliver timely and well organized data intelligence to the user community at large (internal and external.) Ability to collect and prepare data for written and/or oral presentations communicating effectively with all levels of data processing and user management *D: Knowledge* Knowledge of Information Services policies, procedures and functions Knowledge of Healthcare data and business practices and processes in order to provide appropriate and accurate levels of data intelligence to the business community A high level of human relation skills in order to be effective in working with people of varied skills, backgrounds, and personalities at various levels throughout the organization. *Best Regards* * * *Satya Dowluri * *Sure IT Solutions Inc.* *1801 W Queen Creek RD, Suite # 3, Chandler, AZ 85248* *Tel: (602)-490-0074 Fax: (866) 322-0121* Email: sa...@sureitinc.com | satya.sur...@gmail.com LinkedIn :
Need for ETL DATA STAGE DEVELOPER @@@@ MI ---- Rate $45/hr
Greeting’s Reply to sa...@sureitinc.com and satya.sur...@gmail.com *Title: ETL / Data Stage Developer* *Location: Detroit MI* *Duration: 12 Months* * * *Need 100% Matching resume, all required skills must be there in the resume. * * * We have an immediate need for an ETL / Data Stage Developer for the metro Detroit, MI area who has skills in DataStage and ETL. Healthcare exp. a definite plus. Please provide the following info when submitting a candidate to me: * * *JOB DESCRIPTION* *PRIMARY OBJECTIVE* Responsible for developing ETL mappings, data transformations and movement of data between source and target systems within the corporate operational data store and enterprise data warehouse on the InfoSphere / DataStage platform. Must adhere to ETL standards and technical and business level road mapping and the BI Strategic plan. Will be a key source of expertise in analyzing and understanding data from various sources in order to validate data quality and help to ensure that business reporting needs are fulfilled through a formal, manageable process. *DUTIES AND RESPONSIBILITIES* *1. Provide ETL Tool specific knowledge (DataStage) to the organization Provide expertise in formal processes, methodologies, and artifacts for executing ETL functions in a controlled and repeatable manner with minimum duplication of effort Provide accurate assessments of time required to produce transformations in chosen ETL toolset Provide mentoring to other ETL developers new to the tool and its functions Provide expertise in semantic transformations and understanding of complex data structures Work closely with the Business Intelligence Tool Specialist (Cognos) and Enterprise Data Architect and database administrators to ensure optimum performance of the ETL data processes. *2. Design and develop in the Infosphere / DataStage toolset Analyze and understand source and target data’s meaning Produce ETL mappings in DataStage that “transform” (i.e. translate) data from one system’s semantic structure to another Work closely with the enterprise data architect to validate accuracy of transformations and works closely with data stewards to validate data dictionaries and other metadata content Utilize best practice standards in ETL mapping development efforts and documentation of ETL requirements Work with business users, report writers and enterprise data architect to refine/adapt/maintain ETL mappings as business user needs change or the data environment changes Work closely with data stewards to validate data dictionaries and other metadata for reporting data sources to ensure semantic meanings are carried forward form OLTP source data systems to target operational data stores and the enterprise data warehouse 3.Ability to clearly understand and communicate the nature of any gaps in the semantics of any source data intended to create target data 4. Ability to clearly understand business needs to create ETL logic encoding business rules in transformation processes 5. Perform other related duties as assigned. * Essential Functions B.* Experience* Two (2) + years of experience as a DataStage developer Data analyst experience relevant to requirements gathering, analysis and design functions preferred ETL developer experience in other toolsets relevant to data movement and transformations will also be considered Track record of successful implementations and innovative ETL development with highly satisfied business users *C. Abilities* Ability to understand data requirements, translate them into ETL designs while dealing with complexities of integration of complex data and business concepts and put it all together so it can be organized and easily transferred and delivered in a repeatable process to our operational data store and enterprise data warehouse. Technical knowledge, analytical skill, reliability and initiative required to implement quality ETL system processes and deliver timely and well organized data intelligence to the user community at large (internal and external.) Ability to collect and prepare data for written and/or oral presentations communicating effectively with all levels of data processing and user management *D: Knowledge* Knowledge of Information Services policies, procedures and functions Knowledge of Healthcare data and business practices and processes in order to provide appropriate and accurate levels of data intelligence to the business community A high level of human relation skills in order to be effective in working with people of varied skills, backgrounds, and personalities at various levels throughout the organization. *Best Regards* * * *Satya Dowluri * *Sure IT Solutions Inc.* *1801 W Queen Creek RD, Suite # 3, Chandler, AZ 85248* *Tel: (602)-490-0074 Fax: (866) 322-0121* Email: sa...@sureitinc.com | satya.sur...@gmail.com LinkedIn :
Need for ETL DATA STAGE DEVELOPER @@@@ MI ---- Rate $45/hr
Greeting’s Reply to sa...@sureitinc.com and satya.sur...@gmail.com *Title: ETL / Data Stage Developer* *Location: Detroit MI* *Duration: 12 Months* * * *Need 100% Matching resume, all required skills must be there in the resume. * * * We have an immediate need for an ETL / Data Stage Developer for the metro Detroit, MI area who has skills in DataStage and ETL. Healthcare exp. a definite plus. Please provide the following info when submitting a candidate to me: * * *JOB DESCRIPTION* *PRIMARY OBJECTIVE* Responsible for developing ETL mappings, data transformations and movement of data between source and target systems within the corporate operational data store and enterprise data warehouse on the InfoSphere / DataStage platform. Must adhere to ETL standards and technical and business level road mapping and the BI Strategic plan. Will be a key source of expertise in analyzing and understanding data from various sources in order to validate data quality and help to ensure that business reporting needs are fulfilled through a formal, manageable process. *DUTIES AND RESPONSIBILITIES* *1. Provide ETL Tool specific knowledge (DataStage) to the organization Provide expertise in formal processes, methodologies, and artifacts for executing ETL functions in a controlled and repeatable manner with minimum duplication of effort Provide accurate assessments of time required to produce transformations in chosen ETL toolset Provide mentoring to other ETL developers new to the tool and its functions Provide expertise in semantic transformations and understanding of complex data structures Work closely with the Business Intelligence Tool Specialist (Cognos) and Enterprise Data Architect and database administrators to ensure optimum performance of the ETL data processes. *2. Design and develop in the Infosphere / DataStage toolset Analyze and understand source and target data’s meaning Produce ETL mappings in DataStage that “transform” (i.e. translate) data from one system’s semantic structure to another Work closely with the enterprise data architect to validate accuracy of transformations and works closely with data stewards to validate data dictionaries and other metadata content Utilize best practice standards in ETL mapping development efforts and documentation of ETL requirements Work with business users, report writers and enterprise data architect to refine/adapt/maintain ETL mappings as business user needs change or the data environment changes Work closely with data stewards to validate data dictionaries and other metadata for reporting data sources to ensure semantic meanings are carried forward form OLTP source data systems to target operational data stores and the enterprise data warehouse 3.Ability to clearly understand and communicate the nature of any gaps in the semantics of any source data intended to create target data 4. Ability to clearly understand business needs to create ETL logic encoding business rules in transformation processes 5. Perform other related duties as assigned. * Essential Functions B.* Experience* Two (2) + years of experience as a DataStage developer Data analyst experience relevant to requirements gathering, analysis and design functions preferred ETL developer experience in other toolsets relevant to data movement and transformations will also be considered Track record of successful implementations and innovative ETL development with highly satisfied business users *C. Abilities* Ability to understand data requirements, translate them into ETL designs while dealing with complexities of integration of complex data and business concepts and put it all together so it can be organized and easily transferred and delivered in a repeatable process to our operational data store and enterprise data warehouse. Technical knowledge, analytical skill, reliability and initiative required to implement quality ETL system processes and deliver timely and well organized data intelligence to the user community at large (internal and external.) Ability to collect and prepare data for written and/or oral presentations communicating effectively with all levels of data processing and user management *D: Knowledge* Knowledge of Information Services policies, procedures and functions Knowledge of Healthcare data and business practices and processes in order to provide appropriate and accurate levels of data intelligence to the business community A high level of human relation skills in order to be effective in working with people of varied skills, backgrounds, and personalities at various levels throughout the organization. *Best Regards* * * *Satya Dowluri * *Sure IT Solutions Inc.* *1801 W Queen Creek RD, Suite # 3, Chandler, AZ 85248* *Tel: (602)-490-0074 Fax: (866) 322-0121* Email: sa...@sureitinc.com | satya.sur...@gmail.com LinkedIn :
