Data Intelligence/Informatica Developer/Data Engineer

Must Have Skills:· Informatica Developmentf· Power Centre· Python· Data Bricks· Create extracts· SQL query

Day to day responsibilities:· Coding· Attend couple of meetings on project status.· Writing ETL· Working with the testing team to test the output PURPOSE:Understands data needs and advise company on technological resources. Aggregate and analyze various data sets to provide actionable insight. Develop reports, dashboards, and tools for business-users. Develop technical solutions to improve access to data and data usage. Develops and executes ETL code and ensures that the data loading processes are reliable and data quality remains high.

ESSENTIAL FUNCTIONS:• Writes and executes ETL code, primarily complex SQL/NoSQL script, but with a strong ability to leverage other technologies.• Analyzes and validates existing routines and communicates impacts. Assists with data trans-formation, manipulation, and presentation to users.• Works with Business Analysts, Business Intelligence Developers, Infrastructure Architects, and key business users to review, design, and develop data models and ETL processes.• Supports the Software Engineering team with data analysis and validation with extensive SQL queries.• Designs, configures, implements, monitors, and manages all aspects of Data Integration Framework.• Develops and maintains infrastructure systems (e.g., data warehouses, data lakes) including data access APIs. Prepares and manipulates data using multiple technologies.• Provides detailed guidance and performs work related to Modeling Data Warehouse solutions in the cloud OR on-premise. Understands Dimensional Modeling, Denormalized Data Struc-tures, OLAP, and Data Warehousing concepts.• Defines Data Integration best practices for the data management environment.• Takes initiative to meet deliverables

QualificationsTo perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonableaccommodations may be made to enable individuals with disabilities to perform the essential functions.

Education Level: Bachelor's Degree

Education Details: Information Technology or Computer Science or Engineering

Experience: 3 years Hands-on experience with database management systems, ELT/ETL systems, business intelligence tools, defect management and system testing.

In Lieu of EducationIn lieu of a Bachelor's degree, an additional 4 years of relevant work experience is required in addition to the required work experience.

Preferred QualificationsKnowledge, Skills and Abilities (KSAs)Knowledge and understanding of at least one programming language (i.e., SQL, NoSQL, Python)., AdvancedKnowledge and understanding of data exchange formats., AdvancedKnowledge and understanding of database design and implementation concepts., AdvancedAbility to recognize, analyze, and solve a variety of problems., AdvancedKnowledge and understanding of data movement concepts., AdvancedExcellent communication skills both written and verbal. , Advanced

Key Skills

• Python
• SQL