Previous Job
Sr. ETL Developer
Ref No.: 18-15843
Location: Miami, Florida
Required Skills :
Informatica Cloud

Basic Qualifications :
Must have experience with Informatica Cloud and migrations into Salesforce. Will be doing a migration from SQL Server into Saleforce.

Job Description :
Length of Assignment: 3 + (likely until December 2018)
Potential for Perm: no Salary: na
Position Title: ETL Developer
# of Positions: 1
Start Date: 5/21
Req Approved: yes
Work Location, is Remote Possible: Miami 33172
TR or Specialty on Qual: M. Miller
Submittal Requirements: (Social, DOB, dub on resume, etc)

Exclusive: N
Is HR also working on this:
What are our competitive advantages (Resume Review IV Times/1 + Done):
Interview times: 5/11 2 and 230pm
Interview Process: ph + skype
When is our follow up activity: IV’s on 5/11
1. Why is this position open? New opening – wants to promote current FTE
2. How long has the position been open? Few days
3. Have they interviewed anyone? Where did they miss? Yes, over rate – not willing to be on-site for release schedule.
4. Have we placed with this group before? Yes, in App Dev.
Project Details – Size, Scale, Scope? How does candidate fit into this?
Scope: Looking for a Sr. Lead to oversee 2 projects for CalAtlantic and Lennar. One project with be integrating from Oracle into Salesforce Cloud and the other from Microsoft Dynamics CRM into Salesforce Cloud. Will be overseeing a few on-site and an off-shore team of 5. – not direct report, more guiding them.
Day to Day Responsibilities/typical day look like:
Tech Stack:
-Need Experience with Informatica Power Center and latest version of Informatica Cloud (looks to be version 8)
-experience migrating/integrating into Salesforce (able to understand relationships and objects)
-5+ years of experience
-Lead experience
-Oracle (12c) or SQL Server (2014) experience
-strong understanding of views and data transformations
-change of primary keys in SQL Server
-basic understanding of modeling in data warehousing and data marts
-Salesforce Cloud Exp.
-Azure or AWS exp.
Hours of Operation:
-on call and need to be available to do releases at night time (they’ll coordinate work from home or other accommodations for those on call)
Selling Points for Candidates: Perks? What is exciting about position? Company?
1. Growth opportunity (merger)
What are the top 3 MUST HAVE technologies of the position?
1. Informatica Cloud
2. Migration INTO Salesforce
3. Must be in Miami for project – no remote
1. AWS/Azure
2. Salesforce Cloud
Insert Client Job Description:
Senior ETL Developer
Develop, design and implement data extraction and transformation solutions. Responsible for the design, implementation, management and operational support of data transformation and the related databases and other technologies. Responsible for the development and implementation of preventative maintenance routines to ensure availability and performance of data transformation jobs and their related management systems. Provide system performance tuning and capacity planning required to maintain the data extraction job success. Design procedural templates that enforce site standards.

Key Responsibilities:
Implementation of best practices and procedures pertaining to data integration design.
Creation and upkeep of data migration playbooks and runbooks.
Work closely with the business and IT teams in creating scalable data integrations processes.
Design, build, and maintain ETL and ELT pipelines and processes.
Identify and understand source data systems and become an expert of data sources and flows.
Explore and recommend technologies and techniques to improve performance and design of data pipelines.
Required Skills/Experience:
BS/BA in Computer Science, Information Systems, Engineering, or related field
MS/MA in Computer Science, Information Systems, Engineering, or related field a plus
5+ years of experience in relational database concepts with hands-on experience in MSSQL, or Oracle
5+ years of experience in database programming with T-SQL or PL-SQL
5+ years of experience with dimensional and star schema modeling techniques
5+ years of experience working with Informatica Power Center and Informatica Cloud
Extensive knowledge in the transformation of data via SQL transformations using views.
Experience with data migrations into Salesforce Cloud a plus
Experience with Microsoft AZURE and Amazon Web Services a plus
Required to be available onsite for all scheduled migration releases.