Position: ETL Developer

Location: West Bend, WI

Duration: 6+ months

Interview Process: Phone & Skype

 Description :

 *ETL Developer*

* **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 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 *InformaticaPowerCenter
   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

*Thanks & Regards*

*Rathna Kumar  | Senior-IT Recruiter |*

*Email: **rath...@usmsystems.com** , Phone:** **703-349-2660** *

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 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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to