ETL Developer
Full-time
Siri InfoSolutions Inc
Role: ETL Developer
Location: Pittsburgh, PA
Hire Type: Full time
Must Have Technical/Functional Skills:
- Experienced ETL Developer with strong expertise in Informatica PowerCenter, specializing in designing and developing mappings, sessions, and workflows to support enterprise data integration.
- Skilled in leveraging tools such as Source Analyzer, Mapplet Designer, and Workflow Manager to build efficient data loading processes, monitor execution, and ensure performance reliability.
- Proficient in SQL and database design with proven ability to troubleshoot issues, optimize queries, and implement complex transformations including Slowly Changing Dimensions (SCD), delivering accurate and scalable data solutions aligned with business requirements.
Roles & Responsibilities
- ETL Methodologies: Extensively applied ETL concepts to support data extraction, transformation, and loading processes using Informatica PowerCenter.
- ETL Job Design: Designed and developed PowerCenter ETL jobs to extract data from heterogeneous source systems and load into DB2 Data Marts.
- Business Requirement Analysis: Collaborated with business analysts to understand processes and translate user requirements into optimized Data Mart solutions.
- Transformations Expertise: Implemented complex data manipulations using Filter, Expression, Lookup, Aggregator, Joiner, Router, Rank, Sorter, Update Strategy, and Slowly Changing Dimensions (SCD).
- Data Integration: Processed data from multiple source systems including relational databases and flat files, ensuring seamless integration.
- SCD Type Implementation: Designed and implemented Slowly Changing Dimension Type methodology to maintain historical data accuracy.
- ETL Mapping & Workflow Design: Created and optimized mappings in Informatica PowerCenter Designer using Source Analyzer, Mapplet Designer, and Mapping Designer; developed sessions and workflows in Workflow Manager to enable seamless data loading and monitored execution in Workflow Monitor for performance and reliability.
- SQL & Database Expertise: Demonstrated strong proficiency in SQL queries, database design, and development; performed data processing, identified issues, and implemented solutions to ensure accuracy and efficiency across relational databases.
Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the ETL Developer in Pittsburgh, PA vacancy
- ...Experience: 6-10 years Mandatory Experience Experience required in SQL Server (2008 to present) Experience required in ETL Experience required in SSIS Experience required in SSRS Experience required in ASP.NET (ASP.NET MVC, ASP.NET Web Pages, ASP....Suggested
Omni Inclusive
Pittsburgh, PA1 day ago $86.25k - $158.13k
...of our employees feel respected, valued and have an opportunity to contribute to the company's success. As a Software Engineer Lead (ETL) within PNC's Retail Tech Core Debit Product organization, you will be based in Pittsburgh PA, Strongsville OH or Dallas TX. We are...SuggestedFull timeTemporary workPart timeWork experience placementWork at officePNC
Pittsburgh, PA4 days ago- ...Description Job Description Title: Software Engineer Sr - ETL Location: Pittsburgh, PA Roles and Responsibilities: This role... ...expertise, with strong hands-on experience in designing and developing scalable, high-performance ELT data pipelines using modern data...Suggested
System One
Pittsburgh, PA24 days ago - ...Time)Employment Type: Full TimeIndustry: Computer SoftwareClient: WiproContact: Meghana GorusuCompany: SRI Tech SolutionsHadoop / ETL Developer and PySparkLocation - Dallas, TX / Atlanta, GA / Cleveland, OH / Pittsburgh, PA (Day 1 Onsite)Note - Pls submit only visa...SuggestedFull time
- ...Required Skills & Experience (Must-Have) 5+ years of hands-on experience with Informatica ETL Administration (installation, configuration, support) and ETL workflow development. Proven expertise with Informatica PowerCenter and PowerExchange. Experience with Web...Suggested
Cloud Analytics Technologies LLC
Pittsburgh, PA2 days ago - ...ETL Developer/Admin Duration: 9+ months (possible temp to hire) Location: Pittsburgh, PA 15258 Onsite Role (4 days a week) Responsibilities: Must have 5+ years of experience with Informatica ETL Administration activities like installation/configuration and...Temporary work
Veterans Sourcing Group LLC
Pittsburgh, PA4 days ago - ...ETL Developer Location: Strongsville OH/Pittsburgh, PA/Dallas, TX Duration: Full Time Job Description: ~ Informatica powercenter, IICS, Migration project, Unix, Data Quality Rules, Oracle, PLSQL, Hadoop. Roles & Responsibilities Looking for a...Full time
JConnect Infotech
Pittsburgh, PA4 days ago - ...WiproContact: Meghana GorusuCompany: SRI Tech SolutionsSenior Informatica ETL DeveloperLocation - Dallas, TX / Cleveland, OH / Pittsburgh, PA... ...:We are seeking a highly skilled Senior Informatica ETL Developer to join our data engineering team. In this role, you will...Full time
- ...Role Overview The Informatica ETL Developer is an integral part of the team responsible for the extraction of data from multiple sources into various target platforms and environments. Your duties will includes the modification of existing mappings and building others...Local areaRelocation package
Techstra Solutions
Pittsburgh, PA1 day ago - ...Role Description Seeking an Informatica ETL Developer with 7+ years of experience to design, develop, and support enterprise data integration solutions. The role involves building scalable data workflows, optimizing data processes, and supporting critical data...
TechNeptune Consulting Inc
Pittsburgh, PA16 days ago - ...Informatica Developer Location:Pittsburgh PA Fulltime Must Have Technical/Functional Skills: Proficiency in... ...Informatica Data Management Cloud. Strong understanding of ETL principles, data warehousing concepts, and data integration techniques...Full time
SARIAN Co
Pittsburgh, PA3 days ago - ...directly to ****@*****.*** - make sure to include the exact job title and job location in your email message. ETL Developer This position requires someone to be onsite in an office work setting five days a week in Pittsburgh, PA, Cleveland, OH, or...Work at officeImmediate start
System One
Pittsburgh, PA29 days ago - ...Mandate ETL Developer/SQL tester with experience using cloud solutions on AWS. ETL Developer/SQL tester with 5-7 years of experience. Required Experience with SQL scripting and relational database modeling Experience working with creating AWS ETL jobs, data...Immediate start
Cloud Analytics Technologies LLC
Pittsburgh, PA2 days ago - THREE Application Developer Leads (BPM, Oracle, SOA, ESB, ETL, BI, Analytics) in Pittsburgh, PA Application Design, BPM, Business Intelligence, ESB, ETL, Oracle, SOA Location: Pennsylvania Job Function: Application Development Date Of Job Posting: 07-07-2018 THREE...Permanent employmentFull timeWork experience placementRemote work
$146k - $234k
...role, you willDesign, build, and maintain robust and scalable data pipelines and ETL/ELT processes to ingest, transform, and load data from various sources into our data warehouse.Develop and manage data infrastructure components using AWS cloud services and infrastructure...Work at officeLocal area3 days per week$1,000 - $2,030 per month
...What you'll do Take on ownership of the data and ML platform layer that powers Lab37's robotics fleet. This spans building ETL pipelines that turn raw robot telemetry into actionable analytics, managing the ML training infrastructure that produces the computer...Full timeTemporary workWork at officeFlexible hoursLab37
Pittsburgh, PA1 day ago- ...relational databases such as Oracle or SQL Server.Experience with scripting languages such as Python (nice to have).Experience with ETL software such as Pentaho (nice to have).Strong interpersonal skills.At BNY, our culture speaks for itself, check out the latest BNY news...Work experience placementWorldwideFlexible hours
- ...intelligence, we are looking for a motivated and curious Junior AI Developer to join our growing AI team. In this role, you will contribute... ...as AWS, Azure, or GCP Exposure to data engineering concepts — ETL pipelines, data ingestion, transformation, or orchestration...Internship
- ...manage the Snowflake data warehouse, including account structure, warehouse architecture, and role-based access controls. Develop scalable ELT/ETL pipelines and data models using Snowpipe, Streams and Tasks, dbt, and related technologies to support reporting and...Remote work
McNees Wallace & Nurick LLC
Pittsburgh, PA8 days ago $20 - $26 per hour
...Engineer to join its Strategic Solutions Team, responsible for developing and supporting technology platforms for high-impact client engagements... ...evaluation, and performance optimization* Design and support ETL processes, data integrations, webhooks, event-driven...Shift work$55 per hour
...Job Title: Senior Full Stack Developer (Angular + Python) Location: Chicago, IL Type: Contract Compensation: $55 Work Model: Onsite... ...functions, SNS/SQS messaging, data pipelines with AWS Glue ETL, S3, and IAM security. Participate in sprint planning, issue...Contract workTemporary workLocal areaRemote workSystem One
Pittsburgh, PA26 days ago- ...Database Developer Location: Pittsburgh, PA Onsite Hire mode Role Overview: The Database Developer will design, develop, and maintain... ...security, backup, and recovery strategies. Familiarity with ETL processes and data integration tools. Strong problem solving...
Yantran LLC
Pittsburgh, PA4 days ago $60k
...inception through completion... Our technical, domain expertise across industries and process oriented approach enables clients to develop cost effective and robust solutions. We strive to prove ourselves from project inception through completion... To succeed in...Permanent employmentFull timeContract workTemporary workWork experience placementRelocation packageDellfor Technologies
Pittsburgh, PA12 hours ago- ...Job Destription: Please share profiles with their skill matrix and relevant exp on Angular JS. ~ Ability to independently develop software using Java Script frameworks like Angular, Dojo ~ Experience working in Agile environment. ~ Experience working...Full timeWorldwide
Arete Technologies Inc
Pittsburgh, PA12 hours ago $150.32k - $225.48k
...roadmap to make travel safer, less stressful, and more enjoyable for everyone. Bringing this vision to scale, our fully in-house developed hands-free ADAS platform will debut on Ford’s all-new Universal Electric Vehicle in 2027. When you join the Latitude team, you’ll...Permanent employmentFull timeWork at officeImmediate startVisa sponsorship- ...Group: Marketing support Industry background: Banking / Finance Roles/Responsibilities: Pega Developer • Part of a full stack agile team including Java, ETL, and Mainframe developers • Attend stand up meetings and other agile ceremonies • Support both new...Contract work
System One
Pittsburgh, PA24 days ago - ...Tableau Prep, and other BI platforms such as Microsoft Power BI for developing advanced dashboards and analytical reports. • Data Warehouse... ...warehouse concepts, data modeling techniques, and end-to-end ETL processes. • Advanced SQL Proficiency: Ability to write, optimize...Temporary workLocal areaFlexible hours
System One
Pittsburgh, PAmore than 2 months ago - ...sets. Flex Skills/Nice to Have: 1. Other DB experience (like Teradata) 2. Knowledge and experience with DevOps Tools a plus 3. ETL (Informatica) experience 4. Python, Shell scripting experience Education: Bachelors Degree Computer Science or equivalent experience...Contract workFlexible hours
System One
Pittsburgh, PAa month ago - ...cutover to production. Build frameworks for real-time and near real-time data ingestion and processing, alongside batch pipelines (ELT/ETL). Drive decisions across storage, orchestration, data quality, reliability, and performance. Define semantic data models that...Temporary workWork at officeRemote workWork from homeMonday to Friday
Data Ideology
Pittsburgh, PAa month ago - ...Business Intelligence Etl Engineer The business intelligence etl engineer will be responsible for maintaining high quality business... ...the ariba it organization. This role will be responsible for developing and maintaining the integration of data from various systems...
Netpace
Pittsburgh, PA4 days ago
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to ETL Developer. Be the first to apply!
Related searches
- tableau developer remote Pittsburgh, PA
- weekend programmer Pittsburgh, PA
- etl developer Pittsburgh, PA
- senior magento developer Pittsburgh, PA
- work from home junior developer Pittsburgh, PA
- interface developer Pittsburgh, PA
- survey programmer Pittsburgh, PA
- spring boot developer Pittsburgh, PA
- workday developer Pittsburgh, PA
- entry level mulesoft developer Pittsburgh, PA