Informatica DeveloperFreddie Mac is seeking an experienced Informatica Developer to support enterprise data integration and analytics initiatives within the organization.
The role involves building and maintaining scalable ETL pipelines, integrating multiple data sources, and enabling reliable data delivery across enterprise data platforms.The ideal candidate will have strong experience in Informatica development, SQL-based data transformations, and modern cloud data platforms including Snowflake and AWS.Key ResponsibilitiesDesign, develop, and maintain ETL workflows and mappings using Informatica PowerCenter or Informatica Intelligent Cloud Services.Build and optimize data integration pipelines to process large volumes of structured and semi-structured data.Develop complex SQL queries and stored procedures for data transformation and validation.Integrate enterprise data sources including relational databases, NoSQL systems, and cloud data platforms.Support data ingestion and transformation into cloud-based data warehouses such as Snowflake.Work with AWS data services such as Amazon S3, AWS Glue, and Amazon Redshift where applicable.Implement data validation, error handling, and monitoring processes to ensure high data quality.Develop integrations with NoSQL databases such as MongoDB.Collaborate with data engineers, analysts, and business stakeholders to deliver reliable data solutions.Troubleshoot ETL failures and optimize job performance.Required SkillsStrong hands-on experience with Informatica PowerCenter or Informatica Intelligent Cloud Services.Solid experience in ETL design, development, and optimization.Advanced proficiency in SQL and relational databases.Experience integrating data with cloud data platforms such as Snowflake.Experience working with AWS data ecosystem (S3, Glue, Redshift, Lambda).Experience working with NoSQL databases such as MongoDB.Strong understanding of data warehousing concepts and data modeling.Experience troubleshooting and optimizing ETL workflows.Preferred SkillsExperience with cloud-based ETL and data integration.Familiarity with CI/CD pipelines for data workflows.Knowledge of data governance and metadata management tools.Experience in financial services or enterprise-scale data environments.QualificationsBachelor’s degree in Computer Science, Information Systems, Engineering, or related field.6–8+ years of experience in data integration, ETL development, and data warehousing.Experience working in large enterprise data environments.