Home

ETL Informatica Developer::Boston, MA::3 Months C2H-USC or GC at Remote, Remote, USA
Email: [email protected]
From:

AMIT,

SUS

[email protected]

Reply to:   [email protected]

Position: ETL Informatica Developer

Location:
711 Atlantic Ave, Boston, MA 02111-4x per week

Duration: 3 Months C2H

Client: Plymouth Rock

Phone and skype

MUST HAVE

ETL/Informatica

IICS/IDMC

Redshift or Snowflake

DB2 and SQL server

Job Summary

The ETL/ELT developer will be responsible for designing, developing, testing and implementing modifications to our existing Data Warehouse and Data Mart ETL Loads and processing for the Data Services team.  This will include the ability to perform these duties in our current on premise environment; DB2 and AIX as well as to have the ability to modernize our development code for the future to migrate to AWS and Cloud tools and data structures (ie. Snowflake/RedShift). This team maintains all application code required to load & balance our data warehouse daily and serve as the source of truth for historical data for the enterprise.   

Activities will involve participating in Business Requirements review, assistance with system specifications, development of technical specifications, development of code changes in Informatica Power Center as well as Informatica Cloud, unit testing and implementation in production. The developer must follow the defined Informatica development standards and best practices and attend code reviews to assure compliance. 

Knowledge, Skills and Education Required

3-7  years ETL design, development - experience in Informatica preferred

Experience in Database development using DB2, SQL Server & Snowflake/RedShift

Exposure to Data Warehousing a plus

Experience using a software development life cycle (SDLC) methodology

Analytical, problem solving and testing skills.

Effective oral & written communication skills

Ability to multi-task

Attention to detail and quality

Must be a team player

Knowledge of Jira and AWS components & tools

Desire to Learn and Grow

Scripting Tools (ie.Python)

Experience is using APIs

Data Modeling Principles

Specific responsibilities include:

Ability to implement code changes based on system specifications

Analyze problems and propose solutions

Work with DBAs to implement database changes

Develop code changes using Informatica Power Center and Informatica Cloud

Perform in-depth unit testing prior to promoting to QA

Responsible for supporting and taking direction from manager

Look for opportunities to enhance existing code & processes

Participation in System and User acceptance testing

Ability to performance tune internal and user queries and etl loads.

Production implementation, including all required documentation.

Ability to provide effort and duration estimates

Other highly valued skills would include:

Knowledge of the Property and Casualty Insurance industry is a plus

Stored Procedures/Unix/Perl script knowledge is a plus

Knowledge of balancing and Control and the importance of implementing them.

Ability to  develop Metrics and Visualizations is a plus

Regards,

Amit Panthri

Technical Recruiter

E: [email protected]

Keywords: quality analyst Massachusetts
[email protected]
View all
Thu Jan 11 20:05:00 UTC 2024

To remove this job post send "job_kill 1005498" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.


Your reply to [email protected] -
To       

Subject   
Message -

Your email id:

Captcha Image:
Captcha Code:


Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]
Time Taken: 33

Location: Boston, Massachusetts