Citizens Bank ETL Developer 3 (3554051) Warwick RI
*3 Positions* 6 months Need a DataStage Developer with the following skills: - Datastage Enterprise Edition *on AIX - UNIX / AIX - UDB / DB2 on AIX - Perl scripting - Java - PL/SQL* - Software Development Life Cycle - *Unit / Sit Test Case development* - Communication Skills - Team environment - Should be comfortable working with a large team of 10-15 - Should have experience working with large scale enterprise size environments. - Knowledge of best practices in large data warehouses Top technical skills: Must have expertise in using various *IBM datastage stages and design jobs in datastage 7.5.3 & 8X * - Must have knowledge and experience of *UNIX shell scripting* - Must have good knowledge of any *SQL.* Experience with DB2 is preferred - Preferred knowledge of perl - Preferred knowledge of IBM BDW Nice to have skills: Nice to have - Perl scripting - UDB / DB2 on AIX - Autosys scheduling - Any knowledge of reporting tools - Erwin data modelling Summary: Responsible for writing programs to maintain and control computer systems software for operating systems, networked systems, and database systems. Responsible for creating the software platform, and then fine-tuning the final program after it has been made. Education/Experience: Associate's degree in computer science or relevant field - preferred. 5+ years experience required. Skills and Competencies: Verbal and written communication skills, problem solving skills, customer service and interpersonal skills. Must have a strong command of the English language � written and oral. Ability to work independently and manage one�s time. Knowledge of the full software development lifecycle: from business/systems analysis, through requirements gathering and functional specification authoring, to development, testing and delivery. Ability to troubleshoot issues and make system changes as needed to resolve issue. Solid hands-on experience with at least one contemporary data transformation tool. Experience in systems development and programming and mapping business requirements to technical solutions. Excellent working knowledge of RDBMS SQL, DML, XML, and DDL. Detailed knowledge of Data Warehouse and Data Mart physical RDBMS schemas. Major Job Duties and Responsibilities: Modify existing software to correct errors, to adapt it to new hardware or to upgrade interfaces and improve performance. Design and develop software systems, using scientific analysis and mathematical models to predict and measure outcome and consequences of design. Analyze the data flow requirements and develops a scaleable architecture for extracting, transforming, staging and loading data into RDBMS. Interpret the transformation rules for all target data objects and develop the software components to support the transformation. Test, load and validate data and ETL process. Prepare/implement data verification and testing methods for the Enterprise Data Warehouse. Design/implement data staging methods and best practices. This position is supporting the Comprehensive Capital Analysis and Review (CCAR) project. The CCAR is montly/quarterly exercise by the Federal Reserve to ensure that institutions (Citizens) have robust, forward-looking capital planning processes that account for their unique risks and sufficient capital to continue operations throughout times of economic and financial stress CFG is seeking a DataStage Developer with 3-5 years of experience. Banking experience is not required. Design exp is desired but not required, the resource will be working on developing. This person should have experience with Datastage (v7.5 or greater), Databases (DB2) and Unix. This individual must be able to work onsite at Tripps Lane in East Providence. Kind Regards *Fazal Mahmood* *Aspire Systems Inc.* *Certified Minority Owned Business Enterprise (MBE) * *E-Verified Approved Employer* *Four Time Award Winner ( 2009 & 2010 & 2011 & 2012) Best of Danbury Award* *Approved Inc. 500 Company* *Corp Office: * *36 Mill Plain Road, **Suite # 16, Danbury, CT 06811* *Ph : 732 414 2854* *Fax : 203 798 0060* *Email: **fa...@aspiresystem.com <a...@aspiresystem.com>* *Yahoo IM*:* fazalmrecruiter* *URL: **www.aspiresystem.com <http://mail.aspiresystem.com/exchweb/bin/redir.asp?URL=http://mail.aspiresystem.com/exchweb/bin/redir.asp?URL=http://www.aspiresystem.com>* -- You received this message because you are subscribed to the Google Groups "java-core" group. To unsubscribe from this group and stop receiving emails from it, send an email to java-core+unsubscr...@googlegroups.com. To post to this group, send an email to java-core@googlegroups.com. Visit this group at http://groups.google.com/group/java-core. For more options, visit https://groups.google.com/d/optout.
