Job Seekers, Please send resumes to resumes@hireitpeople.comDESCRIPTION:
The Customer Data Integration (CDI) Engineer is responsible for developing code to integrate, transform, and populate data in the client database from data sources provided by the client and/or third-party data sources. The CDI Engineer understands the complete data life cycle in an agency environment. This requires both technical and business skills that include technical requirements, documentation, and development as part of the complete software development life cycle (SDLC). In addition to new projects, there are existing implementations where the CDI Engineer is called upon to handle data maintenance items like data quality management, error handling, and code break/fix.
MAIN RESPONSIBILITIES
· Based on business requirements, contributes to detailed technical requirements and specifications; identifies missing details in the business requirements and engages the appropriate resource(s) for clarification
· Develops mapping and data processing procedures to import data from various data sources and populate the client database
· Develops data extracts and procedures to support internal and client (external) business analytics
· Develops unit test cases and ensures successful test completion before delivery of code to quality assurance (QA) team (unit tests should be thorough and cover all functions dealing with business logic and data layouts)
· Develops efficiencies throughout the SDLC on an iterative basis; this includes reuse of existing internal/third-party components
· Coordinates with QA team to ensure quality deliverables; this includes delivering bug fixes, documentation, and appropriate dependency information with every release
· Consistently checks work area code into repository to guarantee safety of code artifacts and minimize code dependency impact to other team members
· Identifies cross-competency needs and assists with development of standard operating procedures within and across client teams
· Contributes to the project estimation process
· Multitasks through project execution and prioritizes accordingly, ensuring project deadlines are met and deliverables are completed in a timely fashion
· Assists with the transition from project completion to ongoing production and production support
· Communicates requirements and status with other teams and competencies, as required on an ongoing basis
PERFORMANCE EXPECTATIONS
1. Quality and overall impact of deliverables: Strives to achieve executional excellence. Ensures work is completed on time, within the allotted hours, and meets the business requirements. Creates documents in a professional manner. Fulfills all client and project leader needs and requests.
2. Team and/or client feedback and satisfaction: Develops strong working relationships with other engineers, QA team members, project leaders, and other teams. Team members provide praise for work done.
3. Commitment to vision and guiding principles of agency and competency: Number one focus is on client’s business. Respect for the individual is at the core of all team interactions. Focuses on solutions versus challenges.
4. Organizational and/or technical knowledge: Has appropriate knowledge of his/her core competency and integrated service offerings. Has working knowledge of other competencies. Understands the value of technology services and its impact on client business.
REQUIRED SKILLS
EXPERIENCE & EDUCATION
· 2+ years of Informatica experience
· 2 years of SQL/database experience, preferably Oracle
· Bachelor’s Degree in Computer Science, Engineering, MIS, or IIS is preferred
KNOWLEDGE & ABILITY
· Development Tools/Platforms
o Informatica
o SQL and PL/SQL
o UNIX/LINUX
o Shell scripting
o PERL (a plus)
o .NET (a plus)
· Database
o Oracle
o SQL Server 2005/2008
· Methodologies
o Dimensional data warehousing
