ETL Developer - Informatica
*Job Overview*
As an ETL Developer - Informatica, you’ll build and maintain reliable data pipelines that move, transform, and organize information for analytics and business intelligence. You’ll partner with data engineering and business teams to turn data needs into clear, scalable solutions across data warehouses and public cloud environments.
*Duties*
- Develop, test, and maintain ETL pipelines using Informatica; integrate data from SQL databases, Oracle, Microsoft SQL Server, cloud databases, and RESTful APIs.
- Design data models, dimensional models, and data warehouse structures; manage queries and support data quality and linked data needs.
- Your impact: Reliable, well-organized data helps analysts and business teams make informed decisions through trusted analytics and business intelligence tools.
- Monitor and troubleshoot big data systems and workflows using technologies such as Hadoop, Apache Hive, Spark, and Azure Data Lake.
- Collaborate in Agile software development, document data management integration, and support analytics and model training requirements.
*Qualifications*
- Experience with Informatica, ETL, SQL, data engineering, data modeling, database design, and data warehousing design.
- Familiarity with big data and public cloud platforms, including AWS or Azure; exposure to Java, Python, Talend, VBA, Bash (Unix shell), or shell scripting is useful.
- Understanding of business intelligence tools such as Looker, query management, linked data, and data warehouse concepts.
- Strong analysis skills and the ability to communicate technical solutions clearly; experience with Spark, Hadoop, Apache Hive, or cloud databases is preferred.
Work Location: Remote