Description
General
Ensures adherence to locally defined standards for all developed components
Participates in the phase of Functional design
Participates in or reviews the client Software Architecture Document (SAD) for feasibility.
Contributes to technical detailed design specifications
Contributes to development project estimates, scheduling and development reviews
Approves code reviews and technical deliverables
Develops and reviews Operations plans
Develops Informatica mapping
Develops Data Integration mappings, Workflows and load processes
Performs data analysis for both Source and Target tables/columns
Provides technical documentation of Source and Target mappings (S2T)
Supports the development and design of the internal data integration framework
Works with System owners to resolve source data issues and refine transformation rules Ensures performance metrics are met and tracked
Writes and maintains unit tests
Contributes to system tests for defect analysis and resolution
Execute and control change and release management in the ETL Informatica environments using Dimensions.
Technical Skills
PowerCenter 9.0.1
Required
Strong experience in Informatica ETL including complex mappings, transformations and workflows.
Experience developing WebServices
Experience working with XML and Cobol/Mainframe file structures
Data Explorer & Analyst Tool
Nice to have
Experience performing data profiling and proactively identifying data quality issues
PowerExchange
Experience working with Cobol/Mainframe file structures using Power Exchange will be a plus (data map).
Databases
Required
Relational database with strong SQL skills -preferably with Oracle or/and SQL Server
Other
Demonstrate excellent problem solving and critical thinking skills
Ability to work independently and as part of a large diverse work team
Knowledge of project management processes
Allegis Group Limited and Aston Carter Limited operate Employment Businesses and Agencies and are companies within the Allegis Group Inc. group of companies, the fourth largest staffing company in the world, (collectively referred to as the "Allegis Group"). TEKsystems and Aerotek are divisions of Allegis Group Limited. Applicant data will be treated in accordance with the Allegis Group's Privacy Notice.