Hi ,
Please reply to *anc...@1pointsys.com <anc...@1pointsys.com>* *Position -- ETL Architect with Infosphere deployment Exp* *Location -- Chicago, IL* *Duration-- 18+ months* *Only USC / GC / GC EAD / H4 EAD/ TN / E3* *Job Description:* Project and related application development are part the bank's providing management and regulatory reporting functionality in the areas of risk and compliance. Operational Risk Reporting application is beginning development and two Credit Risk application projects are nearing design phase. This data architect position will work closely with these projects and follow-on risk application development participating in full project life cycle. The candidate would have the opportunity to be involved in the design, architecture and development of many aspects of the Corporate Risk Data Warehouse utilizing Oracle SQL and PL/SQL, data warehouse / ETL tools and Unix Scripts. In addition to design and development, this candidate is expected to be a lead technical resource for this division helping to set standards and practices for production support and maintenance of technical disciplines such as these that are new to this department. Ideally this candidate will also have previous well rounded experience with business application development as well as recent solid concentration on data warehouses, ETL processing and business intelligence tools. The data warehouse ETL processes will interface with numerous Northern Trust corporate transaction systems to gather information for the warehouse. Experienced both in the specific business domain and the software engineering domain. These candidates are not only technology intensive but also possess experience of the specific business area. Have worked on similar projects and have a proven history of delivering high impact business solutions in the specific business area. Responsible for the technical vision, high-level architecture, design, and implementation of complex systems and applications. Ability to interact and communicate effectively with senior level business teams to ensure optimal results. Aside from the business specific knowledge, the individuals will also possess a complete understanding and mastery of the enterprise software development lifecycle. *Technical Skills:* o Understanding of Data Assets and Data Flows in order to represent Data Lineage, Data Relationships, and linkages o Good understanding of the Infosphere deployment Architecture. o Experience with Import Export Manager to import metadata from external tools into the Information Server Repository o Manage metadata assets using istool and Information Server Manager o Metadata repository tool administration, including routine trouble-shooting, user permission roles and security maintenance, performance monitoring and usage monitoring o Good understanding of the Glossary taxonomy concepts such as Categories, Terms, defining relationships between assets, External Assets/mappings and well versed with maintaining Business Glossary and Taxonomy o Experience in ETL tools such as Data Stage, Informatica, etc o Experience in Database Knowledge such as Oracle, DB2, UDB, File System, HDFS, NOSQL, o Exposure to Operating Systems such as Unix/Linux/MVS o Experience with Programming basics in Java, Cobol, JCL, SQL, Scripts, BIG Data (Hadoop) o Experience in Data Warehouse projects is a plus o Understanding of Data Models, Schemas, DDLs, o Usage of Excel advance features o Exposure to XML o Exposure to File Transmissions o Data Analytic skills o Trouble Shooting on the Data Gaps Business Skills High Level understanding of the System/Application Knowledge, System Interfaces Specific Skills IBM Infosphere Information Server (IGC, IMAM) etc., *Anchit Bajpai* *Technical Recruiter* 1 Point System LLC Unit 103, 206 N College St, Pineville, North Carolina, 28134 *P*: *803-792-4353* *E* : *anc...@1pointsys.com <anc...@1pointsys.com>* -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at https://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.