Overview
On Site
Depends on Experience
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Skills
Data Warehouse
PL / SQL
PowerCenter
ETL
Software Development Life Cycle
Job Details
Title: Sr ETL Developer Architect
Location: Dallas ,TX
Duration: 12 Months Plus
Duties and Requirements :
1. Designs and Develop Informatica IDMC mappings and mapping tasks to migrate data from Oracle/SQL Server into a snowflake data lake and support a variety of structured, semi-structured, and unstructured data sources.
2. Provides technical guidance and mentorship to junior developers.
3. Collaborates with various stakeholders across different departments and levels within the airport and identify functional areas where organization's data can be optimized to develop and implement effective business solutions.
4. Recognizes and improves the efficiency and effectiveness of pre-existing Informatica jobs. It involves the identification of areas where these jobs can be enhanced or optimized to achieve better performance thereby contributing to overall system efficiency and effectiveness.
5. Plans deployment by collaborating with the necessary teams to schedule the deployment process, considering factors such as system requirements, data volumes, and deployment schedules.
6. Automates data pipelines using latest Informatica services like Mass Ingestion and utilizing cloud technologies like Azure Blob Storage and Snowflake
7. Embraces and adheres to Agile methodologies, by actively participating in meetings like sprint planning, stand-ups, grooming sessions, Kanban board updates, and retrospectives.
8. Provides technical expertise and support throughout system development life cycle.
9. Adheres to development standards and communicates effectively within team.
10. Communicates directly with Informatica Global support and perform troubleshooting using PowerCenter or IDMC framework.
11. Contributes innovative ideas and perspective to developed effective solution by understanding business processes and requirements.
12. Creates and deploy a Continuous Integration/Continuous Delivery (CI/CD) process for the data integration platform.
MINIMUM REQUIREMENTS: :
- Bachelor s degree in business, information technology, computer science or a related field
- 6+ years of experience with Informatica IDMC/PowerCenter platform
- 3+ years knowledge of Data Warehouse and BI architecture and concept
- 5+ years of experience with RDMS systems such as Oracle, SQL Server etc.
- 5+ years of strong knowledge of database scripting Snowflake, Oracle, Sql Server
- Experience with working in a Linux environment and Shell Scripting
- Experience with high volume, critical applications development, and support
- Excellent communication and collaboration skills
REQUIRED KNOWLEDGE, SKILLS AND ABILITIES: :
- 5+ years of experience in IDMC microservices such as Data Integration, Mass Ingestion, Monitor, Operational Insights
- 5+ years of thorough knowledge of SDLC (Software Development Life Cycle) and experience with working in Agile and Waterfall methodologies.
- 5+ years of experience in writing and tuning SQL and PL/SQL language, demonstrated technical innovation, strong understanding of databases, and detailed knowledge of and experience with technical modeling.
- 5+ years of experience working with Dimensional model and understand data warehousing concepts and SCD logic.
- Excellent oral and written communication skills; ability to present and explain technical information in a way that establishes rapport and gains understanding.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.