Job Description :
We are seeking a Sr. ETL Developer with proven data warehouse experience to for a one-year assignment with our Austin, Texas client.
Responsibilities for this role include:
- Design, develop, and test ETL processes for the data warehouse.
- Develop and document ETL processes to extract data from existing systems into the data warehouse.
- Document the as-is schemas currently in use.
- Perform other analysis and documentation tasks as required to facilitate and support client''s Enterprise Data Warehouse Project.
Requirements:
Yrs Skills/Experience
7 Design and develop Extraction, Transformation, Load (ETL) processes for enterprise data warehouse using Informatica; Deep hands-on expertise with Informatica ETL processes, development, data management, data profiling, data flows, data relationships, and data quality standards and processes.
7 Hands-on experience with data warehouse development (relational and dimensional) and proven evidence to implement using databases like Oracle, SQL Server etc. but preferably Oracle
6 Hands on experience with data modeling preferably in a data warehouse environment.
3 Experience with Informatica product suite in the Informatica cloud.
Strong` Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.
Strong Communication, analytical and interpersonal skills at all levels.
Strong Strong technical writing skills.
Preferences:
Yrs Skills/Experience
6 ERWin or other equivalent data modeling tools
6 More than one type of RDBMS (DB2, SQL Server, Oracle)
4 Experience in Public Sector delivery