Python Informatica Developer (ONLY ON W2)

Ingenworks - San Antonio, TX

Full-time

San Antonio, TX

Professional, Scientific, and Technical Services

About the position

We are looking for a skilled Python Informatica Developer to join our team. The ideal candidate will have experience in both Python programming and Informatica ETL tools, and will be responsible for developing and maintaining data integration and data processing solutions. You will work closely with data architects and business analysts to design and implement robust ETL processes and automate data workflows. In this role, you will be tasked with designing, developing, and maintaining ETL processes using Informatica PowerCenter and Python scripts. You will work with various data sources, including SQL, NoSQL, and APIs, to extract, transform, and load data into data warehouses and databases. Automation will be a key focus, as you will develop Python scripts to automate data processing and integration tasks, ensuring efficient data extraction, transformation, and loading. Data quality is paramount, and you will implement data quality checks and validation processes to ensure data accuracy and integrity. Performance optimization will also be a critical aspect of your responsibilities, as you will optimize ETL processes for performance and scalability, troubleshooting any performance issues as they arise. Collaboration is essential in this role; you will work closely with data architects, data scientists, and business stakeholders to understand requirements and provide effective data solutions. Additionally, you will create and maintain technical documentation for ETL processes, data flows, and Python scripts, and provide support for existing ETL processes and workflows, including troubleshooting and resolving issues.

Responsibilities

• Design, develop, and maintain ETL processes using Informatica PowerCenter and Python scripts.
• Work with various data sources (e.g., SQL, NoSQL, APIs) to extract, transform, and load data into data warehouses and databases.
• Develop Python scripts to automate data processing and integration tasks, including data extraction, transformation, and loading.
• Implement data quality checks and validation processes to ensure data accuracy and integrity.
• Optimize ETL processes for performance and scalability, and troubleshoot performance issues as needed.
• Collaborate with data architects, data scientists, and business stakeholders to understand requirements and provide effective data solutions.
• Create and maintain technical documentation for ETL processes, data flows, and Python scripts.
• Provide support for existing ETL processes and workflows, including troubleshooting and resolving issues.

Requirements

• 8+ years of experience in ETL development using Informatica PowerCenter and Python.
• Strong proficiency in Python programming for data manipulation and automation.
• Experience with Informatica PowerCenter, including workflow and mapping design.
• Proficiency in SQL and database management systems (e.g., Oracle, SQL Server, PostgreSQL).
• Understanding of data warehousing concepts and ETL best practices.
• Strong analytical and problem-solving skills with the ability to troubleshoot complex data issues.
• Excellent communication skills to work effectively with cross-functional teams and stakeholders.
• Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field.

Nice-to-haves

• Experience with cloud platforms such as AWS, Azure, or Google Cloud.
• Knowledge of data modeling, data governance, and data quality frameworks.
• Familiarity with big data technologies (e.g., Hadoop, Spark).
• Experience with RESTful APIs and web services for data integration.