Similar Jobs
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The role involves supporting federal customers by configuring and optimizing ServiceNow IT Asset Management, leading design workshops, advising on development, creating deliverables, and mentoring field resources while ensuring customer success in IT processes.
Top Skills:
AdobeBmcFlexeraIbmIt Asset ManagementMicrosoftOracleSccmServicenowSnow Software
.png)
Digital Media • eCommerce • Information Technology • Marketing Tech • Retail • Social Media • Analytics
The Field Manager will ensure execution of corporate plans for profitable sales, support store openings, manage relationships, and monitor market trends while managing budgets.
Top Skills:
ExcelPowerPoint
Cloud • Computer Vision • Information Technology • Sales • Security • Cybersecurity
This role involves selling enterprise security software solutions to new customers, managing relationships, and collaborating with internal teams to drive revenue and success.
Top Skills:
Crm SoftwareCybersecurity Software SolutionsMarketing Software
Location: Telecommute with occasional (2-3/ year) travel to Springfield, IL
The ETL Developer is responsible for loading and extracting data into and out of the Teradata database. The ETL developer must learn and understand the technical structure of the data and the business use of the data. Knowing what the data is supposed to do and how end-users will use the data supports accurate loading, staging, transformation, and testing/troubleshooting of data. Our team is responsible for a wide range of data to support business needs. Our developers must work with their Lead to determine the steps (or plan) needed to implement the solution. Our projects range from small (8 – 10 hours), medium (300-1000 hours), or large (more than 1000 hours). The developer will work with the customer to define the requirements, create the technical design, code the solution, and implement the code into development, UAT, and production.
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.
Preferred Qualifications:
- Located in Springfield, IL area is preferred
- 5+ years of Data Warehouse experience
- 5+ years logical and physical data modeling experience using ERWIN or other data modeling tool
- 2+ years of Azure Data Factory and Snowflake DB development
- Experience in Windows, Unix/Linux scripting, R, React, or Python
- Experience in Informatica Data Quality (IDQ), Address Doctor, Metadata Manager
- Experience with State Medicaid / Medicare / Healthcare applications
- Experience working in Agile
- Experience with Data Warehouse technologies within the domain of ETL/data integration, Business Intelligence, relational and multi-dimensional database systems
- Experience with Korn and Bash Shell scripting.
- 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
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
