Sr. ETL Developer

Droisys; Santa Clara (CA); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading technology consulting firm is seeking a Sr. ETL Developer with a strong background in Informatica Powercenter and Data Warehousing. The ideal candidate will have over 8 years of experience in ETL processes, database management systems, and BI tools. Responsibilities include administering ETL tasks, designing data models, and collaborating with business users. This role requires expertise in Agile methodologies and a solid understanding of data architecture. Competitive salary and a supportive work environment are offered.

Qualifications

• 8+ years of hands-on experience in ETL and Business Intelligence environments.
• Strong practical knowledge of Data Warehousing aspects.
• Experience in collaborating with business users to gather requirements.

Responsibilities

• Administer, maintain, and develop ETL processes using Informatica.
• Design and implement multi-dimensional models using SSAS.
• Provide Production Support operations with a strong sense of urgency.

Skills

Informatica Powercenter ETL

Data Warehousing design

ETL Data movement

SQL Server

Oracle

Agile methodology

Business Intelligence (BI) tools

Education

Bachelor’s degree in Computer Science or related

Tools

Informatica

Cognos

SSAS

Job description

We are looking for consultants for the below mentioned requirement

Sr. ETL Developer

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 optimised 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 modelling 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.

Additional Information

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