Requirement: Senior ETL Developer in Albany, NY.
margaret valentina
if you have any profile send it to marg...@aim-cc.com ASAP....
Hello.
Position: Senior ETL Developer
Location: Albany, NY
Duration: 18 Months
Please note that this is a 35 hour work week.
Job Description:
The Senior ETL Developer will assist in the design and implementation of a vendor-supplied Special Education Student Information System (SESIS). The ETL Developer will focus on the data migration of multiple source systems (mix of legacy and distributed) to SESIS and develop and maintain interfaces between SESIS, ODS and the existing systems.
SESIS (Special Education Student Information System) is a COTS (Common off the Shelf) vendor-supplied, configured and managed solution that will be used to track the full case-cycle of a student requiring Special Education Services within New York City. Our Client currently manages over 190,000 special education students in over 1500+ public schools. Our Client currently tracks students using a mix of custom legacy solution and small distributed web applications.
The Senior ETL Developer will be responsible for, but not limited to, the following:
- Work with the DIIT (Division of Information and Instructional Technology) Data team to facilitate the implementation of SESIS Data Architecture
- 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
- 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 vendor fully understands the requirements and the data necessary to support those requirements
- Develop, Test and manage ETL jobs to specifications and design
- Escalate critical technical issues and potential problems as needed to the SESIS Project Manager to address any SESIS related issues in advance of deadlines
- Participate in focus group sessions as needed for information discovery
Required Skills
- Demonstrated experience in designing and documenting conversion and interface specifications
- ETL design and development skills and technical documentation experience
- Proven knowledge/experience in ETL performance tuning
- 6+ years experience with ETL and data quality tools
- 3+ years with IBM’s Data Stage suite of products
- Sound knowledge of SQL and RDBMS, including MS SQL Server and Oracle
- Proven ability to produce high quality, bug free and highly scalable work
- Excellent analytical skills, detail and process-oriented
- Proven ability to coordinate activities with business and technical teams
- Excellent communication skills
- Prior experience with Legacy data conversion and cleansing highly preferred
Desired Skills
- Prior experience working on large IT vendor supplied Commercial Off the Shelf (COTS) deployment projects for the Education or Government.
- Education (K -12) experience, especially knowledge of Special Education is preferred.
- Knowledge and experience in managing data warehouse and ODS development design, analysis capability and deployment.
- 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.
Thank you for your time and have a great day!
Thanks and Regards,
Margaret Valentina
Technical Recruiter
Aim Computer Consulting
Note: This is not an unsolicited mail. If you are not interested in receiving our e-mails then please click “Remove"