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 full-time, career opportunity for a Senior Informatica/ETL Developer .  Candidate must be elibigle to work in the United States for any employer without sponsorship.Any reside anywhere in US and should be open to work in Pacific time zone.

Technology Consultants are responsible for the implementation and configuration of the technical infrastructure including web applications, layered software, hardware platform and operating systems. The Technology Consultant regularly consults with clients on best practices, issue resolution and experience guidance in order to improve the performance/reliability of client's technical environment.

·       Identifying and analyzing business requirements, translating requirements to technical specifications 

·       Working closely with senior data analyst of both source and targetsystems to ensure the requirements are correctly implemented

·       Designing and developing ETL solutions using Informatica that follow the in-house ETL development standards; managing program coding for the extraction of data from all existing source systems, transforming data to industrystandards and generating extract files.

·       Establishing testing/quality assurance environments; working with clients and system to ensure that programs and modifications are error free.

·       Monitoring system performance, and other aspects of systems to identify technical problems; monitoring data integrity to identify data quality problems; designing and enhance the data quality improvement process including feedback to system stewards.

·       Troubleshooting production problems

·       Providing technical support to users; assisting clients in analyzing functional problems; work with clients to prioritize the data quality concerns and to communicate the need for accurate data by other constituents at the university; producing technical specifications and data mappings document; documenting the program modifications

·       Documenting the solutions, the programming changes, and the problems and resolutions

·       7-8 years of Data warehousing, ETL, working in an enterprise class production data warehouse environment

·       Hands on experience in fundamental of advanced Datawarehouse and Data mart design

·       Hands on and excellence in ETL design, implementation and maintenance. Solid experience in process and workflow tuning and optimization. 

·       Experience with the system development lifecycle, such as gathering and refining requirements, data analyzing and data profiling, designing and implementing solution, handling sensitive data sets, production deployment, troubleshooting and production support, data conversion, etc.

·       Experience with Informatica PowerCenter, Oracle PL/SQL procedures, IBM Netezza and, ERwin

·       Proficiency in Linux and shell scripts, job scheduling

·       Proficiency in networking, IT infrastructure and enterprise security will be great asset

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.