Data Warehouse ETL Developer
Omega Hires
Data Warehouse ETL Developer
Job Title: Data Warehouse ETL Developer
Summary: We are seeking a skilled Data Warehouse / ETL Developer with expertise in Informatica PowerCenter to design, develop, and maintain enterprise-level ETL solutions. The ideal candidate will have hands-on experience in data warehousing concepts, ETL processes, and strong problem-solving skills to ensure high-quality, timely, and accurate data integration.
Key Responsibilities:
- Design, develop, and deploy ETL mappings, workflows, and sessions using Informatica PowerCenter.
- Extract data from heterogeneous source systems (e.g., Oracle, SQL Server, flat files, SAP) and load into target data warehouse environments.
- Collaborate with business analysts and data architects to understand data requirements and translate them into efficient ETL solutions.
- Optimize ETL processes for performance, scalability, and maintainability.
- Conduct data validation, reconciliation, and troubleshooting to ensure data quality and integrity.
- Maintain ETL documentation, including data flow diagrams, technical specifications, and process design documents.
- Participate in code reviews, unit testing, and UAT support.
- Monitor ETL jobs and workflows, identify bottlenecks, and implement improvements.
- Provide production support and resolve data-related issues in a timely manner.
Required Skills and Qualifications:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- 8-10+ years of experience in ETL development using Informatica PowerCenter.
- Strong understanding of data warehousing concepts, dimensional modeling, and star/snowflake schemas.
- Experience with SQL, PL/SQL, and performance tuning of database queries.
- Knowledge of data quality, data governance, and best practices in ETL development.
- Strong analytical, problem-solving, and communication skills.
- Experience with version control systems and ETL deployment processes.
Preferred Qualifications:
- Exposure to real-time ETL and data streaming technologies.
- Knowledge of scheduling tools such as Informatica Workflow Manager and IBM Workload Automation.
Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Data Warehouse ETL Developer in United States vacancy
- ...: Hybrid Onsite: Tuesdays Wednesdays and Thursdays Work from Home: Mondays and Fridays JOB SUMMARY The Data Warehouse & ETL Developer designs develops maintains and supports enterprise data warehouse solutions and data integration processes primarily using...SuggestedFull timeWork from homeHome officeMonday to Friday
At Home Group
Coppell, TX1 day ago - ...Senior Data Warehouse DeveloperIdeal candidate for this role will not only help us procure, curate and model various transactional... ...performance.A Typical Day As A Senior Data Warehouse Developer:Design and develop ETL and reporting processes using SSIS/SSRS tools based on...Suggested
Mavens Guild
Chicago, IL4 days ago - ...Data Warehouse ETL Developer Job Title: Data Warehouse ETL Developer Job Summary: We are seeking a skilled Data Warehouse / ETL Developer with expertise in Informatica PowerCenter to design, develop, and maintain enterprise-level ETL solutions. The ideal candidate...SuggestedFull time
- ...looking for! New England Life Care is hiring a full-time Data Warehouse Developer to join our growing team! This hybrid position is full-... ...ideal candidate will possess strong SQL development skills, ETL experience, and expertise in dimensional modeling (star and...SuggestedFull timeTemporary workCurrently hiringLocal areaRemote workMonday to Friday
New England Life Care
Scarborough, MEa month ago - ...highly motivated and experienced candidate to serve as an ETL Developer / Data Architect on our Business Intelligence ("BI") team supporting... ...of Data / BI-oriented areas, including: Analytics data warehouse architecture design, development, and testing. ETL environment...SuggestedFlexible hours
VISTRADA
Albany, NY4 days ago - ...Qualifications: ● Passion for data and a deep desire to learn. ● Master’s Degree in Computer Science/Information Technology, Data Analytics... ...to meet the business needs. ● Design and implement scalable ETL or ELT processes to support the business demand for data. ●...
BeaconFire Inc.
Denver, CO14 hours ago - Data Engineer/Architect Southeast Wisconsin (Hybrid, 3 days onsite) We are hiring a Data Architect for a growing company in southeast... ...enterprise data platforms with hands-on data modeling and ETL/ELT across many different source systems. Real depth in Databricks...Full timeWork at office
Prestige Staffing
Kenosha, WI1 day ago - ...Data Warehouse / Teradata Architect Lansing, MI Hybrid 12-15+ Months Contract Virtual... ...~10+ years of experience into Teradata, ETL ~ Strong experience in Teradata SQL, joins... ...solutions using Teradata Design and develop complex SQL queries, stored procedures,...Contract work
System Soft Technologies
Lansing, MI3 days ago - ...Strong Architectural Framework experience ETL design tables experience Strong Python, PySPARK, Azure and have worked on a data warehouse Data Warehouse Data Engineer to build,... ...enterprise analytics. Will design and develop ETL/ELT pirpelines, Lakehouse/Warehouse...
Canyon Associates
Eatontown, NJ4 days ago - ...Job Title- Data Warehouse Architect 3 Only Michigan Based Candidates Job Responsibilities... ...for complex Linux security model on DW ETL servers. (Servers are administered by another... ...both built-in and custom data rules Develop and maintain disaster recovery and...For contractorsImmediate start
RICEFW Technologies Inc
Lansing, MI5 days ago - ...Data Warehouse EngineerLOCATION Chantilly, VA 20151CLEARANCE TS/SCI Full Poly (Please note this... ...You will be responsible for implementing ETL processes, maintaining data quality, and... ...CAREER TITLES Data Engineer, ETL Developer, Data Architect, Business Intelligence Engineer...Temporary workFor contractorsImmediate start
Cymertek
Chantilly, Loudoun County, VA2 days ago - ...ResponsibilitiesResponsible for complex Linux security model on DW ETL servers. Servers are administered by... ...Scheduler to ensure current and reliable data is available for critical business... ...and decision makingResponsible for Data Warehouse change management infrastructure and all...
Samprasoft
Lansing, MI2 days ago $80k - $120k
...0.00/yr - $120,000.00/yr Job details 100% Remote Data Warehouse Engineer needed for B2B SaaS company This Jobot Job... ...data quality procedures and practices. Design, develop, monitor, and manage ELT/ETL pipelines and procedures. Create and develop reports...Local areaRemote workFlexible hoursJobot
Boston, MA1 day ago- ...Data Warehouse Architect 5Location: Lansing MI (Hybrid) (Local Only)Position Type: Contract C2CClient: STATE OF MICHIGANGeneral... ...to support Child Welfare Data Warehouse team in developing Federal reporting, ad-hoc, ETL, and Business Objects reports that are critical to...Permanent employmentContract workFor contractorsLocal area
Argyle Infotech
Lansing, MI2 days ago - ...Data Warehouse EngineerGreenix Pest Control is seeking a Data Warehouse Engineer to own the raw, bronze, and silver layers of our data platform... ...and Experience:2–5 years of experience in a data engineering, ETL/ELT, or related analytics engineering roleHands-on experience...
Greenix
Johnston, RI1 day ago - ...Data Warehouse Engineer Location: 100% Remote Duration: 12-month contract, very strong chance of extension Position... ..., scheduling, and deploying data warehouse systems. Develops, monitors, and maintains ETL processes, reporting applications, and data warehouse...Contract workRemote work
Software Technology Inc
United States8 hours ago - ...are seeking a talented and experienced Data Warehouse Modeler and Engineer DBT Snowflake to join... ...on Snowflake This role combines ETL ELT design data mapping data modeling and... ...data models staging integration marts Develop test and maintain dbt models following...
Infinity Quest UK
Remote2 days ago - ...Job Description Job Title- Data Warehouse Architect 3 \n Only Michigan Based Candidates... ...for complex Linux security model on DW ETL servers. (Servers are administered by another... ...built-in and custom data rules \n Develop and maintain disaster recovery and backup...For contractorsImmediate start
RICEFW Technologies Inc
Lansing, MI15 days ago - ...Job Description SSIS/SSAS Data Warehousing Engineer Department... ...your morning reviewing overnight ETL runs and quickly resolving any... ...star/snowflake structures. Develop and support SSAS tabular and... ...Advance our enterprise data warehouse strategy and integration frameworks...Temporary workWork at officeRemote workNight shiftDay shift
Cleaver-Brooks Manufacturing
Thomasville, GA1 day ago - ...Description Job Description Job Title: Data Warehouse Architect 3 Job Location: Lansing, MI... ...data warehouse environments and ETL processes. Work with Teradata data warehouse... ...upgrades, patching, and maintenance. Develop and maintain technical documentation for...Contract work
Global Information Technology
Lansing, MI6 days ago - ...Architectural Framework experience \n ETL design tables experience \n Strong... ...Python, PySPARK, Azure and have worked on a data warehouse \n Data Warehouse Data Engineer to... ...optimize enterprise analytics. Will design and develop ETL/ELT pirpelines, Lakehouse/Warehouse...
Canyon Associates
Eatontown, NJ9 days ago $126.72k - $154.88k
IS Data Warehouse Architect III ---------------------------------------------------------------... ...design and development of data models and ETL specifications, data analysis, system... ...specifications to meet business data needs. Develop and maintain appropriate documentation,...Full timeWork at officeLocal areaWork from homeFlexible hours- ...SUMMARY AssuranceAmerica is seeking a Data Warehouse Engineer to join our growing ranks as we... ...to understand their challenges and develop solutions. Your daily contributions will... ...refreshable Excel Pivot tables. o Create ETL objects and processes (via SSIS, Python,...Full timeContract workTemporary workPart timeFlexible hours
- ...Job Description Job Description Senior Data Warehouse Engineer Location: Irving, TX (Onsite 5 Days/Week) Employment Type: Contract... ...Modeling Power BI Primary Responsibilities Design, develop, and maintain scalable data pipelines using Azure Data...Contract work
Expert Technical Solutions
Irving, TX24 days ago - ...Job Title: ( Data Warehouse Architect 5 - Sr. ETL/BI Developer ) About Kyyba: Founded in 1998 and headquartered in Farmington Hills MI Kyyba has a global presence delivering high-quality resources and top-notch recruiting services enabling businesses to effectively...Full timeVisa sponsorshipWork visa
Kyyba
Lansing, IL1 day ago $110.13k - $151.43k
...Corning worldwide. Role Summary The Data Warehouse & BI Engineer supports Corning’s... ...expertise in data warehousing, SQL development, ETL, and reporting, along with a passion for... ...implementation, and support. Design, develop, and maintain high-quality data...Full timeWorldwideCorning
Charlotte, NC8 days ago- ...Description Job Title: Enterprise Data Architect Overview / Summary... ...and physical data models. Develop enterprise data roadmaps... ...BigQuery. Design Lakehouse, Data Warehouse, and Data Mesh architectures.... ...solutions. Architect ETL/ELT pipelines using dbt, Azure...
HTC Global Services Inc
Grand Rapids, MI1 day ago $125k - $155k
...Akkodis, Inc. is seeking a full-time direct hire and remote Databricks Data Warehouse Engineer for a role with a billion-dollar global employer headquartered in Cleveland, OH. The Databricks DW Engineer provides the appropriate technical leadership, and strategic guidance...Full timeLive inRemote workShift workWeekend workAfternoon shiftAkkodis
United, PA2 days ago$165k
...Role Objective: Design, build, and scale high-performance data pipelines from disparate datasources into a lakehouse architecture... ...throughput batch and real-time ingestion pipelines from the ground up: ETL Expertise Infrastructure Selection: Evaluate trade-offs...FIA Tech
New York, NY3 days ago- ...Job Title – Data Modeler Location: Jersey City Work mode: Hybrid (4 days a week... ...Responsibilities Data Modeling & Design Design, develop, and maintain conceptual, logical, and... ...data solutions. Work with data warehouse, ETL, and BI teams to ensure seamless...
EXL
Jersey City, NJ22 hours ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Warehouse ETL Developer. Be the first to apply!
Related searches
- data warehouse engineer United States
- data warehouse developer United States
- data warehouse architect United States
- remote data warehouse developer United States
- oncology data United States
- data officer United States
- clinical data coordinator remote United States
- data reviewer United States
- data cabling United States
- data collection United States