HI Folks – Share resume at [email protected]
*Requirement: ETL Developer * Job duration: *10 months + 3x 12month extensions* Location: *Des Moines, Iowa* Interview type: *Skype/webcam* The rate is $45/hr c2c * * *Position Description: * This position will be a member of a team but will need to work independently. They will report to a Senior Architect/DBA but will require self-direction. Job responsibilities will span ETL development, data transformation and modeling. Job responsibilities will span ETL development/data transformation and database modeling with heavy data analysis skills. The candidate will be responsible for taking the project through the entire SDLC, working with the business users to determine the business requirements and apply the business rules to the data. This candidate should be an expert in creating, modifying and maintaining SSIS packages which will be used to move data from source systems to the data warehouse backend. Advanced skills in writing complex Structured Query Language (SQL) queries are required. Experience working with a large variety of data, demographic, personal, numeric data and identify normal ranges, outlier data, typical and non-typical data results. ETL developer that will make extensive use of data flow tasks that extracts large volumes of data from disparate data systems. • Proficient in development of SQL Server Integration Services (SSIS) packages. • Proficient using MS SQL 2005 or later and writing relationaldatabase queries and stored procedures using SQL. • Experience extracting data from a large variety of sources, transforming and loading to a SQL data warehouse • Evaluate and address data quality issues • Developing error checking and resolution routines • Experience in interacting with customers regarding application requirements. • Strong business writing and interpersonal skills necessary for customer contact..** * * * * *SKILL SET ASSESSMENT* *Position: ETL Developer Candidate Name: * * * *TECHNICAL SKILL* *REQUIRED/DESIRED* *MIN. YEARS * *YEARS DONE* *YR LAST USED* *PROJECT / TOOLS* Develop, modify and optimize SSIS packages *Required* *5* * * * * * * SQL 2005 *Required* *5* * * * * * * SQL 2008 *Required* *3* * * * * * * Experience building SSIS packages using build-in SSIS Components *Required* *5* * * * * * * Experience writing complex T-SQL *Required* *5* * * * * * * Experience analyzing, profiling, manipulating data from a large variety of sources *Required* *5* * * * * * * Experience loading data into a SQL Data Warehouse *Required* *5* * * * * * * Troubleshoot abstract data, profile, analyze and optimize data *Required* *5* * * * * * * Develop error checking and resolution routines *Required* *5* * * * * * * Data modeling experience *Required* *5* * * * * * * Analyze and optimize table design *Required* *5* * * * * * * Ability to work with end users to extract business requirements *Required* *5* * * * * * * Ability to analyze data and apply business rules and requirements *Required* *5* * * * * * * Agile project experience *Highly Desired* * * * * * * * * Regards...* *... *?* *K.M. Shukla * Resource Development Manager I Dynamic Software Services I 766 Sutter Street -13.San Francisco, CA- 94109| Phone: 415-259-5641 I Fax: 415-520-5437 [email protected] YIM: km.shukla [image: Description: Description: cid:[email protected]] Save. Note: This is not an unsolicited mail. If you are not interested in receiving our e-mails then please click Remove<[email protected]?subject=Remove> . -- You received this message because you are subscribed to the Google Groups "SRAOSS REKS" 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/sraoss-reks?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
