* * * *
* * *We are in the need for a ETL Developer with minimum 8 YRS Experienced , listed below is a snapshot of the skill set needed* *Need :Locals or Near by * *Location : Minneapolis – MN* *Client : State of MN * *Duration : 6+months * *F2F recuired* *Certification and lead Experience is PLUS AND EXCELLENT COMMUNICATION SKILLS 10/10 * * * *General Database Skills Working technical experience with relational database servers. Deep knowledge of SQL and experience with writing complex SQL statements. Understanding and experience with relational database design techniques, specifically with data warehousing background.* * * *Knowledge and at least 2 year of experience within the last 3years with logical or physical warehouse table modeling. Knowledge and some experience with SQL performance tuning and troubleshooting. Knowledge of how different data bases handle data types differently, for example date formatting and the padding of character fields.* * * * ETL Development At least 4 years of experience within the last 6 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 (check-in/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.* * * * Communication Skills Effective communication skills, both written and oral Strong technical documentation skills Proven analytical and problem solving skills Ability and experience with analysis and design of data warehouses* * * * 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 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.* * * *Thank you & Regards * *Steve Snider* ** *Work # : (720) 346-6377* *eFax # : (720) 235-0253* *Email : [email protected] <[email protected]> * *Yahoo IM : [email protected] <[email protected]> * *URL : www.micro2mega.com * *We are **E**-**Verified*** *Please consider the environment before printing this email . **Go Green ! * -- You received this message because you are subscribed to the Google Groups "KNOW.IT" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/know_it_az?hl=en.
