Informatica ETL Developer

Job Description

Location: Charlotte, NC // Plano, TX (Hybrid)

\n

\n

Must Have Technical/Functional Skills

\n

\n

Primary Skill: Informatica IDMC Developer

\n

Experience: Minimum 10 years

\n

\n

Roles & Responsibilities

\n

\n

· Bachelor’s or master’s degree in computer science or related field.

\n

· Minimum 2 years experience in IDMC migration projects.

\n

· ETL Process Development: Design, develop, and maintain ETL processes using Informatica PowerCenter or other relevant Informatica tools.

\n

· Experience in Agile Methodology

\n

· Experience with code versioning tools like Bit-Bucket

\n

· SQL Proficiency: Utilize SQL/PLSQL to extract, transform, and load data.

\n

· Exposure to advanced transformations like data transformations, Parsing JSON/XML messages

\n

· Experience in Job scheduling tools Like Autosys

\n

· Experience with HDFS, MapReduce, and Hadoop ecosystems.

\n

· Understanding data storage and data processing techniques in Hadoop

\n

· Data Integration: Integrate data from various sources, ensuring data consistency and quality.

\n

· Data Warehouse Design: Design and maintain data warehouses to support business intelligence activities.

\n

· Performance Optimization: Optimize SQL script/queries for speed and efficiency.

\n

· Troubleshooting: Identify and resolve issues in ETL processes.

\n

· Documentation: Create and maintain technical documentation for ETL processes.

\n

· Testing: Perform unit, integration, and system testing on ETL processes.

\n

· Collaboration: Collaborate with cross-functional teams to ensure successful implementation of ETL processes.

\n

· Data Quality: Ensure data quality by implementing data cleansing and transformation processes.

\n

· Data Modeling: Develop and maintain relational and dimensional data models.