Lorven Technologies Inc
Website:
lorventech.com
Job details:
Job Description
We are looking for a skilled Informatica Developer to design, develop, and maintain ETL workflows for enterprise data integration projects. The ideal candidate will have experience in Informatica PowerCenter / Cloud, ETL development, SQL, and working with data warehouses or cloud platforms.
Key Responsibilities
- ETL Development:
- Design, develop, and maintain ETL mappings, workflows, and sessions in Informatica PowerCenter or Informatica Cloud.
- Implement data extraction, transformation, and loading from multiple sources to target systems (Data Warehouse, Data Lake, or cloud platforms).
- Data Validation & Quality:
- Perform source-to-target data validation to ensure data integrity and accuracy.
- Implement error handling and exception management in ETL workflows.
- Generate and review data quality reports and reconcile data discrepancies.
- Database Interaction:
- Write and optimize SQL queries, views, and stored procedures for data extraction and validation.
- Perform database performance tuning as required for large-scale ETL operations.
- Collaboration & Documentation:
- Collaborate with Data Architects, Business Analysts, and QA teams to understand requirements and design ETL solutions.
- Maintain proper documentation for ETL mappings, transformations, workflows, and processes.
- Deployment & Support:
- Support deployment of ETL workflows across Dev, QA, and Production environments.
- Assist in production support and issue resolution for ETL jobs.
- Cloud Integration (Optional):
- Work with cloud platforms like Azure, AWS, or Snowflake if ETL workflows are deployed in cloud environments.
Click on Apply to know more.