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 3 days ago
Similar jobs that could be interesting for youBased on the ETL Developer in Pittsburgh, PA vacancy
- ...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, PAa month ago - ...Job Title: 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...SuggestedTemporary work
Veterans Sourcing Group LLC
Pittsburgh, PA8 hours 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, PA9 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...SuggestedFull time
- ...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...Full time
Siri InfoSolutions Inc
Pittsburgh, PA4 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, PAa month ago - ...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, PA8 days 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, PA23 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
- ...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, PA9 days ago - ...with a strong focus on FHIR based APIs, SmileCDR, and high volume ETL/ELT pipelines built on modern DataWorks platforms. The ideal... ...ResponsibilitiesInteroperability & API DevelopmentDesign, configure, and develop FHIR based interoperability solutions using SmileCDR.Implement...
Anveta
Pittsburgh, PA3 days ago $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$116.2k - $229.1k
...implementing Infrastructure as Code (Terraform, Bicep, ARM)• Experience developing and supporting CI/CD pipelines using Azure DevOps or GitHub... ....Preferred:• Experience supporting enterprise analytics, ETL, Snowflake, or modern data engineering ecosystems• Experience supporting...Local areaVisa sponsorship$100k - $115k
...Overview : The Salesforce Developer will play a critical role in designing, developing, and implementing Salesforce solutions that meet the... ...times. Experience with data migration, integration tools, and ETL processes, including Mulesoft, Talend, Dell Boomi, etc. Excitement...Full timeTemporary workWork at officeRemote workWork from homeFlexible hoursGrabJobs
Pittsburgh, PA2 days ago- ...Data Engineer - ETL with Python, Hadoop & SnowflakeResponsibilitiesOrganize business needs into ETL/ELT logical models and ensure data structures are designed for flexibility to support scalability of business solutions. Craft and implement data pipelines utilizing Glue...
My3Tech Inc
Pittsburgh, PA3 days ago $86.25k - $172.5k
...strategies, test plans, and test cases—what they are and how to develop them, specifically for data warehouses and decision-support systems... ...loads, transformations, extractions, and merges loaded by the ETLs/jobs from the legacy (mainframes is a plus) systems into the...Full timeTemporary workPart timeWork experience placementWork at officePNC
Pittsburgh, PA3 days ago- ...DeveloperLocation: Pittsburgh, PA Onsite Hire modeRole Overview: The Database Developer will design, develop, and maintain robust database solutions to... ...data security, backup, and recovery strategies.Familiarity with ETL processes and data integration tools.Strong problem solving and...
Yantran LLC
Pittsburgh, PA3 days ago - ...Enterprise Data Platform (EDP) Delivery teams. This role involves developing and implementing test strategies, ensuring data accuracy... ...governance. \\ \ · \\\ Develop and implement test cases for ETL/ELT pipelines, data transformation, and ingestion processes. \\...Remote work
GrabJobs
Pittsburgh, PA4 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$85k
...Description Overview We are seeking a BI Developer / Data Analyst with exceptional expertise in data mining, extraction, modeling, and analytics... .... Proficiency with Azure, SQL, and XML. Strong experience with ETL/ELT tools and techniques. Proficient with creating and...Remote workVisa sponsorshipFlexible hoursGrabJobs
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, PA1 day 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, PA1 day ago - ...shared infrastructure capabilities including a self-service Internal Developer Portal, a centralized CI/CD platform, reusable infrastructure... ...-cloud DNS management Familiarity with Matillion or similar ETL/CDC tooling and Snowflake data warehouse Exposure to financial services...Remote workFlexible hours
GrabJobs
Pittsburgh, PA4 days ago - ...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, PA15 days 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$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, PAa month ago- ...Business Intelligence Etl EngineerThe business intelligence etl engineer will be responsible for maintaining high quality business... ...within the ariba it organization. This role will be responsible for developing and maintaining the integration of data from various systems...
Netpace
Pittsburgh, PA3 days ago $83k - $195k
...entity/attribute definitions, mapping specs, naming standards).Develop and optimize database objects such as tables, views, indexes, materialized... ..., code sets, and reusable patterns.Build/maintain database-side ETL logic and scheduling dependencies where applicable.Monitor loads...Temporary workWorldwideFlexible hours$93k - $189k
...efficient cloud usage, including monitoring, optimization, and financial transparency.People Management & MentorshipManage, mentor, and develop a team of cloud platform and Site Reliability engineers.Foster a culture of technical excellence, ownership, and continuous...Full timeWork at officeRemote workWork from homeFlexible hours
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to ETL Developer. Be the first to apply!
Related searches
- developer ii Pittsburgh, PA
- us-developer Pittsburgh, PA
- computer programmer Pittsburgh, PA
- low code developer Pittsburgh, PA
- gis developer remote Pittsburgh, PA
- entry developer Pittsburgh, PA
- algorithm developer Pittsburgh, PA
- powershell developer Pittsburgh, PA
- progress developer Pittsburgh, PA
- program developer Pittsburgh, PA