ETL Developer

3 weeks ago


Foster City, California, 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.

  • Power BI Developer

    2 weeks ago


    Culver City, California, United States aKube Inc Full time

    Job DescriptionCity:Culver City, CAOnsite/ Hybrid/ Remote:Hybrid, 2-4 days a week.Duration:12 months with potential to extendRate Range: $62/hr to $67/hr on W2 depending on experience (no C2C or 1099 or sub-contract)Work Authorization: GC, USC, All valid EADs except H1bPower BI Developer for AppDev Platform Engineering team to work on Operational...

  • ETL Developer

    2 weeks ago


    Foster City, 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...

  • ETL Developer

    2 weeks ago


    Jersey City, United States Ask Staffing Full time

    Client: MizuhoLocation: ISELIN, NJ 08830 Onsite/remote schedule - 2 days/week onsitePay Range : 85 to 90 / Hr.ROLE SITS IN METROPARK (ISELIN, NJ) Manager contact - robert.smyth@mizuhogroup.com Onsite/remote schedule - 2 days/week onsite Migrate existing SSIS ETL scripts to Python; develop new ETL scripts Support existing SSIS SQL Projects Maintain ETL...


  • Jersey City, United States Diverse Lynx Full time

    Role: ETL informatica developer Experience: 8+ Year Location: New Jersey Duration: 12+ Months Job Title Informatica / SAP BODS / Any ETL Tool Developer Relevant Experience (in Yrs) 5 + Years Technical/Functional Skills Refer to Roles & Responsibilities Experience Required 5+ Years Roles & Responsibilities 5+ years of experience in ETL tools, repository...


  • Jersey City, United States Diverse Lynx Full time

    Role: ETL informatica developer Experience: 8+ Year Location: New Jersey Duration: 12+ Months Job Title Informatica / SAP BODS / Any ETL Tool Developer Relevant Experience (in Yrs) 5 + Years Technical/Functional Skills Refer to Roles & Responsibilities Experience Required 5+ Years Roles & Responsibilities 5+ years of experience in ETL tools, repository...

  • ETL Lead

    2 weeks ago


    Texas City, United States eTeam Full time

    Job Summary: The Lead ETL Architect/Lead is responsible for the design, develop, test and implement of current and future data warehouse, business intelligence solutions and data migration projects. This position is responsible for leading the Extract, Transform, and Load (ETL) development activities and ensuring quality of ETL code. The Lead ETL Data...

  • ETL Lead

    4 days ago


    Texas City, United States eTeam Full time

    Job Summary: The Lead ETL Architect/Lead is responsible for the design, develop, test and implement of current and future data warehouse, business intelligence solutions and data migration projects. This position is responsible for leading the Extract, Transform, and Load (ETL) development activities and ensuring quality of ETL code. The Lead ETL Data...

  • HR Manager

    1 month ago


    Ohio City, United States Integration Developer Network Full time

    Provides development expertise and supports the infrastructure (.NET Applications MS-SQL databases and Windows Servers) for all applications focusing on the Health Services Planning Unit (HSP) applications. Design develop test and implement enterprise-strength C#/.Net Web applications and database queries. Modifications and enhancements for HSP web...


  • Texas City, United States Georgia IT Inc Full time

    Position: ETL Architect Location: Houston, TX ( Day-one Onsite) Rate: DOE US Citizens and those authorized to work in the U.S are encouraged to apply. Open for Thrid party H1B. Job Description: Ten years of previous experience required (including four years of experience as a Technical Data Architect. Extensive expertise in data modeling and design of...


  • Jersey City, United States Resource Informatics Group Inc Full time

    Job DescriptionJob DescriptionTitle: ETL Technical Architect with State or Public sector experienceDuration :1 yearRate: DOERemote Job description Having public sector project exp would be added advantage. Daily Tasks include:Lead efforts in identification and analysis of Data Requirements to drive data models and data structures.Identify business rules...


  • Foster City, United States Royalty Staffing Full time

    Royalty Staffing is helping an on-demand, autonomous ride-hailing company hire an experienced Business Intelligence Administrator to manage and maintain company data stack tools.In this role, you will be responsible for various duties that will include user management, data modeling/ETL, building pipelines, system configuration, security and providing...


  • Foster City, United States Royalty Staffing Full time

    Royalty Staffing is helping an on-demand, autonomous ride-hailing company hire an experienced Business Intelligence Administrator to manage and maintain company data stack tools.In this role, you will be responsible for various duties that will include user management, data modeling/ETL, building pipelines, system configuration, security and providing...


  • Foster City, United States Royalty Staffing Full time

    Royalty Staffing is helping an on-demand, autonomous ride-hailing company hire an experienced Business Intelligence Administrator to manage and maintain company data stack tools.In this role, you will be responsible for various duties that will include user management, data modeling/ETL, building pipelines, system configuration, security and providing...

  • Ab Initio developer

    4 days ago


    Texas City, United States Smart TechLink Solutions Inc. Full time

    Job Summary: Were in the middle of transforming a high volume, highly visible, mission critical Big Clinical Measure batch application from an On-Prem Hadoop platform (native Hadoop tools w/ C++ core) to a containerized solution on the GCP platform using AbInitio (w/ the C++ core.). We are seeking an experienced Ab Initio developer who have done...

  • SQL Developer

    1 month ago


    Texas City, United States Cyber Chasse Full time

    Responsibilities Serves as the principal point of contact for SSIS T-SQL and SSRS developments. Works with business stakeholders to define requirements for ETL and SSRS Reporting needs. Develops and implements data integration flows (ETL) using SQL Server Integration Services. Creates and modifies complex reports within SQL Server Reporting Service;...

  • IDQ Developer

    2 weeks ago


    Ohio City, United States Saxon Global Full time

    Client: Paramount Movies Position: IDQ Developer Location: Columbus, OH Hybrid (2 days Onsite, 3 days wfh.) Duration: 12+ months Rate: $60-65/hr. on C2C Visa: All • Key Skill: Informatica IDQ • Informatica Analyst (knowledge on Profiles and Scorecards) • Good Knowledge of ETL and Data Quality Concepts, knowledge of basic concepts of Java...

  • IDQ Developer

    4 days ago


    Ohio City, United States Saxon Global Full time

    Client: Paramount Movies Position: IDQ Developer Location: Columbus, OH Hybrid (2 days Onsite, 3 days wfh.) Duration: 12+ months Rate: $60-65/hr. on C2C Visa: All • Key Skill: Informatica IDQ • Informatica Analyst (knowledge on Profiles and Scorecards) • Good Knowledge of ETL and Data Quality Concepts, knowledge of basic concepts of Java...

  • Sr BI Developer

    2 weeks ago


    Texas City, United States Saxon Global Full time

    ESSENTIAL JOB FUNCTIONS To perform this job successfully, an individual must be able to satisfactorily perform each essential function listed below. • Design and develop ETL scripts using SQL, T-SQL or a leading edge data integration tool like SSIS • Must have experience working in building Data Warehouses and Data Marts. • Understand data...


  • Foster City, California, United States Royalty Hospitality Staffing Full time

    Job description Royalty Staffing is helping an on-demand, autonomous ride-hailing company hire an experienced Business Intelligence Administrator to manage and maintain company data stack tools. In this role, you will be responsible for various duties that will include user management, data modeling/ETL, building pipelines, system configuration, security...

  • Informatica Developer

    1 month ago


    Texas City, United States Ardoritsolutions Full time

    Informatica DeveloperMultiple locationsJob DescriptionInformatica is a software tool necessary to support all the steps like extraction transformation and load processes. It is a simple tool that is used by various organizations to do several things like data integration data warehousing data migration data management etc. The informatica developer...

  • Staff Data Engineer

    1 week ago


    Foster City, California, United States Visa Full time

    Job Description This position will be part of VCA (Visa  Consulting & Analytics) function in building and maintaining global data assets and engineering solutions. We are looking expertise in data warehousing and building large-scale data processing systems by using the latest database technologies.  The Data Engineer takes responsibility for building and...