Senior ETL Developer

About Our Company :

Delmock Technologies, Inc. (DTI), is a leading HUBZone business in Baltimore, known for delivering sophisticated IT (Information Technology) and Health solutions with a commitment to ethics, expertise, and superior service. Actively engaged in the local community, DTI creates opportunities for talented residents while maintaining a stellar reputation as an award-winning contractor, earning accolades like the Government Choice Award for IRS (Internal Revenue Service) Systems Modernizations.

Location : This position is hybrid, based in Laurel, MD 20707.

Role :

Delmock Technologies, Inc. is seeking a Senior ETL Developer to 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 Synapse Analytics and other data platforms. The candidate will manage the Informatica PowerCenter environment, ensuring high availability, security, and performance, while also leveraging Azure Synapse for data warehousing and analytics. They will collaborate with data engineers, business analysts, and stakeholders to understand data requirements, develop scalable ETL pipelines, and ensure data accuracy. Strong experience in both ETL development and administration, cloud technologies like Azure, and SQL databases is essential. The role also involves maintaining documentation, performance tuning, and ensuring compliance with data governance standards.

Responsibilities :

• Develops requirements for information systems from a project's inception to conclusion.
• Develops required specifications for moderately and highly complex systems.
• Leads other team members in preparing input and test data for the proposed system.
• Provides technical and administrative direction for personnel performing software development tasks, including the review of work products for correctness, adherence to the design concept and to user standards and for progress in accordance with schedules.
• Design, develop, and optimize complex ETL workflows and mappings using Informatica PowerCenter to extract, transform, and load data from multiple sources.
• Manage data integration from disparate systems (e.g., databases, flat files, APIs) into data warehouses, data lakes, and other repositories.
• Administer the Informatica PowerCenter environment, including installation, configuration, upgrades, and patch management.
• Monitor and optimize ETL processes for performance, including load balancing, parallel processing, and tuning transformations to minimize execution time.
• Identify and resolve ETL issues, such as data inconsistencies, job failures, and performance bottlenecks, ensuring minimal downtime.
• Ensure data accuracy, consistency, and completeness by implementing rigorous validation checks throughout the ETL process.
• Work closely with business analysts, data architects, and stakeholders to gather data requirements and ensure the ETL solutions meet business objectives.
• Create and maintain comprehensive documentation of ETL processes, workflows, mappings, and data models.
• Automate ETL jobs and workflows, scheduling them for execution at optimal times, and managing dependencies across jobs.
• Implement data cleansing, data quality checks, and transformation logic to ensure the integrity of data before loading.
• Ensure that ETL processes comply with security standards and governance policies, managing access controls and data privacy.
• Implement version control, manage updates to ETL processes, and ensure smooth transitions during changes to production environments.
• Monitor and manage system resources, ensuring the ETL infrastructure can handle growing data volumes and future expansion.
• Work with database administrators and engineers to optimize database performance and ensure data is structured efficiently for ETL processing.
• Develop error-handling mechanisms, including logging, alerting, and rollback procedures to address issues in ETL workflows.
• Provide guidance, mentorship, and support to junior ETL developers and other team members in best practices for ETL development.
• Ensure ETL processes adhere to organizational data governance policies, including metadata management, data lineage, and audit trails.
• Stay updated on the latest ETL tools, technologies, and best practices, and implement improvements in ETL processes to enhance efficiency and effectiveness.

Minimum Requirements :

Preferred / Nice to Have Skills :

Clearance :

Recently ranked as high as #3 among HUBZone Companies in a GOVWIN survey, DTI offers a dynamic environment for those passionate about impactful projects, community involvement, and contributing to a top-ranking Federal project support team.

At DTI, we balance continuous growth and innovation with a strong dedication to corporate social responsibility. Join our talented team and be part of a company that values both professional excellence and community impact. Explore the exciting career opportunities awaiting you at DTI!

DTI is committed to hiring and maintaining a diverse workforce. We are an equal opportunity employer making decisions without regard to race, color, religion, sex, national origin, age, veteran status, disability, or any other protected class.

J-18808-Ljbffr