Job Url: https://www.linkedin.com/jobs/search/?currentJobId=4325584378&f_AL=true&f_TPR=r86400&f_WT=2&keywords=machine%20learning%20engineer&origin=JOB_SEARCH_PAGE_JOB_FILTER&spellCorrectionEnabled=true&start=100 Job Description: EDW ETL/Informatica Developer - W2 United States · 2 hours ago · 42 applicants Promoted by hirer · Company review time is typically 1 week $50/hr Remote Matches your job preferences, workplace type is Remote. Contract Easy Apply Save Save EDW ETL/Informatica Developer - W2 at MSR Technology Group EDW ETL/Informatica Developer - W2 MSR Technology Group · United States (Remote) Easy Apply Save Save EDW ETL/Informatica Developer - W2 at MSR Technology Group Show more options Get personalized tips to stand out to hirers Practice mock interviews personalized to every role and get custom feedback Try Premium for PKR0 Meet the hiring team Rama Kishore Reddy 3rd Hiring H1 Transfer / OPT / CPT / H4 EAD on W2 / Contract / Full Time Job poster Message About the job We are looking for someone who can work on W2. EDW ETL/Informatica Developer Remote 7 Months+ $50/Hr on W2/ 1099 Location: Telecommute with occasional (2 -3 per year) travel to Springfield, Illinois. Primary Responsibilities: • Use Informatica PowerCenter to Extract, Transform, and Load (ETL) source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files, and adding new fields via the change request process • Automate the staging of data by scheduling scripts to run at optimal times, enhancing overall system performance and efficiency • Create, maintain, and support an ETL/Informatica architectural and system environment for development and production • Perform domain/repository backups and recovery operations • Implementing ETL jobs by creating mappings, mapplets, sessions, and workflows • Working with different ETL transformations, including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter • Scheduling and monitoring ETL/Informatica jobs in development, system testing, and production environment • Developing proactive processes for monitoring capacity and performance tuning • Supporting and advising the development teams on technical issues • Troubleshoot production support issues post-release deployment and comes up with solutions • Developing and maintaining complex SQL queries and scripts used to create data marts in Teradata • Participating in project discussions to document and recommend alternative technical solutions or requirements • Participating in unit, integration, and system testing • Maintaining effective communication and relationships with all individuals involved with the project • Learning new technologies as needed to be able to perform job duties effectively • Providing status progress and meeting deliverables to Optum’s leadership and Optum’s customer Required Qualifications: • 7+ years of Informatica PowerCenter / ETL Experience • 5+ years of complex SQL and Performance Tuning Experience • 5+ years of Teradata Version 15+ experience, including Teradata Utilities (Fastload, TPT, Multiload) • 5+ years of ETL / Informatica PowerCenter administrative experience • Excellent verbal/written communication skills, end-client facing, team collaboration, and mentoring skills • Experience with Unix Shell scripting • Strong organizational skills and ability to set priorities and schedule work deadlines. Bachelors or Advanced Degree in a related field such as Information Technology/Computer Science, Mathematics/Statistics, Analytics, Business Technology • Adapting to the team and organizational culture