Informatica ETL Developer
Costa Mesa, California
Experian is the world’s leading global information services company, unlocking the power of data to create opportunities for consumers, businesses and society. For more than 125 years, we’ve helped consumers and clients prosper, and economies and communities flourish – and we’re not done. Experian has operated at the center of Big Data since before the phrase was coined. Few companies can offer information services on an equivalent scale. Experian has been named to Forbes Magazine’s Top 100 list of the “World’s Most Innovative Companies” for 4 years in a row. We have 16,000 people operating across 37 countries, and every day we’re investing in new technologies, talented people and innovation to help create a better tomorrow.
- Full Time
- Level: All
- Travel: Limited
- Glassdoor Rating: 3.7 out of 5
Experian Technology is central to the future success of Experian. Whether developing a new product, enhancing a SaaS solution or securing our networks from external threats, you have a critical role to play. When looking for new talent to join our technical teams, we look for individuals with the following traits:
- Innovation 9
- Problem-Solver 9
- Presenter 8
- Technologically savvy 10
- Confident 6
- Independent 4
- Relationship expertise
- Team player
- Technologically savvy
Experian offers comprehensive coverage with flexible options for you as well as your spouse/domestic partner and eligible dependents. This includes medical, dental and vision insurance, health care savings and spending accounts, dependent care FSA, health & wellness program, and telemedicine.
Personal Finance Protection
We offer several benefits that strengthen your financial protection such as a 401k plan with an employer match, an employee stock purchase plan, life & additional insurance coverage.
We invest in your professional future through our education assistance program and many professional development programs. We also grant 20 scholarships to high school seniors each year to children of Experian employees.
We offer flexible time off in addition to corporate holidays, sick days and paid volunteer time off.
Experian supports your life outside the office with benefits such as our new parental leave policy covering time off for birth mothers as well as birth fathers and mothers/fathers of adoptive or foster children, adoption assistance, and pet insurance.
Experian employees enjoy many other benefits through our employee discounts, company sponsored activities, and flexible total rewards packages. Many of our office locations provide onsite amenities such as fitness centers, game rooms, cafeterias and free snacks in break rooms. We support work/life balance with convenient offices in several metropolitan locations and flexible work arrangements when possible.
“I’m a problem solver, strategist, and security engineer in the Cyber Threat Management realm. The best part of my job is creativity and thinking outside the box is encouraged. I work in a team that enables me to innovate and collaborate with other teams to help drive our organization to a better tomorrow.”Lauren Alvarez, Security Engineer
“The best part of my job is the people I get to work with and for. I am surrounded with some of the most innovative, smart and down to earth characters in the field.”Rafael Molina, Sr. Information Security Specialist, EITS
“At Experian, the technology environment is always changing to keep up with the latest technology out there. It’s innovative, yet what’s motivative is that when there is a change in technology, our employees host training sessions because not everyone fully understand the new technology, so we all grow together to find our best way to every solution.”Wes Hoang, Software Dev Intern
“If you are looking for a workplace to Innovate, grow in professional career and Work with great leaders, then Experian is the best place to be at!”Dhaval Dagli, Software Developer
“I personally enjoy working with a variety of application and technical experts in trouble-shooting and figuring out why something failed, and/or working with the same caliber of colleagues to implement real-world solutions to ensure that we have a solid environment that is sustainable and meets the needs of the business.”Kenn Johnson, Interim Manager of Cyber Security Engineering
Our strategy is centred on delivering world-class expertise to organisations, transforming our relationship with consumers and delivering growth consistently, underpinned by foundations...Read More
Machine Learning Applications for Payment Transaction Data
"Experian DataLabs provide a safe and secure environment to partner with our clients to enable breakthrough data experimentation and innovation." Eric Haller(Experian North America)
Experian Hackathon 2017
Collaborating in the Office
IT Clinic in Schaumburg
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.
● 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.
Knowledge, Experience & Qualifications● 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).