| Looking for, Sr. ETL Informatica Developer || Boston, MA || Locals only at Boston, Massachusetts, USA |
| Email: [email protected] |
| From: Mayank, Pivotal Technologies [email protected] Reply to: [email protected] "No Relocation || Need local with DL" Title: Sr. ETL Informatica Developer Location: 711 Atlantic Ave, Boston, MA 02111 Location Details: directly across from South Station. MUST BE ONSITE 4 DAYS A WEEK. Can choose their remote day and it can vary per week. Candidates must be vaccinated. Visa: USC, GC or GC-EAD only must have 10+ years of experience Relocate from day 1 be onsite 4x per week from day 1 max 2-3 weeks notice period Duration: 3 month contract to hire MUST HAVE ETL/Informatica IICS/IDMC Redshift or Snowflake DB2 and SQL server 10/10 comm skills 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 Duties and Responsibilities 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 Thanks & Regards, Mayank Mer Technical Recruiter https://www.linkedin.com/in/mayank-mer-405972114/ Keywords: quality analyst information technology green card Massachusetts |
| [email protected] View all |
| Thu Jan 11 20:41:00 UTC 2024 |