Job Description :
Title: ETL Informatica Developer
Location: Birmingham , AL
Full Time

MUST HAVES
Bachelor’s Degree in Computer Science related field or equivalent work experience preferred
At least 3 years’ experience developing business intelligence or data based reporting applications using SQL and an enterprise-grade database (Oracle, IBM DB2, Microsoft SQL Server)
Insurance industry knowledge and experience is a plus

Job Description:
Developer – ETL, Business Intelligence Group
A software company developing software systems for insurance domain is seeking an experienced Business Intelligence professional to join them in developing and deploying today's most advanced consumer-facing reporting and analytic applications.
In this role, you will be designing and developing ETL/data integration processes and programs to support data transfer.
You will be at the center of our strategy, enabling our customers to have a conversation with their data. The ideal candidate will have a strong background in building business intelligence solutions using relational and analytic databases, extract transform and load (ETL) tools and ad hoc query software. Excellent communication skills, superior problem-solving/analytical skills and a positive, professional attitude are required.
Overall responsibility
An ETL Developer on the Business Intelligence team creates designs, develops code for the extraction, transformation, cleansing and loading of data.
The position will closely collaborate with architects and other ETL developers.
Key areas of responsibility
Develop, implement and test ETL packages
Provide technical documentation
Provide after hour support for production ETL systems
Map source system data to data warehouse models.
Keep technical skills and product knowledge sharp via ongoing training and study

Skills and experience requirements
Bachelor’s Degree in Computer Science related field or equivalent work experience preferred
At least 3 years’ experience developing business intelligence or data based reporting applications using SQL and an enterprise-grade database (Oracle, IBM DB2, Microsoft SQL Server)
Insurance industry knowledge and experience is a plus

Required technical skills:
Data Manipulation using SQL, procedural language SQL programming (PL/SQL, TSQL, etc),
Excellent Informatica Power Centre experience
Database loading using a high-volume, enterprise-grade toolset (Informatica, SSIS, Data Stage, Pentaho Data Integrator, Oracle Data Integrator