ETL Developer

3 days ago

Foster City, CA, United States BayInfotech Full time

The defined scope of work (SOW) includes Data Warehousing ETL (Extract, Transform and Load) and Report Development. Responsibilities and deliverables include:

• Develop and maintains the interfaces and data extracts from business source systems into the enterprise reporting systems using Informatica tool.
• Design and write programs and scripts required to extract, transform, clean and move data from the business systems into the PDMI data warehouse/data mart.
• Participate in requirement meetings with Business Analysts to understand analytical content needs. Assist in documenting these requirements, resolving ambiguities and conflicts, and ensuring requirements are complete.
• Work with end-users to help identify issues and to refine requirements.
• Develop detailed ETL specifications based on business requirements.
• Analyze functional specifications and assist in designing effective technical solutions.
• Identify data sources and works with source system developers, SMEs, and business owners to define data extraction methodologies.
• Work with Data / Data Warehouse Architect on logical and physical model designs.
• Work with Data Modeler to develop data warehouse models, design specifications, metadata process and documentation
• Utilize the Informatica ETL application and analyze data necessary to resolve issues uncovered and related to source data.
• Define, develop, document and maintain Informatica ETL mappings and scripts.
• Define, develop, document and maintain procedural and SQL programs.
• Develop ETL test plans and tests the ETL code following ETL standards and architecture.
• Assist in the development, execution and documentation of system and integration test plans.
• Perform ETL / Informatica tuning as well as SQL tuning.
• Optimize Informatica code performance and processing methods.
• Perform design validation, reconciliation and error handling in the load process (initial, incremental).
• Update and maintains ETL Metadata.
• Provide input into standards and best practices for code development.
• Write technical specifications and updates release documentation to reflect technical modifications.
• Perform impact analysis for systems/database modifications.
• Assist with and promotes continuous quality improvement throughout the lifecycle.

• Demonstrate success working in a team-based environment.

  • Sr. ETL Databricks Developer

    2 weeks ago

    Foster City, CA, United States E-Solutions Full time

    Job Title:: Sr. ETL Databricks Developer Onsite: Foster city,CA(Onsite) High level requirement: Senior ETL Databricks Developer with strong experience in designing and optimizing data pipelines using Databricks on AWS. The ideal candidate will have deep knowledge of Spark, Delta Lake, Python/Scala, and modern data lake architectures. Hands-on expertise with...

  • Sony Pictures/ ETL Developer

    2 weeks ago

    Culver City, CA, United States CData Software Full time

    Please share resumes for this position Job ID Account Name Skill Location Max Salary Range 292614 Sony Pictures ETL Developer Culver City, CA -onsite $90K - $120K Note for Vendors: Requirements to be worked upon shall only be received from TCS recruiters along with the JOB ID. Vendors must not work on any requirements without JOB ID or received from any...

  • Informatica MDM SaaS Developer

    2 days ago

    Foster City, CA, United States Right Skale, Inc. Full time

    Informatica MDM SaaS Developer A proficient Informatica MDM Developer with 2-3 years of experience in cloud-based MDM implementations. The focus is on Informatica MDM SaaS (cloud) solutions with exposure to Life Sciences Commercial data and integration with enterprise systems. Key Responsibilities: Configure and implement Informatica MDM SaaS solutions...

  • DataStage Developer

    7 days ago

    Culver City, CA, United States Syntricate Technologies Full time

    Required Skills: Experience Hands on working experience of at least 7-8 years working with IBM Datastage 11.5 and Quality Stage. Experience to migrate Datawarehouse platforms Hands on experience on developing ETL jobs using Datastage 11.5. Experience of working in projects which involve migrating Datawarehouse platforms. Strong working knowledge of...

  • Data Engineer

    2 weeks ago

    Foster City, CA, United States IEQ Capital Full time

    Who are we? IEQ Capital is a Registered Investment Advisor seeking to transform traditional wealth management. Our quest is to integrate the Intellectual and Emotional Quotient, generating exceptional investment results driven by a values-oriented culture that fosters connection and collaboration with our clients. We are an independent, predominantly...

  • Data Engineer

    2 weeks ago

    Foster City, CA, United States IEQ Capital Full time

    Who are we? IEQ Capital is a Registered Investment Advisor seeking to transform traditional wealth management. Our quest is to integrate the Intellectual and Emotional Quotient, generating exceptional investment results driven by a values-oriented culture that fosters connection and collaboration with our clients. We are an independent, predominantly...

  • Business Intelligence Engineer

    1 week ago

    Foster City, CA, United States ICONMA Full time

    Our Client, an AV Manufacturing company, is looking for a Business Intelligence Engineer for their Foster City, CA location. Responsibilities: Partner with technical and non-technical stakeholders to identify requirements and deliver automated, actionable data solutions. Design, build, and maintain scalable data models and ETL pipelines to ensure reliable,...

  • Project Manager

    7 days ago

    Foster City, CA, United States Tata Consultancy Services Full time

    Technical Project Manager Must Have Technical/Functional Skills • 812 years of experience in IT project/program management, with at least 35 years in data/analytics or BI projects. • Proven experience managing Power BI, Tableau, or MicroStrategy implementation or migration programs. • Strong understanding of data lifecycle ingestion, transformation...

  • Technical Project Manager

    2 weeks ago

    Foster City, CA, United States Diverse Lynx Full time

    Job Title: Technical Project Manager Location: Foster City, CA (Onsite) Duration: Fulltime Job Description Must Have Technical/Functional Skills • 8-12 years of experience in IT project/program management, with at least 3-5 years in data/analytics or BI projects. • Proven experience managing Power BI, Tableau, or MicroStrategy implementation or...

  • Business Intelligence Engineer

    2 weeks ago

    Foster City, CA, United States Manpower Engineering Full time

    Our client, a leading organization in the technology and transportation industry, is seeking a Business Intelligence Engineer to join their team. As a Business Intelligence Engineer, you will be part of the Data & Analytics Department supporting the System Design and Mission Assurance Teams. The ideal candidate will demonstrate strong analytical skills,...