Send your resumes at [email protected] 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: [email protected] <[email protected]>* *Web: www.unicomtec.com <http://www.unicomtec.com>* -- You received this message because you are subscribed to the Google Groups "SAP Workflow" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/sap-workflow. For more options, visit https://groups.google.com/groups/opt_out.
