ETL Informatica Developer

Envision Technology Solutions; Charlotte (NC); On-site; USD 90,000 - 120,000; Full time

Job summary

Envision Technology Solutions in Charlotte, NC seeks an ETL/Data Integration Engineer to design, develop, and maintain ETL processes using Informatica PowerCenter and related tools. You will work with SQL, JSON/XML parsing, and job scheduling in Autosys to ensure data quality and timely data delivery.

The role requires 2+ years in IDMC migrations, experience in Hadoop ecosystems, and collaboration with cross-functional teams to implement scalable data integration solutions.

Qualifications

• 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 Bitbucket
• 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

Responsibilities

• Design, develop, and maintain ETL processes using Informatica PowerCenter.
• Collaborate with cross-functional teams to implement ETL solutions.
• Optimize SQL scripts for performance and scalability.
• Create and maintain technical documentation for ETL workflows.
• Validate data quality and integrity across sources and targets.

Skills

ETL Design

Data Modeling

Data Quality

SQL Proficiency

Agile Methods

Troubleshooting

Documentation

Testing

Collaboration

Tools

Informatica PowerCenter

Autosys

Bitbucket

Hadoop

SQL/PLSQL

Job description

• 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