Informatica ETL Developer

Job Description

Overview

At Perficient you’ll deliver mission-critical technology and business solutions to Fortune 500 companies and some of the most recognized brands on the planet. And you’ll do it with cutting-edge technologies, thanks to our close partnerships with the world’s biggest vendors. Our network of offices across North America, as well as locations in India and China, will give you the opportunity to spread your wings, too.

We’re proud to be publicly recognized as a “Top Workplace” year after year. This is due, in no small part, to our entrepreneurial attitude and collaborative spirit that sets us apart and keeps our colleagues impassioned, driven, and fulfilled.

Perficient currently has a career opportunity for a Informatica Developer in our Denver, CO office.

Job Overview:

We are hiring for client projects involving ETL development and unit testing of data integrations for enterprise projects currently in progress, the implementation of Informatica’s Master Data Management application, and the implementation of a new enterprise financial application. The scope of the work will include developing ETL mappings in Informatica PowerCenter, unit testing the mappings, testing data loads, creating batch scripts and job scheduling with client’s enterprise scheduling tool, Ctrl-M.

Responsibilities

• The ETL developer role consists of developing Informatica ETL mappings in order to integrate data from multiple sources.
• This role would be working with Tech Analysts, Data Warehouse Architects, and other developers on large enterprise projects including the replacement of an enterprise leasing system, the implementation of Master Data Management and the implementation of a new enterprise financial system.
• The developer will also be involved in designing the data flow, participate in design sessions, document designs, and help with data modeling and creating DDLs.
• They will be participating in daily stand ups, planning, refinement, etc.
• (Optional) Assist with development of Source Code branching and versioning strategies and deployment.

Qualifications

• Experience in ETL tools (Primarily Informatica Powercenter 10+) both as a developer and supporting production mappings/loads.
• Experience in relational databases (e.g. Oracle, SQL Server)
• Knowledge of Windows batch and/or UNIX shell scripting.
• Knowledge of Source Code Control tools such as PVCS, Visual Source Safe, or Microsoft Team Foundation Server.
• Knowledge of automated job scheduling tools such as Control-M.
• Familiarity with Business Intelligence reporting tools (e.g. Cognos & Tableau) is a plus.
• Familiarity with Data Modeling tools (e.g. Erwin) is a plus.

Perficient full-time employees receive complete and competitive benefits. We offer a collaborative work environment, competitive compensation, generous work/life opportunities and an outstanding benefits package that includes paid time off plus holidays. In addition, all colleagues are eligible for a number of rewards and recognition programs including billable bonus opportunities. Encouraging a healthy work/life balance and providing our colleagues great benefits are just part of what makes Perficient a great place to work.

More About Perficient

Perficient is the leading digital transformation consulting firm serving Global 2000 and enterprise customers throughout North America. With unparalleled information technology, management consulting and creative capabilities, Perficient and its Perficient Digital agency deliver vision, execution and value with outstanding digital experience, business optimization and industry solutions.

Our work enables clients to improve productivity and competitiveness; grow and strengthen relationships with customers, suppliers and partners; and reduce costs. Perficient's professionals serve clients from a network of offices across North America and offshore locations in India and China. Traded on the Nasdaq Global Select Market, Perficient is a member of the Russell 2000 index and the S&P SmallCap 600 index.

Perficient is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national, origin, disability status, protected veteran status, or any other characteristic protected by law.

Disclaimer: The above statements are not intended to be a complete statement of job content, rather to act as a guide to the essential functions performed by the employee assigned to this classification. Management retains the discretion to add or change the duties of the position at any time.