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 "SAP or Oracle Financials" group. To unsubscribe from this group and stop receiving emails from it, send an email to sap-or-oracle-financials+unsubscr...@googlegroups.com. To post to this group, send email to sap-or-oracle-financials@googlegroups.com. Visit this group at http://groups.google.com/group/sap-or-oracle-financials. For more options, visit https://groups.google.com/groups/opt_out.
