ETL Developer

6 months 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 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 Developer

    4 weeks ago


    Foster City, CA, United States Cloud Analytics Technologies LLC Full time

    Role: Sr. ETL Developer Location: Foster City, CA Duration: 6 Months Experience: 7+ Years Rate: $55/hr on C2C (MAX) Job Description: - 3-5 years of experience - Sr. Analyst or Sr. Consultant level resource - Experience with Informatica ETL - Experience in Data Integration into OBIEE - Deep understanding of OBIEE data model and constraints -...

  • ETL Developer

    6 days ago


    Jersey City, United States Overture Partners Full time

    ***Please no third parties at this time***Role OverviewWe are seeking an experienced ETL/DevOps Specialist to lead the migration of our Legacy Data Warehouse (DW) to the Cloud. This is a critical role involving equal parts ETL development and DevOps pipeline management, requiring strong technical expertise and leadership skills to drive this high-impact...

  • ETL Developer

    6 days ago


    Jersey City, United States Overture Partners Full time

    ***Please no third parties at this time***Role OverviewWe are seeking an experienced ETL/DevOps Specialist to lead the migration of our Legacy Data Warehouse (DW) to the Cloud. This is a critical role involving equal parts ETL development and DevOps pipeline management, requiring strong technical expertise and leadership skills to drive this high-impact...


  • Culver City, California, United States Diverse Lynx Full time

    Role: ETL DataStage DeveloperAt Diverse Lynx LLC, we are seeking an experienced ETL DataStage Developer to join our team. As a key member of our data warehousing team, you will be responsible for designing and developing ETL workflows using DataStage.Responsibilities:Design and Develop ETL Workflows: Utilize your expertise in DataStage to design and develop...


  • Culver City, California, United States Diverse Lynx Full time

    Job Description:As a Datastage ETL Developer at Diverse Lynx LLC, you will be responsible for designing and developing ETL workflows using Datastage. With a strong background in technical and functional skills, you will work on large DW implementations and have hands-on experience working on AWS. Additionally, you will have experience working with large...

  • ETL Developer

    2 months ago


    Jersey City, United States CRISIL Limited Full time

    About CRISIL GR&A: CRISIL Global Research & Analytics (GR&A) is the largest and top-ranked provider of high end research and analytics services to the world's leading commercial and investment banks, insurance companies, corporations, consulting firms, private equity firms and asset management firms. CRISIL GR&A operates from centres in Argentina, China,...


  • Jersey City, United States Diverse Lynx Full time

    Job title: ETL DeveloperLocation: Jersey City, NJJob Type: Contract RoleJob description: Need ETL Developer with IBM InfoSphere DataStage. Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of...


  • Culver City, California, United States Diverse Lynx Full time

    About the RoleWe are seeking a highly skilled Datastage ETL Developer to join our team at Diverse Lynx LLC. This is a full-time, permanent position that requires expertise in designing and developing ETL workflows using Datastage.The ideal candidate will have experience working with Python, large DW implementations, and cloud-based data warehouse solutions...


  • Jersey City, New Jersey, United States Infojini Full time

    **About Us**: Infojini is a leading provider of innovative data solutions. We are seeking an experienced Informatica PowerCenter Developer to join our team.**Job Overview**:We offer a competitive salary of $120,000 per year for this position. As an Informatica PowerCenter Developer, you will be responsible for designing, developing, testing, and maintaining...


  • Jersey City, New Jersey, United States Diverse Lynx Full time

    Datastage Developer Job Summary:Diverse Lynx LLC is hiring a skilled ETL Developer to work on various projects using IBM InfoSphere DataStage. The ideal candidate will have experience with ETL development, strong analytical skills, and excellent problem-solving abilities.**Job Details:*** Estimated Salary: $95,000 per year* Work Location: Jersey City, NJ*...

  • ETL PDI Developer

    3 hours ago


    Jersey City, United States Aegistech, Inc. Full time

    Job Description: An ETL PDI Developer job is available with or client, a major data analytics firm, located in Jersey City, NJ. This is a hybrid, contract role. Please Note: Candidates MUST be Aegistech's W2. PRIMARY RESPONSIBILITIES: Responsible for the development, design and implementation of new or modified software products or ongoing business...


  • Culver City, United States Diverse Lynx Full time

    Role: ETL DataStage Developer Location: Culver City, CA (Onsite) Job Description Must Have Technical/Functional Skills Industry - Media & Entertainment or/and Consumer Packaged Goods with Retail Execution Experience of designing and developing ETL workflows using DataStage Experience working with Python. Experience working in large DW implementations ...


  • Culver City, United States Diverse Lynx Full time

    Must Have Technical/Functional Skills • Industry - Media & Entertainment or/and Consumer Packaged Goods with Retail Execution • Experience of designing and developing ETL workflows using DataStage • Experience working with Python. • Experience working in large DW implementations • Experience working on Datawarehouse implementations in cloud...


  • Culver City, California, United States Diverse Lynx Full time

    At Diverse Lynx LLC, we are seeking a highly skilled Datastage ETL Developer Expert to join our team. As a key member of our IT department, you will be responsible for designing and developing complex ETL workflows using DataStage. With a strong background in Python and experience working with large DW implementations, you will play a crucial role in...

  • ETL Process Developer

    3 weeks ago


    Jersey City, New Jersey, United States Diverse Lynx Full time

    About UsDiverse Lynx LLC is a dynamic and inclusive employer that values diversity and promotes equal opportunities for all qualified applicants. We are committed to creating a workplace culture that fosters innovation, creativity, and teamwork.Salary RangeThe estimated annual salary for this position is $140,000 - $200,000, depending on experience and...

  • ETL PDI Developer

    7 hours ago


    Jersey City, United States Aegistech Full time

    An ETL PDI Developer job is available with or client, a major data analytics firm, located in Jersey City, NJ. This is a hybrid, contract role.Please Note: Candidates MUST be Aegistech’s W2.PRIMARY RESPONSIBILITIES:Responsible for the development, design and implementation of new or modified software products or ongoing business projects.Work closely with...

  • ETL PDI Developer

    14 hours ago


    Jersey City, United States Aegistech Full time

    An ETL PDI Developer job is available with or client, a major data analytics firm, located in Jersey City, NJ. This is a hybrid, contract role.Please Note: Candidates MUST be Aegistech’s W2.PRIMARY RESPONSIBILITIES:Responsible for the development, design and implementation of new or modified software products or ongoing business projects.Work closely with...

  • ETL Process Developer

    2 weeks ago


    Jersey City, New Jersey, United States Infojini Full time

    Job Description:We are looking for an experienced ETL process developer to join our team at Infojini. As an Informatica PowerCenter Developer, you will be responsible for designing, developing, testing, and maintaining ETL processes using Informatica PowerCenter. You will work closely with business analysts, data architects, and other team members to support...

  • ETL Developer

    11 hours ago


    City of Albany, United States Vistrada LLC Full time

    Thanks for visiting our Job Board.Please review our open positions and apply to the positions that match your qualifications.Vistrada is seeking a highly motivated and experienced candidate to serve as an ETL Developer / Data Architect on our Business Intelligence ("BI") team supporting key clients. In this role, you will help address operational challenges...


  • Culver City, United States Centraprise Full time

    Position : ETL Datastage Developer Location : Culver City, CA Duration : Fulltime Permanent Complete Onsite Must Have Technical/Functional Skills : • Industry - Media & Entertainment or/and Consumer Packaged Goods with Retail Execution • Experience of designing and developing ETL workflows using DataStage • Experience working with Python. •...