EPRO Services, Inc. Logo

EPRO Services, Inc.

ETL Lead

Posted Yesterday
Be an Early Applicant
In-Office
Monterey Park, CA, USA
Senior level
In-Office
Monterey Park, CA, USA
Senior level
Lead ETL development in an onshore-offshore model. Design and implement data warehousing solutions and data models (dimensions, facts, SCD Type I/II/III). Hands-on development using Informatica Power Centre, MPP databases (GreenPlum/Teradata/Netezza), ELT, Unix shell scripting, SQL, and Autosys. Requires strong analytical skills and communication.
The summary above was generated by AI
Company Description

E*Pro Consulting service offerings include contingent Staff Augmentation of IT professionals, Permanent Recruiting and Temp-to-Hire. In addition, our industry expertise and knowledge within financial services, Insurance, Telecom, Manufacturing, Technology, Media and Entertainment, Pharmaceutical, Health Care and service industries ensures our services are customized to meet specific needs. For more details please visit our website www.epro-tech.com

Job Description


Overall 8+ experience folks having the Lead exp (and worked in onshore offshore model). 

Understanding and experience on DW concepts like Data Modeling, Dimension, Fact, Type-I, II and III etc. 

MPP databases experience like Green Plum, Teradata, Netezza etc. 

Hand –On/Development experience on Informatica suite of products (specifically ETL Informatica Power Centre). 

ELT understanding and WSR Red experience. 

Unix Shell Scripting, SQL and Autosys. 

Analytical skills and good Communication.

Additional Information

Similar Jobs

Yesterday
In-Office
Monterey Park, CA, USA
Senior level
Senior level
Professional Services • Industrial • Manufacturing
Lead ETL implementation and administration focused on the Informatica suite. Design and develop ETL processes for data warehousing, perform impact analysis, troubleshoot Informatica issues, and collaborate with stakeholders. Use UNIX shell scripting, SQL, and AutoSys to support production operations and ensure data integration in banking environments.
Top Skills: AutosysData WarehousingETLGreenplumInformatica IdqInformatica IdsInformatica PowercenterInformatica PowerexchangeOracleSQLUnix Shell Scripting
15 Hours Ago
In-Office
Torrance, CA, USA
Senior level
Senior level
Information Technology • Professional Services • Software • Consulting
Lead ETL testing for Data Warehouse/BI projects: define test strategy and design, execute and analyze tests, report results, use Informatica, BusinessObjects, SQL and HP-ALM, collaborate with global stakeholders.
Top Skills: BiBusinessobjectsData WarehouseETLHp-AlmInformaticaSQL
15 Hours Ago
In-Office
Los Angeles, CA, USA
Mid level
Mid level
Information Technology • Professional Services • Software • Consulting
Lead ETL development using Informatica for DW/BI projects. Design/implement ETL/ELT frameworks, perform dimensional modeling, troubleshoot data transformations, use Unix/shell scripting, collaborate with global stakeholders, and support full project lifecycle.
Top Skills: Data Transformation StudioData WarehouseDimensional ModelingDw/BiEltETLInformaticaInformatica B2BInformatica Data TransformationLinuxShell ScriptingUnix

What you need to know about the Los Angeles Tech Scene

Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.

Key Facts About Los Angeles Tech

  • Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
  • Key Industries: Artificial intelligence, adtech, media, software, game development
  • Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
  • Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account