Role : ETL Developer
Location : King of Prussia,PA
Duration : 4 Months
Rate : $50/hr On C2C (Max)
Required Skills :
Informatica or DataStage
Basic Qualifications:
Good communication, the ability to speak to their experience, collaborate with multiple groups and work in an environment that is constantly changing are all imperative for this role.
Additional Skills:
We have direct contact & a good relationship with the hiring manager: Local candidates will be given precedent, because the hiring manager would like to these candidates to attend an on-site interview. PLEASE be certain that your candidates have not been submitted to eBay already. There are THREE SPOTS on this team.
Job Description :
Project Overview :
We are looking for talented people to join our Services Delivery Technology team. Our Database/ETL/BI developers contribute to all phases of the development of solutions for our clients including: discovery, specification, implementation and support. The successful candidate will be an experienced database/ETL/BI developer with 5+ years of experience in the I.T industry and can perform business relevant analysis in an applied environment.
Responsibilities :
- Development and implementation of Data Integration (ETL) and BI programs to support different partners and different initiatives.
- Work with the technology project teams to implement new functionality to support business needs.
- Implement technical data requirements for integrating partner data to be used for marketing campaigns.
- Develop, maintain and support the data exchange process between GSI and email service provider to support campaign management ensuring data quality and integrity.
- Importing client data files into Oracle (10g) databases.
- Processing large data files in a UNIX environment.
- Writing scripts, functions and stored procedures using SQL or Oracle PL/SQL.
- Performing quality assurance checks.
- Updating databases to ensure data integrity.
- Provide technical support and respond to error reports, problems or questions.
- Adhere to defined SLA’s for project delivery.
Qualifications :
- Years of experience: 5+ years.
- BS/BA in Computer Science or related discipline required.
- At least 5 years of technical experience with databases, data warehousing and BI tools .
- 3 years of experience with ETL tools like Informatica, Datastage, Sagent etc.
- 3 years of experience with reporting and analytics tools – OLAP tools, Business Objects, Cognos, Microstrategy.
- 3 years Oracle Database and Oracle PL/SQL experience.
- 2 years of Autosys or any automation tool experience.
- Experience with Unix/Linux shell scripting, java programming preferred but not essential.
- Strong understanding of relational database concepts technology – data modeling (dimensional/snowflake), SQL, query optimization, data warehouse architecture.
- Experience with setup, configuration, design best practices, performance optimization, team based development approaches with a leading ETL/BI tool.
- Familiarity with email marketing concepts, practices and programs is a plus.
- eCommerce, Retail, Supply Chain Management experience preferred, but not required.
- Well organized and able to manage multiple projects in a fast paced demanding environment.
- Attention to detail and quality; excellent problem solving and communication skills.
- Ability and willingness to learn new tools and applications.
- Effective written and verbal communication skills with ability to convey complex technical concepts to business users and management.