Sr. ETL Developer

logo

Sr. ETL Developer

Cloud Big Data Technologies

icon West Bend, WI, US, 53095

icon20 May 2024

Apply Now

Role : Sr. ETL Developer

Location : West Bend,WI

Duration : 3+ Months

Rate : $50/hr on C2C(Max)

Required Skills: SQL, ETL, Informatica, PowerExchange, XML, Security Experience - Sensitive Data,

Ideal candidates will have experience with:

  • 7+ years of ETL development experience, with 5+ years of Sr. ETL Developer experience
  • Informatica PowerCenter 8.x and PowerExchange 8.x
  • Knowledge of SQL queries to analyze data
  • Strong analytical skill
  • Knowledge of XML
  • General insurance knowledge a plus
  • Security experience – Sensitive data

Specific need:

  • Will be working on the Security Program for the confident data protection effort
  • Will be working on removal of sensitive data as needed per security program initiatives/requirements

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

Equal Opportunity Employer

Cloud Big Data Technologies is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. Cloud Big Data Technologies will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will Cloud Big Data Technologies require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract
Apply Now
Apply Now