Urgent need of Sr. Informatica ETL Developer || 4 days onsite in Boston, MA at Boston, Massachusetts, USA |
Email: [email protected] |
From: Pradip Ojha, Sourceinfotech Inc [email protected] Reply to: [email protected] Position: Sr. Informatica ETL Developer 3 month Contract to perm must be willing to convert after 3 months 4 days onsite in Boston, MA No H1B/CPT/OPT Phone/Skype Rate: $65/hr. C2c 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 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 Thanks & Regards Pradeep Source Infotech Inc P.O Box 577, EDISON, NJ 08818-0577 EMAIL: [email protected] Phone: 609-956-0017 | Fax: 732-909-2282 | Hangout: Pradipk906 || Jai Mata Di || Keywords: quality analyst Massachusetts New Jersey |
[email protected] View all |
Thu Dec 21 01:30:00 UTC 2023 |