Position name: Sr. ETL/Informatica Consultant with AWS, Snowflake and Coalesce
Location : Franklin, Tennessee
Duration: 6 Months
Primary Skills: Snowflake and Coalesce, Informatica Power Center
Secondary Skill: AWS Services like Glue, Lambda, S3
Responsibilities:
- Design, develop, and maintain robust data pipelines and ETL processes using AWS services.
- Implementation of ETL processes for migrating data from legacy systems to cloud platforms
- Collaborate with data architects, analysts, and business stakeholders to gather and understand data requirements.
- Optimize data workflows for performance, scalability, and reliability.
- Implement data integration solutions to ensure seamless data flow between various systems.
- Monitor and troubleshoot data pipelines to ensure data quality, integrity, and availability.
- Develop and enforce best practices for data management, governance, and security.
- Provide technical guidance and mentorship to junior data engineers.
- Conduct code reviews and ensure adherence to coding standards and best practices.
- Stay updated with the latest trends and technologies in data engineering and cloud computing.
Qualifications:
- Bachelor’s or Master’s degree in Computer Science, Information Technology, or a related field.
- Extensive experience in data engineering, ETL processes, and data integration.
- Proficiency in AWS services such as S3, Snowflake, Glue, and Lambda.
- Strong knowledge of Snowflake and SQL for data warehousing and analytics.
- Experience with Coalesce for data transformation and orchestration.
- Expertise in Informatica PowerCenter for ETL development.
- Excellent problem-solving skills and attention to detail.
- Strong communication and interpersonal skills.
- Ability to work independently and as part of a team.
- Certification in AWS or Informatica is a plus.