Description

ETL Development & Data Integration:

• Design, develop, and maintain ETL/ELT pipelines for integrating data from multiple sources.
• Develop mappings, workflows, and transformations using Informatica PowerCenter or IICS.
• Perform data extraction, transformation, loading, and incremental data processing.
• Integrate data from databases, flat files, and REST APIs.

Database & Data Warehousing:

• Develop complex SQL queries, stored procedures, and performance-optimized database operations.
• Work with Oracle, SQL Server, and cloud data warehouses.
• Perform source-to-target mapping, data validation, and reconciliation.
• Support data quality, data migration, and warehouse optimization.

Required Skills:

• 5+ years of experience in ETL development.
• Strong hands-on experience with Informatica PowerCenter or IICS.
• Advanced SQL and PL/SQL development experience.
• Knowledge of data warehousing concepts and ETL architecture.
• Experience with full loads, incremental loads, and data transformations.
• Strong troubleshooting and production support skills.

Preferred Qualifications:

• Experience with AWS Glue, S3, Snowflake, or Azure Synapse.
• Knowledge of Python or PySpark.
• Experience with REST APIs, JSON, and XML.
• Familiarity with Git, Jenkins, and Linux scripting

Key Skills

Education

Bachelor's degree