*Please send profiles to [email protected]* Location: Minnesota(ONLY LOCALS)
Duration: 6 months Rate – must be low *PLEASE SEND PROFILES BEST MATCHES FOR REQUIREMENT* ** * Face to face interview required. Local candidates are preferred. Only submit candidates who can come for a face to face interview at their expense. * * * *REQUIRED SKILLS* * * • At least 2 years of experience within the last 3 years in ETL development with Informatica PowerCenter. • Experience in sourcing data from relational databases. • Experience writing to SQL Server and using the SQL Server bulk load options within Informatica PowerCenter. • Experience with identifying and following best-practices in ETL design and development within the Informatica PowerCenter suite. These include, but are not limited to 1) restart logic, 2) error handling, 3) job tuning, including parallelism and partitioning, 4) use of version control (checkin/check-out), 5) development through production migration strategies, 6) managing rejected records, 7) migrations to production without any code changes being required, 8) notification (via email) of job success and failure. • Knowledge and experience of both unit and system testing phases of ETL development. *Desired Skills:* *ETL Development* • Knowledge and experience working with Informatica PowerCenter 8.1 or higher. • Experience with sourcing data through Informatica from DB2, Sybase and SQL Server. • Experience with Informatica’s mapping tool for Visio. • Experience with running PowerCenter jobs through the command line and integrating the jobs into an external scheduler. (The Data Warehouse Designer/Developer will not need to run the external scheduler, but must define the commands needed to run their jobs through the scheduler.) • Experience and knowledge of IDQ. Experience working in the government and/or public sector. • Knowledge of taxes is a plus. -- Thomas Dwlabs Inc Direct-732-231-7393 Fax-732-348-9590 [email protected] www.dwlabs.com
