More jobs:
Software Engineer, Data Engineering, Python
Job in
Philadelphia, Philadelphia County, Pennsylvania, 19113, USA
Listed on 2026-11-01
Listing for:
Praise Tech Sol
Full Time
position Listed on 2026-11-01
Job specializations:
-
Software Development
Data Engineering, Python, SQL Developer
Job Description & How to Apply Below
- Design and implement data warehouses using ER diagrams, facts, dimensions, star schema, and snowflake schema modeling
- Implement incremental loads using SCD I and II, truncate and load, snapshot data loads, soft delete, and aggregation tables.
- Develop and optimize SQL Queries using analytical / window functions, CTEs, indexes, table joins, partitioning, functions, synonyms, views, and materialized views.
- Develop PL/SQL complex database objects such as stored procedures, functions, triggers, and packages using strong problem solving and analytical skills
- Utilize Fivetran to connect to different data sources, initialize syncs, and transformations, and schedule syncs. Monitor usage to ensure data integrity and performance
- Design, develop, and manage Matillion ETL pipelines, transformations to cleanse, transform, and load data, and schedule and monitor pipelines for optimal performance
- Develop and implement Informatica mappings, mapplets, sessions, and workflows using the designer, workflow, and monitor tools
- Configure metadata objects in OAC and OBIEE, including repository, variables, interactive dashboards, and reports using drill-down, filters, metadata repository facts, dimensions, hierarchies, and multi-user development environment MUDE
- Use GIT for version control and collaboration. Create, manage, and track branches, commits, and merges
- Use the Linux command line to manage files, run Python Scripts, and schedule tasks with cron. Use APIs to extract data from a variety of data sources.
- Develop custom scripts and tools to extract data from complex data sources. Design and implement data ingestion pipelines using APIs.
- Develop technical documentation, test plans, estimates, test cases, test scripts, and test report.
Anywhere in USA
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
Search for further Jobs Here:
×