Informatica Analyst - U.S. Citizenship Required

Why do you need to choose between doing important work and having a fulfilling life? At Ardent, we have both. Ardent employees are committed to solving our customers’ most difficult problems—and we are committed to the well-being, personal goals, and professional development of our employee. We are “All In.” We put forth our strongest effort possible to get the mission accomplished and we do it together. We respect the skills and experience you bring to the Ardent team. And we provide a rewarding environment to help you succeed. 

We offer highly competitive benefits, professional development opportunities, and an exceptional culture that embraces flexibility, innovation, collaboration, and career growth. A collective service mindset underpins our work, and a shared camaraderie to serve clients, colleagues and our communities set us apart. Our full commitment to being "All In" for our employees and our clients is not just our approach, it is our standard. If this sounds like the perfect fit for you, choose Ardent and make a difference with us. 

Ardent is seeking an Informatica Analyst  to join our team.  

This is a Remote position.

Position Description:

Ardent is seeking an experienced and detail-oriented Informatica Analyst to join our data team. The Informatica Analyst will be responsible for ensuring the accuracy, integrity, and efficiency of our organization's data through the effective use of Informatica tools and technologies. The ideal candidate should possess a strong background in data analysis, Informatica ETL (Extract, Transform, Load) processes, and data quality management.

Responsibilities and Duties:

Data Analysis and Mapping:

• Collaborate with business stakeholders to gather and understand data requirements and business rules.
• Analyze source data structures, perform data profiling, and create data mapping documents for ETL processes.

ETL Development and Implementation:

• Design, develop, and optimize Informatica ETL workflows to extract, transform, and load data from various source systems into target data repositories.
• Implement data transformations, validations, and cleansing logic to ensure data accuracy and quality.

Data Quality Management:

• Implement data quality rules and controls to monitor and improve the accuracy and completeness of data.
• Identify and rectify data anomalies, inconsistencies, and discrepancies.

Workflow Automation:

• Create and schedule ETL jobs using Informatica PowerCenter or other relevant tools to ensure timely and accurate data processing.
• Implement workflow dependencies and error handling mechanisms to maintain data pipeline reliability.

Performance Optimization:

• Monitor and analyze ETL job performance, identifying bottlenecks and areas for optimization.
• Tune ETL processes to improve data processing speed and efficiency.

Documentation and Reporting:

• Maintain comprehensive documentation of ETL workflows, data mappings, transformations, and data lineage.
• Generate reports and dashboards to communicate data quality metrics and ETL process performance.

Collaboration and Communication:

• Collaborate with data engineers, analysts, and business stakeholders to understand data requirements and ensure alignment with business goals.
• Communicate project progress, issues, and solutions to technical and non-technical stakeholders.

Data Governance and Compliance:

• Ensure compliance with data governance policies, data security standards, and regulatory requirements.
• Participate in data governance initiatives to maintain data accuracy and integrity.

Requirements: 

• Bachelor's degree in Computer Science, Information Systems, or a related field. Master's degree is a plus.
• Proven experience as an Informatica Analyst or similar role, with a minimum of X years working with Informatica ETL tools.
• Strong knowledge of Informatica PowerCenter or Informatica Cloud for designing and implementing ETL workflows.
• Proficiency in SQL and data manipulation, with experience in working with relational databases (e.g., Oracle, SQL Server).
• Familiarity with data warehousing concepts, data modeling, and data integration best practices.
• Understanding of data quality management and data profiling techniques.
• Excellent problem-solving skills and attention to detail.
• Strong communication skills to collaborate effectively with technical and non-technical stakeholders.
• Knowledge of scripting languages (e.g., Python, shell scripting) for automation is a plus.
• Relevant certifications, such as Informatica Certified Specialist, are advantageous.

Due to the nature of the work we support, all candidates in consideration for this role must be U.S. Citizens willing to undergo the government issued background investigation process.

Ardent is an equal opportunity employer. We will not discriminate and will take affirmative action measures to ensure against discrimination in employment, recruitment, advertisements for employment, compensation, termination, upgrading, promotions, and other conditions of employment against any employee or job applicant on the bases of race, color, gender, national origin, age, religion, creed, disability, veteran's status, sexual orientation, gender identity or gender expression.