The Senior ETL Developer will be responsible for, but not limited to, the following:
Design and develop ETL code using IBM¿s Data Stage suite of ETL tool for the definition, development and testing of the processes and programs necessary to extract data from the various data sources Monitor vendor activities related to SESIS Data Conversion and Integration Perform vendor deliverable review and approval for SESIS Data Conversion and Integration Work with other data analysts, business users and IT professionals to ensure that data requirements are met with the highest degree of integrity and efficiency that is practical and cost effective Ensure that documentation is captured, maintained, understood by and available to business and/or IT partners Participate in, or facilitate, business process and requirement sessions to ensure that the business fully understands the requirements and the data necessary to support those requirements Develop, Test and manage ETL jobs to specifications and design Design and Develop processes for purposes of data cleansing, verification and reconciliation Escalate critical technical issues and potential problems as needed to the SESIS Project Manager to address any SESIS related issues in advance of deadlines * Required Skills * Experience in designing and documenting conversion and interface specifications Extensive knowledge and experience in Data Stage *(must have) *** ETL design and development skills and technical documentation experience Proven knowledge/experience in ETL performance tuning 8+ years experience with ETL and data quality tools 8+ years with IBM¿s Data Stage suite of products Demonstrated experience in SQL and RDBMS, including MS SQL Server and Oracle Excellent analytical skills, detail and process-oriented Proven ability to coordinate activities with business and technical teams Excellent communication skills Prior experience working on large IT vendor supplied COTS deployment projects for the Education or Government preferred Page *3 *of *4 **** Desired Skills * Prior experience working with Commercial off the Shelf (COTS) developed for an education/government organization. Education experience, Knowledge of Special Education is preferred. Knowledge and experience in managing data warehouse and ODS development design, analysis, capability and deployment. Experience with SQL, T-SQL, PL/SQL and DTS in SQL Server Demonstrated experience in all facets of the Software Development Life Cycle using an iterative development approach such as Agile, including all forms of threat/risk assessment to ensure the software meets the goal of being secure for sensitive information. Must be self-sufficient in Microsoft Office, Project and SharePoint Portal Services. The successful candidate must possess the ability to build document templates and customize SharePoint portal services to the needs of the project. Support the Vendor¿s analysis, design, build, test and documentation of the complex SESIS Data Conversion and Integration solutions Support user acceptance test activities for the SESIS Data Conversion and Integration solutions -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" 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/us_itgroups. For more options, visit https://groups.google.com/groups/opt_out.
