Job Description :
DirectClient: Texas Department of Comptroller of Public Accounts(CPA)
Solicitation#304125529
Title: DataStage Architect
Location: Austin, Texas 78774
Duration: 12+ Months Contract
Last date for submission: July 19, 2017(2.00 PM-CST)
Job Description:
As a Sr. ETL Architect, the Worker must be innovative and creative in solving complex solutions. The Worker must have a strong background in developing comprehensive automated processes to extract data from disparate source systems, transform data as per business requirements, and load data into a data warehouse and various presentation models.
As a Sr. ETL architect, the Worker will be responsible for:
analyzing evolving sources of data, determining and implementing extraction methodologies
loading operational data models and data marts and re-architecting and standardizing existing ETL processes
working with users and business analyst to ensure that the correct data is being sourced into the Enterprise Data Warehouse and the sourced data is in conformance with data governance guidelines
developing processes and procedures in support of a large enterprise BI/DW environment
working with Business Customers, Section Managers, Project Managers, Business Analysts and Subject Matter Experts (SMEs) in a professional and collaborative manner to define strategies and implementation approaches
following software development processes, preparing detailed documentation and generating work estimates in an SDLC environment.
As a Sr. ETL Architect, the Worker must be quality conscious and be dedicated to delivering quality products on time and on budget.
Onsite Requirements: Worker will be required to work on site with the team. Working remotely will be limited and must be pre-approved by the Project Manager and Direct Supervisor.
WORKER SKILLS AND QUALIFICATIONS
Must possess strong written, verbal, and interpersonal communication skills.
Must be able to work independently in a team environment with local and remote teams
Must possess knowledge of project management methodologies both traditional and Agile/Scrum
Must possess problem-solving skills and ability to multi-task with readiness to put in extra efforts when necessary
Must perform related work as assigned
II. WORKER SKILLS AND QUALIFICATIONS
Minimum Requirements:
Years Skills/Experience
7 Extensive experience in architecting ETL Solutions, automation, and best practices
7 Expertise in source data analysis, defining data granularity, data element mapping, and data warehouse design.
7 Hands-on experience with data conversion, performance tuning, and managing conceptual and physical data models.
7 Extensive knowledge of/experience with data integration, data quality, multi-dimensional design and ETL tools, processes and methodology
6 Experience with IBM Infosphere DataStage v8.x and above
6 Experience with IBM Infosphere Warehouse
6 Extensive experience with languages SQL and PL/SQL
6 Experience working with data bases DB2 LUW & zOS, Oracle 12c, MS SQL Server, Teradata
6 Knowledge and experience with both DW and BI security architecture, especially involving disparate platforms preferably Enterprise Resource Planning (ERP) software and Active Directory (AD)
4 Experience working with metadata driven auto generated code performing full ETL life cycle
4 Experience with implementing security and privacy requirements in a large enterprise environment
4 Experience preparing all required artifacts accurately and in a timely fashion for the project
3 Experience with UNIX scripting
2 Experience with p file management process
1 Knowledge of project management methodologies both traditional and Agile/Scrum
Preferences:
Years Skills/Experience
3 Proficient with the Microsoft Windows and Office products
3 Public sector experience (Federal, State or Local Government)
2 Experience working with CPA IT and business customers