Data Engineer (Informatica Expert)

Job Posted 16 Days Ago Posted 16 Days Ago
Mountain View, CA
Senior level
Information Technology • Consulting
The Role
The Data Engineer will develop and support ETL pipelines, design data models, maintain a data catalog, optimize SQL queries, and collaborate with stakeholders. The role involves mentoring team members, managing CI/CD pipelines, and ensuring data governance best practices.
Summary Generated by Built In

Job Brief:
We are seeking an experienced Informatica Expert to lead our efforts in data modeling and establish a disciplined approach to maintaining a data catalog for the organization. The ideal candidate will possess a deep understanding of enterprise-class data pipelines, data transformation, and data governance best practices. If you have a passion for working in agile teams and have expertise in Informatica PowerCenter, Intelligent Cloud Services (IICS/IDMC), and other ETL tools, we’d love to hear from you
VentureDive Overview:
Founded in 2012 by veteran technology entrepreneurs from MIT and Stanford, VentureDive is the fastest growing technology company in the region that develops and invests in products and solutions that simplify and improve lives of people world-wide. We aspire to create a technology organization and an entrepreneurial ecosystem in the region that are recognized as second to none in the world.
Key Responsibilities:

  • Develop, test, deploy, maintain, and support Informatica ETL pipelines for Enterprise Data Warehouses, Data Marts, and Operational Data Stores.
  • Design and implement data modeling strategies, ensuring alignment with business requirements and industry standards.
  • Establish and maintain a robust data cataloging discipline, ensuring comprehensive metadata management and data lineage documentation.
  • Perform advanced data cleansing, transformation, merging, change data capture, and reconciliation.
  • Collaborate with business stakeholders to gather and understand requirements, and translate them into technical specifications.
  • Optimize SQL queries and perform SQL tuning to enhance data pipeline performance.
  • Work within Agile/Scrum teams to deliver scalable and reliable data solutions.
  • Provide mentorship and performance improvement guidance to team members.
  • Develop and manage CI/CD pipelines, ensuring smooth integration and deployment using GitHub or other version control systems.
  • Schedule and monitor workflows using Informatica and batch scripting tools.
  • Prepare comprehensive documentation, including design specs, test cases, and operational guidelines.


Qualifications and Experience:

  • 5+ years of experience developing enterprise-class data pipelines using Informatica PowerCenter, SQL Server, and Control-M.
  • 3+ years of hands-on experience with Informatica Intelligent Cloud Services (IICS/IDMC).
  • Expertise in building and designing ETL pipelines for various data storage solutions like Data Warehouses, Data Marts, and Operational Data Stores.
  • Advanced knowledge of SQL (T-SQL, DB2 SQL) with strong skills in stored procedures, packages, triggers, and views.
  • Proven experience in Dimensional Modeling and strong understanding of Data Warehousing concepts.
  • Experience with all aspects of ETL process design, including performance tuning and SQL plan analysis.
  • Familiarity with batch scripting on Windows and scheduling workflows with automation tools.
  • Proven ability to lead efforts in data governance and establish best practices for maintaining a data catalog.
  • Experience in version control practices and CI/CD pipelines using GitHub or similar tools.
  • Strong communication and problem-solving skills, with the ability to work both independently and collaboratively.


Preferred Skills:

  • Experience with databases in an enterprise environment.
  • Familiarity with Informatica workflow scheduling and monitoring tools.
  • Exposure to large-scale data migration or modernization projects.
  • Hands-on experience in Agile environments with a focus on iterative development.


In order to thrive at VentureDive, you
…are intellectually smart and curious
…have the passion for and take pride in your work
…deeply believe in VentureDive’s mission, vision, and values
…have a no-frills attitude
…are a collaborative team player
…are ethical and honest
Are you ready to put your ideas into products and solutions that will be used by millions?
You will find VentureDive to be a quick pace, high standards, fun and a rewarding place to work at. Not only will your work reach millions of users world-wide, you will also be rewarded with competitive salaries and benefits. If you think you have what it takes to be a VenDian, come join us ... we're having a ball!
#LI-Hybrid

Top Skills

Informatica
SQL
The Company
HQ: Mountain View, California
379 Employees
On-site Workplace
Year Founded: 2012

What We Do

VentureDive is an award-winning digital development company that builds cutting-edge technology solutions to improve lives globally. Since its inception in 2012, the firm has enabled two tech unicorns and successfully driven digital transformation initiatives for large enterprises. Led by co-founders Atif Azim and Shehzaad Nakhoda, VentureDive has a presence in Silicon Valley, London, Portugal, Dubai, and Pakistan. To learn more, visit https://www.venturedive.com.

Similar Jobs

The Walt Disney Company Logo The Walt Disney Company

Lead Data Engineer

AdTech • Digital Media • News + Entertainment
Hybrid
Sacramento, CA, USA
200000 Employees

Atlassian Logo Atlassian

Senior Data Engineer

Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Remote
San Francisco, CA, USA
11000 Employees
136K-218K Annually

Navan Logo Navan

Data Engineer

Fintech • Information Technology • Payments • Productivity • Software • Travel • Automation
Easy Apply
Hybrid
Palo Alto, CA, USA
3000 Employees
94K-165K Annually

SoFi Logo SoFi

Senior Data Engineer, FROST

Fintech • Mobile • Software • Financial Services
Easy Apply
5 Locations
4500 Employees

Similar Companies Hiring

Quantum Rise Thumbnail
Software • Professional Services • Natural Language Processing • Machine Learning • Consulting • Automation • Artificial Intelligence
Chicago, Illinois
17 Employees
Stepful Thumbnail
Software • Healthtech • Edtech • Artificial Intelligence
New York, New York
60 Employees
HERE Technologies Thumbnail
Software • Logistics • Internet of Things • Information Technology • Computer Vision • Automotive • Artificial Intelligence
Amsterdam, NL
6000 Employees
By clicking Apply you agree to share your profile information with the hiring company.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account