Hi
Please share a profile at* agam.ku...@contech-it.com <agam.ku...@contech-it.com>* *Title:Senior/Lead Informatica Data Warehouse Developer Location:: EDEN PRAIRIE, MNPosition type:Contract Job* *Job Description:* *JOB TITLE:Senior/Lead Informatica Data Warehouse Developer* This is an exciting role within the rapidly growing Optum HouseCalls division within Health Care Company. HouseCalls is a service offered by Optum to members of Medicare Advantage plans, wherein a Nurse Practitioner visits the member s home once a year to conduct a thorough medical health assessment on the member. This is a highly sought after service in the Medicare market with positive clinical benefits for our members and the company. *Responsibilities* - The position is responsible for leading and mentoring the ETL development team - Lead/mentor other ETL developers for implementing best practices and troubleshooting - Provide production support for all ETL processes - Perform technical analysis, ETL design, development, testing, and deployment of IT solutions - Develop Informatica mappings, workflows, and transformations and maintain ETL process to populate data warehouse - Troubleshoot, optimize and tune ETL processes; utilize reusability, parameterization, workflow design, caching, parallel processing and other performance tuning techniques - Perform data analysis through reading thousands of lines of SQL code and document the business logic - Read thousands of lines of SQL code and document the business logic - Create source to target mapping documents, including business logic (data rules) - Create design documents high Level & low Level design documents - Document test cases and test results - Work closely with other subject matter experts to help design and build solutions for a multitude of applications, including batch processing, OLAP and data warehouse architecture *Requirement* - Minimum 7 years of Informatica experience with 2 years in the capacity of a Lead Developer/Tech Lead - Strong experience in building data warehouses using Informatica - Experience in designing, creating ETL's for a large Data Warehouse project - Experience in querying and analyzing data sources to understand the data and determine logic for transformations - Experience with Informatica PowerCenter 8.6 or higher version - Strong technical experience with Oracle exadata, SQL Server, Informatica ETL, SQL, PL/SQL - Must be willing to work diligently to meet project deadlines - Must have experience with Informatica design work - Knowledgeable in performance tuning, load optimization for Informatica batch processes and enforcing repository best practices - Good understanding of star schema and 3rd normal form design - Experience in loading 3rd normal form database as target - Excellent oral, written, and communication skills - Ability to communicate to a variety of audiences in both verbal and written form - Preferred: software development (coding) using SQL language - Certification in Informatica, datastage, SQL, Oracle is a plus - Healthcare knowledge is an added advantage *Hours:* 8am- 5pm. Mon- Fri *Dress Code:* Business Casual *Interview:* Face to Face or Video conference *Agam Kumar* _________________________________________________________ Contech Systems, Inc. • 1480 U.S. Highway 9 North, Suite 206 • Woodbridge, NJ 07095 • D ( <%28925%29-353-6071>972-798-4725) • F (732)632-8817 -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-projects+unsubscr...@googlegroups.com. To post to this group, send email to oracle-projects@googlegroups.com. Visit this group at https://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/d/optout.
