Send your resumes at

ETL Informatica

Milwaukee, WI.

6 month

Enterprise Data Warehouse - SQL, DB2

  *Role Description*
§ The ETL Developer creates detailed specifications for ETL design /
development / support, and then transforms those designs into system
capabilities utilizing standard coding tools and processes.
§ The ETL Developer will function as part of a broader team that is
responsible for developing the EDW solution, including Data Modelers and
Data Analysts.
§ The ETL Developer ensures that development solutions meet defined
technical, functional, and service level requirements and standards.
§ The ETL Developer oversees consistent quality in handoffs between
development to deployment and operations while incorporating continuous
process improvement and feedback.
§ The ETL Developer recognizes and identifies potential areas where
existing development policies and procedures require change, or where new
ones need to be developed.

* Responsibilities *
§ Generates SQL DDLs and physical tables for the purpose of loading target
data stores.
§ Develops ETL packages to extract, transform and load source to target
§ Performance-tunes ETL packages and target data stores based on expected
§ Execute unit tests to ensure that the software compiles and runs
§ Reuses existing software components to meet requirements
§ Builds software components (including prototype code, new code,
interfaces, etc.) in accordance with the relevant requirements, system and
software architectures, design, and coding standards
§ Write and performs unit testing of software components and integration
programs, including the design, implementation, evaluation, and execution
of unit tests
§ Identifies and fixes coding defects
§ Understand and evaluate the relevant requirements, architecture, and
design documentation
§ Analyze design specifications, development, and technical and user
documentation and requirements surrounding the EDW technology components
§ Identify any potential issues and risk associated with specific
development activities
§ Establish and maintain Software and Document CM policies, procedures and
best practices

*Required Skills & Qualifications *
* Bachelor's degree in Computer Science/Technology related field
* At least 5+ years experience total
* Five years experience as an ETL Developer using Informatica PowerCenter
8.x and PowerExchange 8.x
* Experience leading and developing medium to large scale Operational and
Decision Support based Data Integration projects including Real-Time and
Webservice based initiatives
* Expert knowledge of SQL with relational databases (SQL Server, DB2)
* Knowledge of Mainframe concepts including TSO, VSAM, COBOL and JCL
* Experience with relational and dimensional data modeling
* Knowledge of various Data Warehouse Architectures
* Experience building and operating a data warehouse
* Master Data Management experience
* Metadata Management experience
* Knowledge of Data Profiling and Data Quality concepts and techniques
* Experience with Business Objects
* P&C Insurance business domain experience
* Strong attention to detail
* Strong understanding of data analysis, development skills, and database
* Experience with developing commercial applications, with high standards
of usability and performance
* Experience with writing technical documentation
* Experience in gathering and analyzing requirements
* Strong analytical skills
* Excellent written, verbal, and interpersonal skills



*Unicom Technologies Inc.,*

*Phone:  309-740-1565*

*Fax: 1-866-291-2541*

*Mail: <>*

*Web: <>*

You received this message because you are subscribed to the Google Groups 
To unsubscribe from this group and stop receiving emails from it, send an email 
To post to this group, send email to
Visit this group at
For more options, visit

Reply via email to