Job ID :
Company :
Internal Postings
Location :
Type :
Duration :
6 Months
Salary :
Status :
Openings :
Posted :
20 Jun 2018
Job Seekers, Please send resumes to
Position Overview:

This position focuses on data architecture with a perspective of data integration through Extract/Transform/Load. The incumbent will be working with business owners of data, business analysts, and data custodians, and should be able to architect and design data flows, data interfaces, and data usage patterns. The incumbent will be expected to take design work further to define detailed approach and data Extract/Transform/Load artifacts, as well as deploy the detailed design through enterprise standard tools.

Essential Job Functions:
  • Determine database structural requirements by analyzing client operations, applications, and programming, while reviewing objectives with clients and evaluating current systems
  • Develop database solutions by designing proposed system
  • Define database physical structure and functional capabilities to accommodate data integration requirements, security, back-up, and recovery specifications
  • Ensure optimum performance techniques for data integration, coordinate deployment actions, and document actions
  • Maintain overall performance of components involved in Data Integration through ETL by identifying and resolving production and application development problems
  • Calculate optimum values for parameters
  • Evaluate, integrate, and install new releases
  • Complete maintenance
  • Answer user questions
  • Provide support to data integration and ETL components by coding utilities, responding to user questions, and resolving problems
  • Update job knowledge by participating in educational opportunities, reading professional publications, maintaining personal networks, and participating in professional organizations
  • Accomplish information systems and organization mission by completing related results, as needed
Educational Qualifications and Experience:
  • Education: Bachelor’s degree in Computer Science
  • Role Specific Experience: 5+ years of experience with developing meta dat, data lineages and interfaces using Industry standard tools
  • Experience in enterprise integration and implementation of COTS financial applications, business process modeling, user interface designing, and drafting of detailed architecture documentation
  • Extensive experience with one or more leading RDBMS e.g. Oracle, MS SQL Server, etc.
  • Extensive experience with MS SQL Server, Oracle, and Sybase databases
  • Extensive Experience with data integration (Real-time and ETL)
  • Extensive architecture experience with financial equity applications
  • Extensive experience with designing and/or implementing an equity COTS package called Investran
Certification Requirements:
  • FEAF, CMMI, COBIT, ITIL, SCRUM, CDMP, Six Sigma, etc. certifications (preferred)
Required Skills/Abilities:
  • Advanced knowledge of Data Integration concepts and standard approached
  • Strong leadership and communication skills
Desired Skills/Abilities (not required but a plus):

Experience in one or more of the following technologies:
  • Data dictionaries
  • Data warehousing
  • Enterprise application integration
  • Metadata registry
  • Master Data Management (MDM)
  • Relational Databases
  • NoSQL
  • Semantics
  • Data retention
  • Structured Query Language (SQL)
  • Procedural SQL
  • Unified Modeling Language (UML)
  • XML, including schema definitions (XSD and RELAX NG) and transformations
  • Additional consideration will be given to those individuals who possess the following specific competencies (in no specific order): Crystal Xcelsius, SAP BW.
Pluses for Levels: (level II, III):

Experience Matrix for Levels:
  • Level I - 2+ years of experience
  • Level II - 5+ years of experience
  • Level III - 7+ years of experience.