Informatica ETL Developer

Location: Charlotte, NC // Plano, TX (Hybrid)Must Have Technical/Functional SkillsPrimary Skill: Informatica IDMC DeveloperExperience: Minimum 10 yearsRoles & Responsibilities· Bachelor’s or master’s degree in computer science or related field.· Minimum 2 years experience in IDMC migration projects.· ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.· Experience in Agile Methodology· Experience with code versioning tools like Bit-Bucket· SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data.· Exposure to advanced transformations like data transformations, Parsing JSON/XML messages· Experience in Job scheduling tools Like Autosys· Experience with HDFS, MapReduce, and Hadoop ecosystems.· Understanding data storage and data processing techniques in Hadoop· Data Integration: Integrate data from various sources, ensuring data consistency and quality.· Data Warehouse Design: Design and maintain data warehouses to support business intelligence activities.· Performance Optimization: Optimize SQL script/queries for speed and efficiency.· Troubleshooting: Identify and resolve issues in ETL processes.· Documentation: Create and maintain technical documentation for ETL processes.· Testing: Perform unit, integration, and system testing on ETL processes.· Collaboration: Collaborate with cross-functional teams to ensure successful implementation of ETL processes.· Data Quality: Ensure data quality by implementing data cleansing and transformation processes.· Data Modeling: Develop and maintain relational and dimensional data models.