Informatica Etl Developer

Primary Skill:
Informatica IDMC Developer

Secondary:
Oracle, Hadoop

Experience:

Minimum 8 years

• 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 Power Center 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, Map Reduce, 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.

• Discretionary Annual Incentive.
• Comprehensive Medical Coverage:
  Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
• Family Support:
  Maternal & Parental Leaves.
• Insurance Options:
  Auto & Home Insurance, Identity Theft Protection.
• Convenience & Professional Growth:
  Commuter Benefits & Certification & Training Reimbursement.
• Time Off:
  Vacation, Time Off, Sick Leave & Holidays.
• Legal & Financial Assistance:
  Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.

Salary Range: $100,000 - $130,000 a year

Charlotte, NC

TECHNOLOGY

Technical Lead

433319

Hadoop | Informatica | Oracle

$100,000 - $130,000

BACHELOR OF COMPUTER SCIENCE