Send your resumes at adi...@unicomtec.com

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
stores
§ Performance-tunes ETL packages and target data stores based on expected
use
§ 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
structure
* 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



*Regards*

*Aditya*

*Unicom Technologies Inc.,*

*Phone:  309-740-1565*

*Fax: 1-866-291-2541*

*Mail: adi...@unicomtec.com <adi...@unicomtec.com>*

*Web: www.unicomtec.com <http://www.unicomtec.com>*
  

-- 
You received this message because you are subscribed to the Google Groups 
"REQSRESUMES" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to reqsresumes+unsubscr...@googlegroups.com.
To post to this group, send email to reqsresumes@googlegroups.com.
Visit this group at http://groups.google.com/group/reqsresumes.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to