Senior ETL Developer
1 day ago
ASSYST is seeking an experienced Senior ETL Developer to support our client in Laurel, MD. The selected candidate will be responsible for the design, development, and administration of ETL processes using Informatica PowerCenter, ensuring seamless data integration and transformation into cloud-based data platforms like Azure Synapse Analytics. This role requires expertise in developing, managing, and optimizing ETL workflows to handle large-scale data from various sources while ensuring high performance and data accuracy.
The ideal candidate will collaborate with data engineers, analysts, and stakeholders to implement scalable ETL solutions and ensure compliance with data governance policies. Strong knowledge in cloud technologies, SQL databases, and ETL administration is required, with a focus on performance tuning and troubleshooting.
Job Title: Senior ETL Developer
Location: Laurel, MD 20707(Hybrid - 3 days onsite 2 days remote)
Key Responsibilities:
- Develop complex ETL workflows and mappings using Informatica PowerCenter to extract, transform, and load data from multiple sources.
- Integrate data from disparate systems such as databases, flat files, and APIs into data warehouses, lakes, and repositories.
- Administer the Informatica PowerCenter environment, including installation, configuration, upgrades, and patch management.
- Monitor and optimize ETL processes through load balancing, parallel processing, and efficient transformations.
- Identify and resolve ETL issues such as data inconsistencies, job failures, and performance bottlenecks to ensure high availability.
- Ensure data accuracy and consistency by implementing rigorous validation checks throughout the ETL process.
- Collaborate with business analysts, data architects, and stakeholders to gather requirements and align solutions with business needs.
- Maintain documentation of ETL processes, workflows, mappings, and data models.
- Automate ETL jobs and workflows, scheduling them for optimal execution and managing dependencies.
- Implement data cleansing, data quality checks, and transformation logic to ensure data integrity.
- Ensure ETL processes comply with security standards, data governance policies, and data privacy regulations.
- Manage version control and updates for ETL processes, ensuring smooth production transitions.
- Monitor system resources and scale infrastructure to accommodate future data growth.
- Work with database administrators to optimize database performance for ETL operations.
- Develop error-handling mechanisms, including logging, alerting, and rollback procedures.
- Provide guidance and mentorship to junior developers and promote best practices for ETL development.
- Ensure compliance with metadata management, data lineage tracking, and audit trail requirements.
- Stay current with industry trends and implement improvements to enhance ETL processes.
- Expertise in Oracle and SQL Server databases with strong skills in SQL and PL/SQL.
- Preferred experience in Python for building data pipelines.
Preferred Experience & Qualifications:
- Bachelor’s Degree in Information Systems, Computer Science, or a related technical field.
- Minimum of 3 years of relevant experience in ETL development and data integration.
- Experience in designing and implementing enterprise-level data solutions.
- Industry experience in water and wastewater utilities with knowledge of Oracle utility applications is preferred.
- Proven experience working on large-scale data projects with a focus on analytics, business intelligence, and enterprise systems.
- Extensive experience with data modeling and database design.
- Expertise in building enterprise-wide analytics solutions with data integration from multiple sources.
- Strong knowledge of SQL, PL/SQL, and Oracle database management with performance optimization.
- Familiarity with data governance frameworks to ensure data quality and security.
- Excellent communication skills for translating business needs into technical solutions.
- Strong problem-solving abilities, especially when handling complex datasets.
ASSYST is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law.
-
Senior ETL Developer
11 hours ago
Laurel, United States Oakland Consulting Group, Inc. Full timeSenior ETL Developer with expertise in Informatica PowerCenter will design, develop, and administer ETL processes to support data integration and transformation for cloud-based data solutions. The role involves building and optimizing complex ETL workflows using Informatica PowerCenter to extract, transform, and load data from various sources into Azure...
-
ETL Informatica Developer
2 weeks ago
Mount Laurel, New Jersey, United States Diverse Lynx Full timeJob Title: ETL Informatica DeveloperWe are seeking an experienced ETL Informatica Developer to join our team at Diverse Lynx LLC. As an ETL Informatica Developer, you will be responsible for designing, developing, and implementing ETL processes using Informatica Power Centre.Key Responsibilities:Design and develop ETL processes using Informatica Power...
-
Senior Oracle DBA/Developer
1 month ago
Mount Laurel, New Jersey, United States Tata Consultancy Services Full timeJob DescriptionWe are seeking a highly skilled Oracle DBA/Developer to join our team at Tata Consultancy Services.Key Responsibilities:Design, implement, and maintain Oracle databases for various clients.Migrate databases from Oracle to Oracle, SQL server to Oracle, and Oracle to SQL server.Develop and implement Oracle DBA/development experience, with a...
-
ETL Informatica Specialist
6 days ago
Mount Laurel, New Jersey, United States Diverse Lynx Full timeJob Title:ETL Informatica TestingJob Summary:We are seeking a highly skilled ETL Informatica Testing professional to join our team at Diverse Lynx, LLC. The ideal candidate will have strong experience in data warehousing, data migration, and data quality testing, with a focus on cloud-based solutions.Key Responsibilities:Design and implement comprehensive...
-
Senior Oracle Developer
4 days ago
Mount Laurel, New Jersey, United States Syntricate Technologies Full timeJob Title: Senior Oracle DeveloperJob Summary:We are seeking a highly skilled Senior Oracle Developer to join our team at Syntricate Technologies. The ideal candidate will have extensive experience in implementing Oracle solutions, with a strong background in database administration and development.Key Responsibilities:Design, implement, and maintain Oracle...
-
Senior Enterprise Database Architect
11 hours ago
Laurel, Montana, United States Pinnacle Treatment Centers Full timeJob Title: Senior Enterprise Database ArchitectJob Summary:Pinnacle Treatment Centers seeks a skilled Senior Enterprise Database Architect to design and implement data systems that meet the needs of our organization. The ideal candidate will have experience in designing enterprise databases, data warehouse systems, and cloud data systems.Key...
-
ETL Lead
4 weeks ago
Mt Laurel Township, NJ, USA, United States Wipro Full timeAbout WiproWipro Limited is a leading technology services and consulting company that helps clients navigate their digital transformation journey. With a strong commitment to sustainability and good corporate citizenship, we have over 250,000 dedicated employees serving clients across 66 countries.Role - ETL Lead - InformaticaThis role is responsible for the...
-
Senior Hadoop Administrator
2 weeks ago
Laurel, Montana, United States Diverse Lynx Full timeSenior Hadoop AdministratorWe are seeking a highly skilled Senior Hadoop Administrator to join our team at Diverse Lynx LLC. As a key member of our technical staff, you will be responsible for designing, implementing, and maintaining large-scale Hadoop clusters on Azure Cloud.Key Responsibilities:Design and implement end-to-end Hadoop stack solutions,...
-
Senior Data Engineer
11 hours ago
Laurel, United States Oakland Consulting Group, Inc. Full timeLocation: Laurel, MDContractDuration: 12+ MonthsUSC and W2The Senior Data Engineer with expertise in Azure Synapse Analytics and Microsoft Fabric will design, develop, and implement scalable data solutions to support analytics and reporting needs. The role involves creating, optimizing, and managing data pipelines to efficiently move and transform data...
-
Golden Gate Admin/ Developer
1 month ago
Mount Laurel, United States Tata Consultancy Services Full timeJob Description5 to 6 years of GG implementation experience (Mid Level)- Oracle to Oracle- SQL server to Oracle- Oracle to SQL server- Oracle to Cloud- Any other db to any other DB- Oracle DBA/development experience (Mid – Senior)- Informatica/ETL exposure – Good to Have; Nice to know- Exadata or any MPP experience
-
Senior SQL Server DBA Developer
5 months ago
Mt Laurel, United States Pinnacle Treatment Centers Full timeJob Description: Design strategies for enterprise databases, data warehouse systems, and cloud data systems. Develop complex ETL (extract, transform and load) scripts in SSIS, Azure Data Factory and Information to integrate external data sources with Pinnacle Enterprise Data Warehouse. Develop database archiving and partitioning strategy to improve...
-
Golden Gate Admin/ Developer
1 month ago
Mount Laurel Township, United States Tata Consultancy Services Full timeJob Description5 to 6 years of GG implementation experience (Mid Level)- Oracle to Oracle- SQL server to Oracle- Oracle to SQL server- Oracle to Cloud- Any other db to any other DB- Oracle DBA/development experience (Mid – Senior)- Informatica/ETL exposure – Good to Have; Nice to know- Exadata or any MPP experience
-
Goldengate Developer
4 weeks ago
Mount Laurel, New Jersey, United States Diverse Lynx Full timeJob Title: Goldengate DeveloperWe are seeking a highly skilled Goldengate Developer to join our team at Diverse Lynx LLC. The ideal candidate will have a strong background in Oracle database administration and development, with a focus on Goldengate implementation and migration.Key Responsibilities:Design and implement Goldengate solutions for Oracle to...
-
Data Integration Specialist
3 weeks ago
Mount Laurel, New Jersey, United States Mondo Staffing Full timeJob Title: ETL Developer Job Description: We are seeking an experienced ETL Developer to join our team at Mondo Staffing. As an ETL Developer, you will be responsible for designing, developing, and documenting complex processes that consolidate and integrate data. You will follow and contribute to best practices for data integration workflows,...
-
Data Integration Specialist
2 weeks ago
Mount Laurel, New Jersey, United States Mondo Full timeJob Title: ETL DeveloperWe are seeking an experienced ETL Developer to join our team at Mondo. As an ETL Developer, you will be responsible for designing, developing, and documenting complex processes that consolidate and integrate data.Key Responsibilities:Design and develop ETL job flows according to company standards for naming, performance, relatability,...
-
Senior Business Intelligence Engineer
3 days ago
Mount Laurel, New Jersey, United States Array Behavioral Care Full timeJob Title: Senior Business Intelligence EngineerArray Behavioral Care is seeking a highly skilled Senior Business Intelligence Engineer to join our team. As a key member of our Data Analytics & Engineering team, you will be responsible for designing, building, and maintaining complex data analytics solutions using Power BI.Key Responsibilities:Design and...
-
Data Integration Specialist
4 weeks ago
Mount Laurel, New Jersey, United States Mondo Full timeJob Title: ETL DeveloperWe are seeking an experienced ETL Developer to join our team at Mondo. As an ETL Developer, you will be responsible for designing, developing, and documenting complex processes that consolidate and integrate data.Key Responsibilities:Design and develop ETL job flows according to company standards for naming, performance, relatability,...
-
Data Integration Specialist
4 weeks ago
Mount Laurel, New Jersey, United States Mondo Full timeJob Title: ETL DeveloperAt Mondo, we're seeking an experienced ETL Developer to join our team. As an ETL Developer, you will be responsible for designing, developing, and documenting complex processes that consolidate and integrate data.Key Responsibilities:Design and develop ETL job flows according to company standards for naming, performance, relatability,...
-
Senior Software Developer
2 days ago
Laurel, Maryland, United States Belay Technologies Full timeJob Title: Senior Software DeveloperBelay Technologies is seeking a highly skilled Senior Software Developer to join our team. As a key member of our software development team, you will be responsible for designing, developing, and testing software applications.Key Responsibilities:Design and develop software applications using a variety of programming...
-
Senior Salesforce Developer
2 days ago
Laurel, Montana, United States Bestinfo Systems LLC Full timeSenior Salesforce Developer OpportunityWe are seeking a highly skilled Senior Salesforce Developer to join our team at Bestinfo Systems LLC.About the Role:This is a contract position that requires a hybrid work arrangement, with a focus on designing, developing, and deploying Salesforce solutions that meet business needs.Key Responsibilities:Design and...