Sr. ETL Developer

Reposted 20 Days Ago
Santa Clara, CA, USA
In-Office
Senior level
Information Technology • Consulting
The Role
Looking for a Sr. ETL Developer with 8+ years of experience in ETL and data warehousing design, particularly with Informatica Powercenter and business intelligence tools, to manage and develop ETL processes and collaborate with business users.
Summary Generated by Built In
Job Description

Hi

We are looking for consultants for the below mentioned requirement

Sr. ETL Developer

Santa Clara, CA

6+ Months

MINIMUM 8+ YEARS OF EXPERIENCE REQUIRED

Description

Sr. ETL Developer with expertise in Informatica Powercenter ETL, Cognos BI, and SSAS. Ideal candidate will possess strong data warehousing design skills, solid experience in informatica and ETL Data movement, knowledge of business intelligence architecture & implementing best practices.

Skills and Abilities:

8+ years of hands-on experience in administering, maintaining, Developing ETL and Business Intelligence environments using Informatica Powercenter.

Strong practical knowledge and understanding of Data Warehousing aspects including data modeling ETL, SSAS Cubes and reporting.

Experience in developing and automating highly optimized ETL processes using Informatica ETL tool is a must

High level of proficiency in database management systems (SQL Server and Oracle) is required.

Experience in designing and implementing multi-dimensional models, including the construction of Data marts, Dimensions and Cubes using SSAS is required

Experience with Production Support operations with strong sense of urgency to customer issues is a must

Strong knowledge in designing and developing dimensions and facts using dimensional modeling and STAR schema standards is required

Experience in collaborating directly with business users to gather requirements and come up system solutions is a must

Strong understanding and proficiency in project management especially in Agile methodology is required. 

Deep experience implementing, ETL principles and best practices, including error handling, logging & alerting, scheduling and job control is required

Demonstrated proficiency with Business Intelligence (BI) tools and best practices. 

Thorough understanding of data architecture and database designs (ERD Diagrams) is a must

Strong writing and presentation skills that facilitate user requirements/design discussions and design reviews is required

Nice to Have:

Working with JDE ERP systems a huge plus.

Working knowledge of Cognos reporting tools is a huge plus

Experience working in manufacturing and bio-tech companies is a plus

Working knowledge of SalesForce is desired.

Minimum Qualifications:

Bachelor’s degree or foreign equivalent in Computer Science, Information Technology, Engineering, Mathematics or related

8 year’s extensive experience in Data Warehousing, Databases and BI tools and technologies.

5 or more years of experience using relational database e.g. Oracle, SQL Server etc.

--

Thanks/Regards

Ruchie Agarwal

Desk: 408-874-8333 Extn. 299

Cell : 408-543-9574

Skype : ruchi.droisys

Address: 4800 Patrick Henry Dr., Santa Clara, CA 95054

ruchie.a @ droisys.com | www.droisys.com | Join Droisys Group

“Don’t wait for the perfect moment.

Take the moment and make it perfect”

Additional Information

All your information will be kept confidential according to EEO guidelines.

Skills Required

  • 8+ years of experience in ETL and Data Warehousing
  • Expertise in Informatica Powercenter ETL
  • Proficiency in SQL Server and Oracle Database management
  • Experience with SSAS Cubes and reporting
  • Strong knowledge of project management, especially Agile methodology
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
504 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account