ETL Developer

Yoh has an immediate six (6) month contract opportunity for an ETL DEVELOPER to join our client in Newtown Square, PA.

JOB OVERVIEW:

Our client is seeking an owner of data. It is not just a task, it is a mission, and the end goal is to deliver something great. You are self-motivated and can take or see an opportunity to improve a product and run with it. Duties include, but are not limited to: Datamodelling, development and data analysis. Support our databases and data in a distributed multi-application environment. Discover and leverage sources of data to improve our products. Ideally our new teammate will have the ability to connect us to new data sources, tune our data machine to keep the team running at top speed, track the performance of our state of the art products and experiment with new technologies to make sure we're on top of the constantly changing online world.

Job Responsibilities:
- Assists application development teams with planning and implementing database changes as well as query/job optimization
- Assists in troubleshooting and maintaining structures and processes in the enterprise data warehouse
- Writes SSIS (SQL Server Integration Services) packages for data migration between and among transactional systems and ETL processing into the data warehouse
- Writes SSIS (SQL Server Integration Services) ETL packages for data migration
- Writes stored procedures, functions, triggers
- Performs ongoing performance tuning and optimization activities
- Planning, implementation, and documentation of Microsoft SQL Server 2005/2008/2012 environments
- Assist in the definition and implementation of database standards

Job Qualifications:
- Bachelor's degree preferably in a technology field; equivalent experience may be considered
- Advanced knowledge of SQL Server ETL and general data transformation capabilities through tools such as SSIS and advanced application of stored procedures
- Good understanding of data warehousing practices and architecture, particularly star schema, bus Matrix and conformed dimensions methodologies
- Good working knowledge of SQL Server ETL and general data transformation capabilities through tools such as SSIS and advanced application of stored procedures
- Good working knowledge of SQL Server or similar transactional relational database system: security; backup and recovery capabilities; System and Database performance management; data architecture and capacity planning; disaster recovery planning and testing
- Strong Datamodelling skills and techniques
- Experience turning a logical process into code
- Working knowledge of SQL Server or similar relational database system: security; backup and recovery capabilities; System and Database performance management; data architecture and capacity planning; disaster recovery planning and testing
- Ability to move data around (one or more of: Shell Scripting, Perl, Python, PowerShell or similar)
- Ability to quickly learn new technologies
- Experience with big data solutions such as Hadoop and cloud-based environments such as Microsoft Azure a plus
- Experience with Microsoft Dynamics CRM a plus
- Experience with third-party ETL tools such as SCRIBE a plus

DISCOVER ALL THAT'S POSSIBLE WITH YOH. APPLY NOW.

RECRUITER: Greg Damiano

Yoh is a professional staffing provider with over 70 years of experience in the short and long-term staffing services industry; visit our website to learn more about our company.

Yoh, a Day & Zimmermann company, is an Equal Opportunity Employer, M/F/D/V.

Tax Term: CON_W2

J2W: INFOTECHJ2WBRPHIL

Ref:

Branch: IT & Telecom