Senior Informatica Developer

This is a fully remote position, open to applicants in Virginia.

📋 Description

• Design, develop, enhance, and maintain enterprise ETL processes and data integration solutions utilizing Informatica technologies.

• Collaborate with business users and IT teams to collect, analyze, and convert business requirements into technical solutions.

• Create and uphold conceptual, logical, and physical data models for enterprise reporting, analytics, and operational needs.

• Construct and maintain data warehouses, data marts, and business intelligence solutions.

• Conduct data analysis, impact assessments, and troubleshooting for development, maintenance, and enhancement projects.

• Develop and optimize SQL queries, stored procedures, database objects, and data processing workflows.

• Oversee data development initiatives and implement structures, interfaces, and processes to enhance data accessibility and efficiency.

• Support data governance initiatives while ensuring adherence to standards, policies, and best practices.

• Collaborate with cross-functional teams on releases, deployments, testing, and change management efforts.

• Provide technical guidance and mentorship to less experienced team members.

• Contribute to ongoing improvements within the data engineering function.

⛳️ Requirements

• Bachelor's degree in Computer Science, Computer Information Systems, Information Technology, or a related field; equivalent experience may be considered.

• At least seven (7) years of experience in developing ETL and data integration solutions using Informatica PowerCenter.

• Minimum five (5) years of experience with Informatica Intelligent Data Management Cloud (IDMC) Data Integration.

• Proven experience in designing, developing, and supporting enterprise data warehouse and business intelligence solutions.

• Experience working with Oracle and Microsoft SQL Server databases in enterprise settings.

• Must be a U.S. Citizen.

• Strong knowledge of data analysis, data modeling, database design, and relational database concepts.

• Experience in developing ETL workflows, mappings, transformations, and integrations with Informatica technologies.

• Skilled in loading and transforming data from various data sources into enterprise data warehouses and analytical environments.

• Familiarity with Oracle database technologies, including indexing, stored procedures, materialized views, and performance optimization.

• Proficient in Microsoft SQL Server databases and advanced SQL development.

• Experience in SQL tuning, performance optimization, and data validation activities.

• Knowledge of utilizing metadata, impact analysis, and data governance methodologies.

• Strong analytical and problem-solving abilities.

• Capability to manage multiple priorities and achieve results independently.

• Excellent communication skills, enabling effective collaboration with technical and business stakeholders.

• Experience in mentoring team members and contributing to collaborative project delivery.

• Strong organizational and documentation skills.

🏝️ Benefits

• Bonuses, commissions, or other forms of additional compensation, including sign-on bonus, relocation benefits, short-term incentives, long-term incentives, or discretionary payments for exceptional performance.

• 401K plan with company match.

• Medical insurance.

• Dental insurance.

• Vision insurance.

• Life insurance.

• AD&D insurance.

• Flexible spending account.

• Disability benefits.

• Paid time off.

• Flexible work schedule.

• Professional training and development.

• Career advancement opportunities.