Full-Time

ETL Architect

360 IT Professionals

360 IT Professionals

11-50 employees

Software development, mobile/web, and Salesforce solutions

No salary listed

Southfield, MI, USA

In Person

Category
Data & Analytics (1)
Required Skills
SQL
ETL
Informatica
Oracle
Requirements
  • 15-17 years of experience in data warehousing or related field
  • 12 to 16 years of Informatica ETL development experience
  • At least 4 years of experience as Informatica ETL Architect
  • At least 8-10 years of experience with Informatica in a Developer/Tech Lead role
  • Mastery in data warehousing concepts
  • Strong SQL skills in an Oracle partitioned environment
  • Experience in Oracle database programming using partitioning, materialized views and OLAP
  • Experience in tuning Oracle queries/processes and performance management tools
  • Informatica PowerCenter 8.x and above (9.1 preferred)
  • Informatica tools such as PowerExchange and Data Quality (as part of tools & technologies)
  • Proficient in scheduling tools such as Tivoli, Autosys, or Ctrl-M may be considered
  • Healthcare payer data warehousing knowledge is preferred
Responsibilities
  • Lead ETL architecture and design as well as data flow diagramming
  • Define and implement ETL development standards and procedures
  • Ensure ETL quality through code reviews and knowledge sharing
  • Develop a technical work plan and assign work and coordinate across multiple developers and projects
  • Assess requirements and define strategy, technical architecture, implementation plan and delivery of data warehouse projects
  • Communicate effectively with management and executives; lead teams and coordinate with stakeholders
  • Establish long-term strategy and short-term scope for a multi-phased data warehouse effort
  • Speak to and understand how healthcare systems work without being hands-on
  • Lead teams and work with management and executives
Desired Qualifications
  • Cognos and Business Objects experience preferred
  • Knowledge of Health Care Insurance Payer Data Warehousing preferred
  • Healthcare domain experience in payer data warehousing preferred

360 IT Professionals provides custom software development services, covering product development, mobile and web technologies, workforce solutions, and Salesforce cloud services. They build bespoke software tailored to each client, using a mixed team of seasoned experts and energetic new professionals guided by best practices in Silicon Valley. The company emphasizes ethical, agile collaboration to deliver high-value solutions that help clients become more productive and scalable. What sets them apart is their blend of experienced talent with fresh perspectives, a strong local presence in Fremont, CA, and a disciplined focus on delivering practical, business-focused results rather than generic tech features. Their goal is to be a trusted partner that helps clients evolve into more productive units by providing complete software development capabilities and end-to-end support.

Company Size

11-50

Company Stage

N/A

Total Funding

N/A

Headquarters

Fremont, California

Founded

2013

Simplify Jobs

Simplify's Take

What believers are saying

  • Clutch highly rates IT staffing and development services at $25-$49/hr.
  • Active hiring for 60 roles signals expansion in Fremont tech market.
  • $54.8M revenue from diverse tech stack including JavaScript and PHP.

What critics are saying

  • Poor Clutch reviews cause 70-90% market erosion in 3-6 months.
  • Google poaches 30% engineers leading to high turnover in 6-12 months.
  • AI platforms displace 60% revenue from PHP contracts in 12-24 months.

What makes 360 IT Professionals unique

  • Blends experienced and young professionals for innovative software solutions.
  • Specializes in .NET, PHP, Android, iPhone, and Salesforce cloud services.
  • Offers IT staffing, product development, and mobile technologies from Fremont.

Help us improve and share your feedback! Did you find this helpful?

Your Connections

People at 360 IT Professionals who can refer or advise you

Benefits

Remote Work Options