IT Job Pro

Most Popular Tech Job site – Find Jobs || Post Jobs

Informatica ETL Developer

Costa Mesa, California Experian Ltd

What does it take to protect and maintain the most sensitive data for over 220 million people and 25 million businesses? What does it take to meet daunting challenges and shape solutions that pioneer industries and improve lives? At Experian, we are the trusted power behind data and the leading global information services company, providing everything from fraud and identity protection, to data analytics and credit scores. Our products help decision-making for consumers and businesses alike.

With operations stretching globally, Experian is 17,000 people strong, supporting clients and operations in more than 80 countries. Generating nearly $5 billion in revenue annually, Experian is primed for growth and searching for the most talented and innovative people to join our family and take us to new heights.

Experian’s Consumer Services (ECS) group is defining the next Big Data thing for consumers.

What could be more exciting – personally and professionally – than being part of a disruptive business? Consider starting your career with the industry’s best by joining the Leader that continues to disrupt the competition. As the market leader, we pride ourselves on building new markets and leading the pack through continuous evolution and innovation. It’s a position ECS has enjoyed for more than a decade and we aren’t looking to stop now.

Experian’s Technology team is seeking a talented Informatica ETL Developer. The ETL developer is responsible for ETL development using Informatica in Microsoft SQL Server environment and all aspects of data warehouse reporting.

Responsibilities:

Work as part of a team to deliver federated dimensional model for growing online consumer subscription service.
Play key role in adding data to the Data Warehouse through development of source to targets maps and transformation rules.
Participate in requirement definition, solution development and implementation phases of data warehouse and reporting projects.
Develop Informatica ETL for Cognos FM, cube, and report development.
Create and maintain ETL specifications and process documentation to produce the required data deliverables (data profiling, source to target maps, ETL flows).
Assist in definition of logical and physical data models B2C ecommerce business.
Configure and tune ETL infrastructure to optimize the data warehousing architecture.
Troubleshoot and resolve data, system issues and performance issues.
Bachelor’s degree in Computer Science, Engineering or similar field from an accredited four-year university required.
Minimum 7 years of experience in software development.
Minimum 5 year experience in Informatica development.
Expertise in Informatica development and performance tuning.
Experience with business intelligence or reporting tools (preferably Cognos BI tools: Framework Manager, Power Play, ReportNet, Metric Studio).
SQL Server – SSIS, SQL queries and stored procedures.
Good experience with data warehouse concepts and methodologies.
Have working experience in ecommerce industry and web analytics will be a plus.
Good written and oral communication skills; excellent technical skills.
Highly motivated self-starter, detail and quality oriented and able to work independently.
Experience with data modeling tool (ER/Studio).

To apply for this job please visit itjobpro.com.