Informatica ETL Developer
at a global provider of Business Process Management company
Informatica ETL Developer
Job Description
Having experience in Informatica & SQL, Data Migration, Data Load & Management
Having hands on experience on SQL queries.
Having good knowledge and working experience in Informatica ETL tool right from developing ETL to scheduling/ Monitoring it.
Having experience in writing/ debugging complex SQL queries/ stored procedures.
Ability to build, test, and maintain ETL
Knowledge and Experience in GIT version control application.
Good to have knowledge on PostgreSQL and Amazon S3.
Create, modify, document, and enhance data specifications including identifying and mapping data elements from source systems into the dimensional data warehouse and operational system; Validate that the operational system and data warehouse meets specified requirements.
Analyze and QA data from different sources and ensure that it is properly loaded into our systems
Investigate data quality issues and implement appropriate solutions
Ability to manage tasks and coordinates with other team members and supervisor to meet such timelines and actively contributes to project status reporting processes to identify and mitigate risks.
Requirement gathering – frequent interaction with the Data & Technical Managers, Database administrators, Application Users – all belonging to different departments and divisions of to ensure smooth implementation and running of the application
Knowledge of health system functions, terminology and standard coding systems preferred.
Qualifications
Bachelor's degree in computer science engineering, mathematics, statistics, science, information technology, Business Administration required Or Master Degree in computer science, computer application or Business Administration preferred
Min 3 years of extensive experience in Informatica ETL design & development, Data Migration, Data Load & Management, SQL Queries, T-SQL programming & testing
Additional information
Good written and verbal communication skills
Good client interaction experience
Good team player
Total Exp – 5 years out of which min 3 years should be relevant.
Shubham Vishwakarma
Full Stack Developer - Averlon
Similar jobs
React.js
Javascript
Redux/FluxHeadless Development: Lead the frontend development of our Shopify app, including
building new features, revamping existing functionalities, and optimising performance.
User Interface Design: Collaborate with the design team to implement responsive,
pixel-perfect UI components that align with our brand’s aesthetic and provide an intuitive
user experience.
Custom Theme Development: Create and customise Shopify themes to enhance the
visual appeal and functionality of our online store, ensuring compatibility with various
devices and browsers.
Integration and API Management: Work with third-party APIs and Shopify's API to integrate
necessary functionalities, such as payment gateways, shipping solutions, and marketing
tools.
Performance Optimization: Continuously monitor and improve the app’s performance,
ensuring fast load times, seamless navigation, and a smooth user experience.
Collaboration: Work closely with cross-functional teams, including backend developers,
designers, marketers, and product managers, to deliver high-quality solutions on time.
Code Review and Best Practices: Maintain clean, modular, and reusable code. Participate
in code reviews and ensure adherence to best practices in frontend development.
Troubleshooting and Debugging: Identify and resolve issues, bugs, and performance
bottlenecks in a timely manner to ensure a seamless user experience.
Documentation: Create and maintain comprehensive documentation for code, processes,
and development workflows.
Python
FlaskResponsibilities
· Develop Python-based APIs using FastAPI and Flask frameworks.
· Develop Python-based Automation scripts and Libraries.
· Develop Front End Components using VueJS and ReactJS.
· Writing and modifying Docker files for the Back-End and Front-End Components.
· Integrate CI/CD pipelines for Automation and Code quality checks.
· Writing complex ORM mappings using SQLAlchemy.
Required Skills:
· Strong experience in Python development in a full stack environment is a requirement, including NodeJS, VueJS/Vuex, Flask, etc.
· Experience with SQLAchemy or similar ORM frameworks.
· Experience working with Geolocation APIs (e.g., Google Maps, Mapbox).
· Experience using Elasticsearch and Airflow is a plus.
· Strong knowledge of SQL, comfortable working with MySQL and/or PostgreSQL databases.
· Understand concepts of Data Modeling.
· Experience with REST.
· Experience with Git, GitFlow, and code review process.
· Good understanding of basic UI and UX principles.
· Project excellent problem-solving and communication skills.
Qualification : D.C.P. / D.N.B. (Pathology) / M.D. (Pathology)
Location : Bhuj- Gandhidham
Laravel
CodeIgniter
PHP
Discussing project aims with the client and development team.
Designing and building web applications using Laravel.
Troubleshooting issues in the implementation and debug builds.
Working with front-end and back-end developers on projects.
Testing functionality for users and the backend.
Ensuring that integrations run smoothly.
Scaling projects based on client feedback.
Recording and reporting on work done in Laravel.
Maintaining web-based applications.
Presenting work in meetings with clients and management.
Previous working experience as a PHP / Laravel developer for (x) year(s)
BS/MS degree in Computer Science, Engineering, MIS or similar relevant field
In depth knowledge of object-oriented PHP and Laravel 5 PHP Framework
Hands on experience with SQL schema design, SOLID principles, REST API design
Software testing (PHPUnit, PHPSpec, Behat)
MySQL profiling and query optimization
Creative and efficient problem solver
PHP with any MVC framework (laravel, codeigniter)
Data Science
Machine Learning (ML)- Architecting end-to-end prediction pipelines and managing them
- Scoping projects and mentoring 2-4 people
- Owning parts of the AI and data infrastructure of the organization
- Develop state-of-the-art deep learning/classical models
- Continuously learn new skills and technologies and implement them when relevant
- Contribute to the community through open-source, blogs, etc.
- Take a number of high-quality decisions about infrastructure, pipelines, and internal tooling.
What are we looking for
- Deep understanding of core concepts
- Broader knowledge of different types of problem statements and approaches
- Great hold on Python and the standard library
- Knowledge of industry-standard tools like scikit-learn, TensorFlow/PyTorch, etc.
- Experience with at least one among Computer Vision, Forecasting, NLP, or Recommendation
Systems a must
- A get shit done attitude
- A research mindset and a creative caliber to utilize previous work to your advantage.
- A helping/mentoring first approach towards work
Data Science
R ProgrammingPython
MongoDB- Conducting advanced statistical analysis to provide actionable insights, identify trends, and measure performance
- Performing data exploration, cleaning, preparation and feature engineering; in addition to executing tasks such as building a POC, validation/ AB testing
- Collaborating with data engineers & architects to implement and deploy scalable solutions
- Communicating results to diverse audiences with effective writing and visualizations
- Identifying and executing on high impact projects, triage external requests, and ensure timely completion for the results to be useful
- Providing thought leadership by researching best practices, conducting experiments, and collaborating with industry leaders
What you need to have:
- 2-4 year experience in machine learning algorithms, predictive analytics, demand forecasting in real-world projects
- Strong statistical background in descriptive and inferential statistics, regression, forecasting techniques.
- Strong Programming background in Python (including packages like Tensorflow), R, D3.js , Tableau, Spark, SQL, MongoDB.
- Preferred exposure to Optimization & Meta-heuristic algorithm and related applications
- Background in a highly quantitative field like Data Science, Computer Science, Statistics, Applied Mathematics,Operations Research, Industrial Engineering, or similar fields.
- Should have 2-4 years of experience in Data Science algorithm design and implementation, data analysis in different applied problems.
- DS Mandatory skills : Python, R, SQL, Deep learning, predictive analysis, applied statistics
NodeJS (Node.js)MongoDB
ExpressPersonality fit
Looking to hire a Backend developer, who wakes up every day with the zeal of learning something new - a mind that is always curious. Not only this, he should be proud to have a good experience on algorithms and understand his technology at the atomic level.
Preliminary requirements for the role
- Should understand the architecture of Node Js language, and must have had at least 1 year of solid experience in writing robust code in this language.
- Should be well versed with basic algorithms on ( array, Linked list, stack, queue)- Yes, we do ask questions associated with time and space complexity for the above-mentioned algorithms
- Thorough understanding of MySQL, in that, creating all types of joins ( inner, outer, left, and right) on multiple tables, views, and triggers are a piece of cake for you.
- Further, you should have a decent understanding of database designs so that you can make quick decisions about normalization, inclusion/exclusion of foreign keys, etc
- Should have a decent understanding of code repository tool such as GitHub
- Should be well versed with the basics of AWS ( understanding of cloud architecture would be a plus)
- Should be aware of the commonly used encryption techniques such as JWT, API encryption, Token management, etc
- Exposure to working in E-commerce related applications as well as in a startup environment would be an add on.
• Responsible for designing, deploying, and maintaining analytics environment that processes data at scale
• Contribute design, configuration, deployment, and documentation for components that manage data ingestion, real time streaming, batch processing, data extraction, transformation, enrichment, and loading of data into a variety of cloud data platforms, including AWS and Microsoft Azure
• Identify gaps and improve the existing platform to improve quality, robustness, maintainability, and speed
• Evaluate new and upcoming big data solutions and make recommendations for adoption to extend our platform to meet advanced analytics use cases, such as predictive modeling and recommendation engines
• Data Modelling , Data Warehousing on Cloud Scale using Cloud native solutions.
• Perform development, QA, and dev-ops roles as needed to ensure total end to end responsibility of solutions
COMPETENCIES
• Experience building, maintaining, and improving Data Models / Processing Pipeline / routing in large scale environments
• Fluency in common query languages, API development, data transformation, and integration of data streams
• Strong experience with large dataset platforms such as (e.g. Amazon EMR, Amazon Redshift, AWS Lambda & Fargate, Amazon Athena, Azure SQL Database, Azure Database for PostgreSQL, Azure Cosmos DB , Data Bricks)
• Fluency in multiple programming languages, such as Python, Shell Scripting, SQL, Java, or similar languages and tools appropriate for large scale data processing.
• Experience with acquiring data from varied sources such as: API, data queues, flat-file, remote databases
• Understanding of traditional Data Warehouse components (e.g. ETL, Business Intelligence Tools)
• Creativity to go beyond current tools to deliver the best solution to the problem
Test Case preparations
Lightning( Aura , LWC Components), Apex, Triggers, Process builders
C#- You will be proficient in Agile methodologies of Software Development especially SCRUM.
- You will be able to successfully maintain discipline as informed by your seniors.
- You will regularly attend stand-ups and project discussions.
- You will be proficient in full stack dot net development especially web technologies.
- You will have an intermediate level skill set in web development using .net technology.
- You will have a fair understanding of the testing cycle to improve the quality of the software being developed.
- You will assist in writing software requirements documentation.
- You will assist your seniors in doing business analysis on live projects.
- You will assist in doing software testing as and when required.
- You will attend regular training sessions conducted by your seniors.
- You will strive towards writing better code which is more efficient and is also maintainable.
- You will be proficient in team communication via the official channels such as email, project tracking tools, slack etc.
Follow CutshortShubham Vishwakarma
Full Stack Developer - Averlon