Day to Day Responsibilities/typical day look like:
Have incoming feeds from flat files and other DB's
They use informatica to get them to the staging area and data warehouse
Managing the Data Ware house and ETL processes
If there is any failover needs to be able to provide solutionsPLSQL - this will be the SQL tool on the back end
Unix - scripts are already built - minor tweaking
Using JAMS - any failure they get is on JAMS
Troubleshooting all of this will be priority
Roadmap - moving informatica to the cloud - cloud familiarity would be a plus
Informatica version 10+
Oracle Packages -dealing with these
Reporting needs, debug frontend and backend.
Analyst skills (ETL generalist (API integrations, xml, JSON, Informatica, or other tools), 1 year scripting exp. in bash, shell or python), Microstrategy or any visual tool for dashboard development
4-5 years of exp.
What are the top 3 MUST HAVE technologies or Required experience of the position?

1. Informatica 6+ years of experience (ETL)
2. Oracle packages
3. Batch scripting experience
4. SQL - needs to be able to dig into the data base, staging tables and understanding the flow of the DB

Nice to Haves:

1. Cloud Experience
2. Data Lake/Data Strategy Experience
3. Python
4. Exposure to API's - being able to make calls and get flat files set up to
5. JAMS or any scheduling
6. Power BI Background
7. Tableau
8. Admin background, understanding setups and securities, looking into the server being able to restart, need to add or change a rule

Job Description Below:
-Extensive experience in extract, transform and load using Informatica V. 10+
-Demonstrated ability to track issues back to the source and dig into data to identify, document, and resolve root causes for issues
-Hands on experience with Informatica, including demonstrated extensive experience with parallel job design and development and strong SQL coding skills
-A strong familiarity with general DBMS concepts (Oracle experience preferred) SQL and PL/SQL
-Deep knowledge of best practices through relevant experience across data-related disciplines and technologies particularly for enterprise wide data architectures and data warehousing/BI
-Ability to prepare design documentation to express necessary details for review and ongoing maintenance
-Able to troubleshooting any failures, looking through the Scheduling tool and provide resolution.
Required Skills : Informatica (If have other ETL tools, that would be a plus) Any dashboard/visualization exp. (Microstrategy preferred but will consider Power BI or Tableau) SQL
Background Check :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :Yes
Exclusive to Apex :Yes
Face to face interview required :Yes
Candidate must be local :No
Candidate must be authorized to work without sponsorship ::No
Interview times set :Yes
Type of project :Development/Engineering
Master Job Title :Dev: MicroStrategy
Branch Code :Orlando