Cynet Systems - El Segundo, CA
posted 3 months ago
We are seeking an ETL Developer to join our team in El Segundo, CA. This position is a contract role that involves working with various data sources, including Mainframe extracts, flat files, SQL Server, and web services, utilizing Informatica ETL tools. The primary responsibilities include profiling and analyzing source data to understand its usage, evaluating data sources, data volume, and business rules, and automating job scheduling and monitoring processes. The ETL Developer will be responsible for the extraction, transformation, and loading of data using ETL tools, specifically configuring and scripting business rules and transformation rules in Informatica. The role requires designing and developing ETL Informatica jobs according to business requirements, understanding the data model, and mapping the data to run ETL jobs effectively. Additionally, the developer will ensure that all deliverables undergo appropriate levels of unit testing and system testing. A solid understanding of the deployment process for both Informatica PowerCenter and IICS jobs is essential. The candidate should also be familiar with version control tools such as Bitbucket and Git, including knowledge of branching and code check-in processes. The role may involve defect fixes during system testing, operational acceptance testing, and production phases. The ideal candidate will possess strong experience in defect tracking tools, design and implementation of complex ETL processes, and be proficient in writing complex SQL queries. A good understanding of traditional RDBMS systems like SQL Server, Oracle, and Teradata is also required. Excellent problem-solving, debugging, and performance tuning skills, along with strong communication abilities, are crucial for success in this role.