*Please respond back to [email protected] <[email protected]> or call me on 703 596 1600 x 104.*
*Job Title: ETL Developer Senior / Architect* *Location: Chicago, IL* *Duration : 6+ months* *Scope of Responsibilities / Expectations:* Hands-On ETL Architect acting as an ETL Senior Developer - Demonstrates full understanding of Software Development Life Cycle (SDLC). Responsible for design and development of ETL and database business applications. Possesses detailed knowledge of software design and best practices. Possesses knowledge of system and database management concepts. Provides design recommendation based on long term IT organization strategy. Provides expertise regarding the integration of applications across the business. Assists in determining specifications for software solutions. Provides advanced programming services for a variety of specific systems and business applications. Participates at all levels in systems analysis, design definition, software development, systems test, implementation, and maintenance. Demonstrates hands-on experience with software automation (e.g. unit testing, continuous integration). Exercises independent judgment. Prepares milestones status report and presentations on system concepts. Is expert in one or more programming languages such as Informatica ETL, MS SQL Server, Oracle, SQL, PL/SQL, TOAD and Cognos. Provide both order-of-magnitude and detailed estimates for software architecture and design activities and artifacts. Demonstrates good understanding of Agile and RUP software development methodologies. Develops software and provides technical expertise for analysts, developers, testers and technicians as needed to support Enterprise Information Technology National Program projects such as the Licensee Desk-Level Audit (LDLA) application, the Performance Tracking System (PTS) sunset, the Inter-Plan Data Solutions (IPDS) common extract and the Inter-Plan Performance Score Card. Health insurance industry background in the area of Claim Processing/Adjudication is preferred. Experience with BCBS Plans, a big plus! *Specific Required Knowledge / Skills* Bachelor's or Master’s Degree in Computer Science and Engineering, Computer Science or equivalent experience Candidates must have 7+ years of experience with Informatica ETL tool, MS SQL Server and Oracle databases, MS Windows, Unix shell scripting, developing and tuning Informatica and SQL and PL/SQL code Expertise in SQL and PL/SQL Tuning - Understand existing code and make tweaks as needed Senior Informatica developer with ability to design, code and unit test Informatica mappings. Informatica certified developers a plus Source to target mapping Analysis Design the ETL application architecture based on the documented requirements. Design and develop scalable Informatica processes. Ensure that the ETL requirements are adequately understood and documented. Assist in the development of the ETL Informatica application. Perform Integration functions for all Informatica code, including ensuring that system and integration test plans are developed and executed. Develop detailed ETL Informatica specifications based on Solution Architecture requirements. Develop and test the ETL application following all Informatica standards and architecture. Assist in the design of the ETL application. Minimum of 7 years of IT work experience focused in systems development and programming Minimum of 7 years software design/development experience using Informatica ETL and database for business applications Hands-on experience with Informatica 9.6.1 ETL Strong database experience using, MS SQL Server 2008, Oracle 10g/11g, SQL, PL/SQL and TOAD Expertise in writing shell scripts and understanding of PERL Experienced in working with Erwin Ability to work with Enterprise monitoring tools and help debug performance bottlenecks Experience w/ Rational Unified Process Methodology & Rational Tools ( ClearCase, ClearQuest, RequisitePro, Rational Rose) Experience integrating one or more of the following: MS SQL Server, Oracle, Cognos, Websphere, ETL w/ various Java frameworks such as Spring Strong Initiative with good verbal and written communication skills Demonstrated experience working within a team environment Proven ability to work w/ minimal supervision & adhere to schedules Highly desirable for candidate to have prior experience with BCBSA Inter-plan systems: Blue2, BlueExchange, PDR, LDLA, or BDC. Highly desirable to have Familiarity with BCBSA development processes and methodologies. *Deliverables: * Deliver enhancements and provide support and maintenance for scheduled software releases: Full Release LDLA 15.5, Full Release LDLA 16.0 and Point Release IPP Score Card 2.1 *Thanks & Regards* *Sateesh | Lead Technical Recruiter* *Protege, LLC.* *12020 Sunrise Valley Dr, Suite 100, Reston VA 20191* *Email: [email protected] <[email protected]> | Gtalk: recruiter.sateesh* *Office: 703 596 1600 x 104; Fax: 877 481 9005* *Visit us at: www.protegellc.com <http://www.protegellc.com>* -- You received this message because you are subscribed to the Google Groups "OracleD2K" 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 https://groups.google.com/group/oracled2k. For more options, visit https://groups.google.com/d/optout.
