Infojini Inc · 9 hours ago
Informatica Developer
Dallas, TX
Contract
Onsite
Senior Level
6+ years expInfojini Inc is seeking a Senior Data Integration Engineer to design and develop Informatica IDMC mappings for data migration into a snowflake data lake. The role involves providing technical guidance, collaborating with stakeholders, optimizing data processes, and implementing CI/CD for data integration.
Information Technology
Hiring Manager
Shefali Sharma
Responsibilities
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
Provides technical guidance and mentorship to junior developers
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
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
Plans deployment by collaborating with the necessary teams to schedule the deployment process, considering factors such as system requirements, data volumes, and deployment schedules
Automates data pipelines using latest Informatica services like Mass Ingestion and utilizing cloud technologies like Azure Blob Storage and Snowflake
Embraces and adheres to Agile methodologies, by actively participating in meetings like sprint planning, stand-ups, grooming sessions, Kanban board updates, and retrospectives
Provides technical expertise and support throughout system development life cycle
Adheres to development standards and communicates effectively within team
Communicates directly with Informatica Global support and perform troubleshooting using PowerCenter or IDMC framework
Contributes innovative ideas and perspective to developed effective solution by understanding business processes and requirements
Creates and deploy a Continuous Integration/Continuous Delivery (CI/CD) process for the data integration platform
Qualification
Required
5+ years of experience in IDMC micro services 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
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 concepts
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 skill
Preferred
Informatica Foundation/Professional Level Certifications
Experience working on Jupyter Notebook, Github, Jenkins, Dataiku and Postman
Experience in programming languages such as Python, Java, or Scala
Company
Infojini Inc
Infojini Inc. delivers innovative IT Services and Solutions to empower startups, Fortune 500 companies, and global enterprises.
501-1000 employees
H1B Sponsorship
Infojini Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (6)
2024 (12)
2023 (11)
2022 (5)
2021 (10)
2020 (21)
Funding
Current Stage
Late StageRecent News
Baltimore Business Journal
2023-11-04
Company data provided by crunchbase