Hello Partners, Hope you are doing great. I have a requirement as below.
Please let me know if you have any candidates for this. I can be reached on 217-321-1964 / [email protected] *Requisition Name: Sr. Informatica Developer* *8+ Months* *Location: Atlanta , Georgia* *Description:* The desired candidate will be responsible for design, development, testing, maintenance and support of complex data extract, transformation and load (ETL) programs for an Enterprise Data Warehouse using Informatica Power Center 9.0. The successful candidate will have the ability to take the logical dimensional data model and use ETL skills to load the dimensional physical layer from various sources including DB2 on z/OS, Sql Server, Oracle, MS Access, etc. An understanding of how complex data should be transformed from the source and loaded into the data warehouse is a critical part of this job. *Other responsibilities include but are not limited to:* · Collaborate with business users to capture & define business requirements and contribute to defining the data warehouse architecture (data models, data analysis, data sourcing and data integrity) · Analyzing source data for potential data quality issues and addressing these issues in ETL procedures · Develop technical design documents and mappings specifications to build Informatica Mappings to load data into target tables adhering to the business rules · Design, develop and organize complex Informatica mappings, sessions and workflows · Provide support for existing systems and work on new development initiatives simultaneously · Actively participate in design and analysis sessions to ensure sound team decision-making · Support system and user acceptance testing activities, including issue resolution. · Complete technical documentation to ensure system is fully documented · Mentor and train IT staff by sharing knowledge, best practices and lessons learned from past implementation efforts · Design and develop Extract Transform and Load (ETL) and Data Integration (ETL) solutions for complex functional and technical requirements using Informatica PowerCenter Version 9.0 and 9.1. · Design and develop ETL using CDC using Power Exchange 9.1 in Mainframe DB2 environment. · Demonstrate hands-on experience in design and development of Informatica based solutions. · Demonstrate in-depth understanding of Data Warehousing (DWH) and ETL concepts, ETL loading strategy · Hands on experience with Complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy etc · Experience in using Informatica Mapping/Session/Worklet/Workflow variables and parameters, running Informatica Workflows in RHEL unix. · Experienced in Testing, Debugging, Validation and Performance Tuning of ETL Architecture, help develop optimum solutions for Informatica deliverables and Table portioning in DB level. · Involved in migration of objects in all phases (DEV, QA and PRD) of project and trained developers to maintain system when in production. · Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Slowly Changing Dimensions, Fact and Dimensional tables, Physical and Logical data modeling using Erwin Required Qualifications: · 5+ years’ experience working with Informatica Power Center · Ability to design and develop complex Informatica mappings, sessions, workflows and identify areas of optimizations · Ability to design logical and multi-dimensional data models · Experience with Oracle RDBMS 10g or 11g · Strong communication skills (both oral and written) and the ability to work effectively in a team environment are required · A bachelor’s degree in Computer Science or related field or seven to 10 years of IT related experience · Proven ability and desire to mentor/coach others in a team environment · Strong analytical, problem solving and presentation skills. Preferred Qualifications: · Working knowledge with Informatica Change Data Capture installed on DB2 z/OS · Working knowledge of Informatica Power Exchange · Experience with relational, multidimensional and OLAP techniques and technology · Experience with OBIEE tools version 10.X *Thanks* *Patrick Smith* *Lead Technical Recruiter* *Lead IT Corporation** – IT **Services & Solutions* 1999 Wabash Avenue, Suite 210, Springfield, IL 62704 Tel: 217-909-2384 Ext: 101(O) | Fax: 801.705.2524 Direct: 217-321-1964 Email: [email protected] Web: http://www.leaditgroup.com *Microsoft and Oracle and accela Partner | A Certified MBE Company | E Verified Employer* [image: LinkedIn] <http://www.linkedin.com/pub/patrick-smith/77/36a/a54/> *[image: http://leaditgroup.com/Content/images/twitter.png]* <https://twitter.com/LeadITCorp> *[image: http://leaditgroup.com/Content/images/facebook.png]* <http://www.facebook.com/pages/Lead-I-T-Corporation/121013161326563> * Please check our awards and achievements @ http://leaditgroup.com/Home/News <http://leaditgroup.com/Home/News>* ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Note: Lead IT does not endorse undesired email. If you do not want to receive our mails, please reply with Remove in the subject; I would ensure that you are not troubled further. I apologize for any inconvenience -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/corptocorp. For more options, visit https://groups.google.com/d/optout.
![http://leaditgroup.com/Content/images/twitter.png]*](http://leaditgroup.com/Content/images/twitter.png]*){kind=link}
![http://leaditgroup.com/Content/images/facebook.png]*](http://leaditgroup.com/Content/images/facebook.png]*){kind=link}