Informatica ETL Developer

3 weeks ago

Boston, United States Saxon Global Full time

Client: Plymouth Rock Assurance

Position: Informatica ETL Developer

Location: 4 days onsite in Boston, MA

Duration: 6 Months

Rate:$75/hr. on C2C

Visa: USC,GC and H4EAD

Candidate must Have:

  • IICS or IDMC (Informatica Intelligent Cloud Services OR Informatica Data Management Cloud)
  • AWS is a big plus
  • Must have Redshift or Snowflake
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 API's
  • Data Modeling Principles

Duties and Responsibilities

Specific responsibilities include:
  • Ability to implement code changes based on system specifications
  • Analyze problems and propose solutions
  • Work with DBA's 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

  • ETL Developer

    3 weeks ago

    Boston, United States Saxon Global Full time

    Must work onsite from day 1 - 3 days per week onsite/2 remote No H1B Must Haves: Experience- 5+ years using informatica PowerCenter and Oracle database development. Experience with relational databases, preferably Oracle Title: ETL Developer Company: Boston University Location: Boston, MA (Hybrid), 2 days remote and 3 days onsite Start: ASAP Duration: 6...

  • Senior ETL Developer

    2 weeks ago

    Boston, United States Federal Home Loan Bank of Boston Full time

    The Federal Home Loan Bank of Boston is a leading provider of wholesale funding for housing and community finance in New England serving more than 420 financial institutions across the region. The Federal Home Loan Bank of Boston is committed to making New England a better place to live and do business, and our employees are integral to our success. As a...

  • Senior ETL Developer

    2 weeks ago

    Boston, United States Federal Home Loan Bank of Boston Full time

    The Federal Home Loan Bank of Boston is a leading provider of wholesale funding for housing and community finance in New England serving more than 420 financial institutions across the region. The Federal Home Loan Bank of Boston is committed to making New England a better place to live and do business, and our employees are integral to our success. As a...

  • Senior ETL Developer

    3 weeks ago

    Boston, United States Federal Home Loan Bank of Boston Full time

    The Federal Home Loan Bank of Boston is a leading provider of wholesale funding for housing and community finance in New England serving more than 420 financial institutions across the region. The Federal Home Loan Bank of Boston is committed to making New England a better place to live and do business, and our employees are integral to our success. As a...

  • Senior ETL Developer

    2 weeks ago

    Boston, United States Federal Home Loan Bank of Boston Full time

    The Federal Home Loan Bank of Boston is a leading provider of wholesale funding for housing and community finance in New England serving more than 420 financial institutions across the region. The Federal Home Loan Bank of Boston is committed to making New England a better place to live and do business, and our employees are integral to our success. As a...

  • Senior ETL Developer

    3 weeks ago

    Boston, United States Federal Home Loan Bank of Boston Full time

    The Federal Home Loan Bank of Boston is a leading provider of wholesale funding for housing and community finance in New England serving more than 420 financial institutions across the region. The Federal Home Loan Bank of Boston is committed to making New England a better place to live and do business, and our employees are integral to our success. As a...

  • Senior ETL Developer

    4 weeks ago

    Boston, Massachusetts, United States Federal Home Loan Bank of Boston Full time

    The Federal Home Loan Bank of Boston is a leading provider of wholesale funding for housing and community finance in New England serving more than 420 financial institutions across the region. The Federal Home Loan Bank of Boston is committed to making New England a better place to live and do business, and our employees are integral to our success. As a...

  • Informatica Cloud Developer

    3 weeks ago

    Boston, United States Venusgeo Solutions Full time

    Direct Client - Onsite - Job opportunity for Informatica Cloud Developer - IICS - Onsite Role at Boston, MA ( At this point of time we are not sponsoring any VISA, we are looking for independent consultants Only ) Job Title: Informatica Cloud Developer - IICS ( Need Strong IICS Development exp with Advanced SQL expertise )Duration: Long term contract Job...

  • Informatica Cloud Developer

    3 weeks ago

    Boston, United States Venusgeo Solutions Full time

    Direct Client - Onsite - Job opportunity for Informatica Cloud Developer - IICS - Onsite Role at Boston, MA ( At this point of time we are not sponsoring any VISA, we are looking for independent consultants Only ) Job Title: Informatica Cloud Developer - IICS ( Need Strong IICS Development exp with Advanced SQL expertise )Duration: Long term contract Job...

  • IICS Developer

    2 weeks ago

    Boston, United States Venusgeo Full time

    Role: IICS Developer ( Informatica Cloud Developer)Must be local OR willing to relocate day 1 to work onsite. Create/Enhance ETL jobs as needed to load external feeds into warehouse tables/data mart tables.Work with an agile team to deliver and evolve the data platform servicesProvide technical support to User Acceptance and Integration testing environments...

  • Informatica Intelligent Cloud Service Developer

    1 month ago

    Boston, United States GOAHEAD SOLUTIONS LLC Full time

    GoAhead Solutions has an immediate need for an IICS(Informatica Intelligent Cloud Services) Developer in Boston, MA. This would be a Twelve month contract to start out with extension. This is a hybrid position and will require to work onsite a couple of days a week. Major Responsibilities: - Must have Kafka experience. - Create/Enhance ETL jobs as needed...

  • Senior ETL Developer

    3 weeks ago

    Boston, United States Insight Global Full time

    An employer is looking for a Senior ETL Developer to join their team in the Seaport of Boston, MA. He/she will join the Data Warehouse team of a travel company. He/she will be a key contributor to the implementation of Snowflake as the organization migrates from Oracle to the cloud. This person will collaborate across teams to design, develop, and optimize...

  • IICS Developer –( Informatica Cloud Developer)

    2 weeks ago

    Boston, United States Venusgeo Solutions Full time

    Role: IICS Developer –( Informatica Cloud Developer ) Must be local OR willing to relocate day 1 to work onsite. Prefer resources closer to Boston, MA. Effective feb 1st week one day onsite will be required. ** Must have Kafka ( Kafka is required, Just knowledge is fine ),AWS Redshift,S3 W2 Create/Enhance ETL...

  • ETl Developer/(IICS) ONLY W2

    2 weeks ago

    Boston, United States Anveta Inc Full time

    Job Description. ETL jobs as needed to load external feeds into warehouse tables/data mart tables. Work with an agile team to deliver and evolve the data platform services Provide technical support to User Acceptance and Integration testing environments by researching suspected anomalies and periodically refreshing the environments. Performance tuning ETL...

  • IICS Developer

    2 weeks ago

    Boston, United States Saxon Global Full time

    Position: ETL/Informatica Developer with IICSLocation: Boston, MA (Hybrid -3 days a week onsite)Duration: 12-18 MonthsMajor Responsibilities:Create/Enhance ETL jobs as needed to load external feeds into warehouse tables/data mart tables.Work with an agile team to deliver and evolve the data platform servicesProvide technical support to User Acceptance and...

  • IICS Developer

    2 weeks ago

    Boston, United States Saxon Global Full time

    Position: ETL/Informatica Developer with IICSLocation: Boston, MA (Hybrid -3 days a week onsite)Duration: 12-18 MonthsMajor Responsibilities:Create/Enhance ETL jobs as needed to load external feeds into warehouse tables/data mart tables.Work with an agile team to deliver and evolve the data platform servicesProvide technical support to User Acceptance and...

  • IICS Developer

    2 weeks ago

    Boston, United States Saxon Global Full time

    Position: ETL/Informatica Developer with IICSLocation: Boston, MA (Hybrid -3 days a week onsite)Duration: 12-18 MonthsMajor Responsibilities:Create/Enhance ETL jobs as needed to load external feeds into warehouse tables/data mart tables.Work with an agile team to deliver and evolve the data platform servicesProvide technical support to User Acceptance and...

  • IICS Developer

    2 weeks ago

    Boston, United States GoAhead Solutions Full time

    GoAhead Solutions has an immediate need for an IICS(Informatica Intelligent Cloud Services) Developer in Boston, MA. This would be a Twelve month contract to start out with extension. This is a hybrid position and will require to work onsite a couple of days a week.Major Responsibilities:-Must have Kafka experience.-Create/Enhance ETL jobs as needed to load...

  • ETL Developer

    5 days ago

    Boston, United States Center for Health Information and Analysis Full time

    Are you a skilled Software Development professional with a proven track record for designing and developing ETL code? Look no further – you could be the ideal candidate for us! At the Center for Health Information and Analysis (CHIA), we provide the factual foundation for data-driven health care interventions. CHIA is an independent state agency whose work...

  • Senior Software Engineer/Developer

    4 days ago

    Boston, United States Soteriare Full time

    Senior Software Engineer/Developer page is loaded Senior Software Engineer/Developer Apply locations Boston, MA time type Full time posted on Posted 5 Days Ago job requisition id 2094943 Job Description: Position Description : ***Applicants are permitted to work remotely from an at-home work site anywhere in the United States*** Develops, supports, and...