Overview:
ETL Data Integration Developer III
Los Angeles, CA (Remote/Hybrid)
6-month contract (Temp to Hire)
Job ID 2023-8499
Solugenix is assisting a client, a health insurance company, in their search for a
ETL Data Integration Developer III. This is a 6-month contract opportunity based out of Los Angeles, CA (Remote/Hybrid).
Summary:
The ETL Data Integration Developer III is responsible for the operational support of Informatica environment including but not limited to automation, job scheduling, dependencies, monitoring and maintenance of Extract, Transform, and Load (ETL) mappings, mapplets, and documentation. This position will manage, administer and work with ETL administration in addressing systems performance including on-going optimization and tuning of Informatica environment. This position will develop reliable and complex ETL processes to support new development of the Enterprise Data Warehouse, Data Marts and other Business Intelligence projects. This position will also assist the Data Warehouse team in completing current Data Warehouse initiative projects. This position will also perform the duties to analyze and evaluate the data source and data targets required for the ETL mapping. Design, develop and implement complex ETL processes. It will also support and participate in source data analysis, specifically as it relates to domain definitions. Acts as a Subject Matter Expert serves as a resource and mentor for other staff.
Qualifications:
- Bachelor's Degree in Statistics or Related Field instead of a degree, equivalent education and/or experience may be considered.
- Master's Degree in Statistics.
- Strong database development skills including the ability to analyze, create and optimize complex SQL queries and stored procedures, working on relational databases, especially Oracle & MS SQL Server.
- Proficient in data analysis and problem-solving.
- Possess excellent communication skills, both written and verbal.
- Thorough knowledge of Systems Development Life Cycle (SDLC).
- Must develop, foster and maintain an open, professional relationship with IT staff, management and business customers.
- Excellent verbal and written communication skills.
- Strong organizational and documentation skills and understanding of DW/BI concepts. Good knowledge of the Software Development Lifecycle.
- Understanding of development lifecycle methodology and ability to successfully deliver Informatica assignments. Healthcare domain.
- Proven ability to perform technology needs assessment and evaluate solution options.
- The capability of performing interface analysis at the detail level. A solid understanding of software development life cycle; and broad-based knowledge of application systems technologies.
- 5-7 years of experience in Informatica ETL Developer role in Data Warehouse projects, Enterprise Data Warehouse, Online Analytical Processing (OLAP) and dimensional data modeling.
- At least 3 years of proven development experience in design and development of ETL/Data Integration and Informatica Power Center Suite.
- Experience with Erwin data modeling toolset and working in a PL-SQL environment.
- Expert in database concepts, logical/physical design and development.
- Strong experience and comprehensive proficiency with Informatica in an Oracle Data Warehouse/BI environment Experience in documenting requirements and negotiating commitments Strong project life cycle experience.
- 5 years of experience in Informatica ETL Developer role in Data Warehouse projects, Enterprise Data Warehouse, OLAP and dimensional data modeling.
Responsibilities:
- Responsible for the operational support of the Informatica environment including but not limited to automation, job scheduling, dependencies, monitoring, maintenance, patches, upgrades, security, and administration.
- Administers systems performance including ongoing optimization and tuning of Informatica environment. Supports and enhances existing Informatica environment and develops new, complex ETL processes to support additional design, development and deployment of the Enterprise Data Warehouse and Data Marts.
- Assist data warehouse team in completing current data warehouse initiative projects. Analyze and evaluate data sources. Designs and implements complex ETL processes.
- Applies subject expertise in evaluating business operations and processes.
- Identifies areas where technical solutions would improve business performance.
- Consults across business operations, providing mentorship, and contributing specialized knowledge.
- Ensures that the facts and details are correct so that the project’s/program's deliverable and meets the needs of the department, organization and legislation's policies, standards, and best practices.
- Provides training, recommends process improvements, and mentors junior-level staff, department interns, etc. as needed Perform other duties as assigned.
Pay Range for CA, CO, NJ, NY, WA: $62/hour to $67/hour. Starting rate of pay offered may vary depending on factors including but not limited to, position offered, location, education, training and/or experience.
About The Client
Our client is one of the world's leading health insurance company based out of Los Angeles, CA.
About Solugenix
Solugenix is an information technology services company known for its deep experience and knowledge in providing comprehensive technology services, solutions, and talent support for companies around the world. The company offers a variety of cutting edge and talent support solutions to promote growth and cutting-edge advancement to our esteemed clients and candidates. We provide these talent support solutions on a contract, contract-to-hire, and direct hire basis. We also have additional resources from our staffing partners to ensure the right match and expertise for the best result.
For over 50 years, global and local brands have trusted Solugenix as an added resource and partner in taking steps to ensure their immediate and future success. In addition to generating ground-breaking, industry-defining solutions, Solugenix has been delivering the talent and support needed to make it happen. We are dedicated to partnering with clients and candidates whose core values also foster a culture of professionalism, teamwork, and integrity.