ETL/Data warehouse/Data Lake Developer

2 weeks ago


New York, NY, United States Suncap Technology Full time

With 10+ over all .At least 5 years of experience as ETL Developer.

  • Develop complex data pipelines to bring data into the Data Lake/Warehouse per business requirements.
  • Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities.
  • Proficient in SQL and ETL processes, ETL and DB performance tuning.
  • Design and develop ETL process using SQL and Informatica to load data into data warehouse/ data lake on daily basis from various source applications on Oracle, SQL Server, Cloud Sources, and files.
  • Design the architecture to perform data management activities i.e., data extraction, transformation, and load (ETL) to enterprise data warehouse. Implement the data management solutions using SQL, SQL procedures, data management tools like Informatica IICS on Oracle exadata database.
  • Design the overall architecture to Extract, Transform and Load (ETL) data into data warehouse or data mart and data lake.
  • Oracle database full life cycle development including data modeling, database architecture, SQL and PL/SQL development, unit testing and support.
  • Expertise in PL/SQL Programming including Data Types, Cursors, Exception Handling Collections, Merge statements, Analytics Functions, Views, Materialized Views, Table Functions, Stored procedures, Functions and Packages, database triggers, mutating, Dynamic SQLs, External Tables, Performance Tuning, Object Programming, built in functions, joins, aggregate functions, Collections.
  • Working experience with ETL tool (Preferred - Informatica - IICS)
  • Develop data models and ER diagrams for existing and new databases.
  • Passionate about complex data structures and problem solving.
  • High attention to detail.
  • Ability to pick up new data tools and concepts quickly.
  • Maintain and improve already existing processes


  • New York, NY, United States Hudson Data Full time

    Job Title: Sr. Azure Data Engineer Location: NYC, NY Duration: Long Term W2 Role Job Description: The candidate should have hands-on experience with various Azure services including but not limited to Azure Data Factory, Databricks, Data Lake, and Power BI. They should be able to design, build, and maintain ETL pipelines, manage data lakes, and...


  • New York, NY, United States Concord IT Systems Full time

    Role: Data Warehouse Developer/Analyst (9+ years with Mortgage/House loans domain) Location: NYC, NY Long term Client: Infopeople/ NYS HCR Responsibilities Include (but not limited to): Extensive experience in architecting and designing solutions at Enterprise scale in Enterprise Data warehouse applications. Experience in the housing and financial sector is...


  • New York, NY, United States Concord IT Systems Full time

    Role: Data Warehouse Developer/Analyst (9+ years with Mortgage/House loans domain) Location: NYC, NY Long term Client: Infopeople/ NYS HCR Responsibilities Include (but not limited to): Extensive experience in architecting and designing solutions at Enterprise scale in Enterprise Data warehouse applications. Experience in the housing and financial sector is...


  • New York, NY, United States Concord IT Systems Full time

    Role: Data Warehouse Developer/Analyst (9+ years with Mortgage/House loans domain) Location: NYC, NY Long term Client: Infopeople/ NYS HCR Responsibilities Include (but not limited to): Extensive experience in architecting and designing solutions at Enterprise scale in Enterprise Data warehouse applications. Experience in the housing and financial sector is...


  • New York, NY, United States Concord IT Systems Full time

    Role: Data Warehouse Developer/Analyst (9+ years with Mortgage/House loans domain) Location: NYC, NY Long term Client: Infopeople/ NYS HCR Responsibilities Include (but not limited to): Extensive experience in architecting and designing solutions at Enterprise scale in Enterprise Data warehouse applications. Experience in the housing and financial sector is...


  • New York, NY, United States DS Technologies Full time

    About US: We are a company that provides innovative, transformative IT services and solutions. We are passionate about helping our clients achieve their goals and exceed their expectations. We strive to provide the best possible experience for our clients and employees. We are committed to continuous improvement and innovation, and we are always looking for...


  • New York, NY, United States programmers.io Full time

    Python Developer with ETL ExpLocation - New York City (Day 1 Onsite)Employment Type - FTEJob Description:Must Have:Three days in-person work in NYCCapable of devising ETL pipelines using Python from scratchAbility to independently write efficient and reusable code for ETL pipelinesExpert in OOP principles and conceptsExpert in data modeling concepts such as...


  • New York, NY, United States programmers.io Full time

    Python Developer with ETL ExpLocation - New York City (Day 1 Onsite)Employment Type - FTEJob Description:Must Have:Three days in-person work in NYCCapable of devising ETL pipelines using Python from scratchAbility to independently write efficient and reusable code for ETL pipelinesExpert in OOP principles and conceptsExpert in data modeling concepts such as...

  • ETL Big Data

    5 days ago


    New York, NY, United States Computer Task Group Full time

    CTG is seeking an experienced ETL Big Data Engineer to design and maintain ETL pipelines for our client in NYC.Duration: 12 months Key Responsibilities: Build and maintain Python-based ETL pipelines from scratch. Develop reusable, efficient code following OOP principles. Model data with schemas and entity relationships for data warehouses. Write and...

  • ETL Developer

    2 weeks ago


    New York, NY, United States Guru Schools Full time

    - Experience working with any ETL tool like Informatica / Ab Initio / DataSgtage development. - Experience working with PL/SQL Stored Procedures. - Good knowledge in Data Ware housing concepts - Experience working on Snowflake. - Experience migrating legacy data platforms to cloud and modern architecture. - Experience in ETL development of data pipelines/ETL...