ETL Informatica Developer

Unclassified - Jersey City, NJ

Full-time - Mid Level

Jersey City, NJ

About the position

The ETL Informatica Developer position is a critical role that requires a blend of technical expertise and analytical skills to develop complex ETL workflows using Informatica PowerCenter. The individual will be responsible for creating data mappings to ingest data from various sources, including flat files, relational databases, Hive, and REST APIs. This role demands proficiency in Unix scripting and a strong understanding of MuleSoft tools, as integration with these tools is a mandatory requirement. The developer must be capable of working independently with minimal supervision, demonstrating initiative and self-motivation in their tasks. In addition to development responsibilities, the ETL Informatica Developer will be tasked with developing test cases and performing unit testing to ensure the integrity and performance of the ETL processes. Effective communication and coordination with a distributed team are essential, as the developer will need to provide regular updates on task status to management. The role also requires a strong foundation in performance tuning of targets, sources, mappings, and SQL queries, along with a conceptual understanding of PL/SQL, functions, and the ability to write complex SQL queries and create views or materialized views. The ideal candidate will possess strong UNIX command skills and scripting abilities, along with a good grasp of MuleSoft integration. Familiarity with source control repositories such as SVN or BitBucket, continuous build integration tools like IBM UBuild or Jenkins, and defect management processes is highly desirable. Experience with Agile tools such as Jira or Rally is a must, as is the ability to analyze requirements, prioritize tasks, and identify risks effectively. The candidate should be highly motivated, capable of leading both onshore and offshore teams, and possess strong problem-solving and analytical skills. A willingness to learn and adapt to changes in technology and processes is also crucial for success in this role.

Responsibilities

• Develop complex ETL workflows using Informatica PowerCenter.
• Create data mappings to ingest data from various sources including flat files, RDMS, Hive, and REST APIs.
• Develop Unix scripting for ETL processes.
• Perform unit testing and develop test cases for ETL workflows.
• Interact and coordinate with a distributed team effectively.
• Provide regular task status updates to management.
• Optimize performance of targets, sources, mappings, and SQL queries.
• Write complex SQL queries and create views/materialized views.
• Utilize MuleSoft tools for integration purposes.

Requirements

• Strong technical skills in Informatica PowerCenter.
• Proficiency in performance tuning of ETL processes.
• Conceptual knowledge of PL/SQL and functions.
• Ability to write complex SQL queries.
• Strong skills in UNIX commands and scripting.
• Experience with MuleSoft integration tools.
• Familiarity with source control repositories like SVN/BitBucket.
• Experience with continuous build integration tools (IBM UBuild/Jenkins, IBM UDeploy/Ansible).
• Strong experience in functional and ETL database testing.
• Knowledge of defect management processes.
• Experience with Agile tools (Jira/Rally).
• Strong competency in requirement analysis and risk identification.

Nice-to-haves

• Experience with automation using TOSCA.
• Ability to lead a team of onshore and offshore resources.
• Strong problem-solving and analytical skills.
• Willingness to learn and adapt to changes.