at Jones Lang LaSalle in Chicago, Illinois, United States
Job Description
Responsibilities
Independently plans, designs, develop, executes and monitor complex data integration activities to support project delivery and daily operation.
Expert in defining, implementing, debugging and optimizing data integration mappings and scripts from a variety of data sources.
Spearheads development of ETL code, metadata definition and models, queries, scripts, schedules, work processes and maintenance procedures and identify opportunities to optimize the sizing, performance and efficiency of existing processes/procedures.
Mentors less experienced analysts on proper standards/techniques to improve their accuracy and efficiency.
Perform the unit testing, system integration testing, regression testing and assist with user acceptance testing.
Articulates business requirements in a technical solution that can be designed and engineered.
Consults with the business to develop documentation and communication materials to ensure accurate usage and interpretation of JLL data.
Develops technical understanding of how the data flows from various source systems and source types to fine tune data integration solution.
Work independently or as part of a team to deliver data warehouse ETL projects.
Adhere to established standards and best practices and provide input for improvement of those processes.
Self-motivated team player who can work with minimal supervision and can adapt to a quickly changing environment.
Maintain a high-volume data warehouse application.
Ability to work on multiple tasks simultaneously, ability to switch between tasks and work in conflicting priorities
Experience & Education
At least 3 to 8 years of relevant experience is desired.
Having a Bachelors/Master's degree in Computer Science/Information Systems from a reputed University
Strong computer science fundamentals.
Strong in communications with business stakeholders:
Requires strong ability to communicate and manage stakeholders, and to drive collaboration between the business team and the various project teams including application support teams, network teams, database teams, and storage and server teams across the regions.
Excellent technical, analytical, and organizational skills.
Effective written and verbal communication skills, including technical writing.
Technical Skills & Competencies
Azure Databricks
ETL knowledge
SQL knowledge
Python
PySpark
SparkSQL
Azure functions
Delta Lake
Azure DevOps CI/CD
Azure Data Factory
Good to have knowledge on ADLS Gen2, Kafka stream processing
Good communication
Self-starter and willingness to learn oher technology including Informatica and Go Anywhere
Must have hands-on experience with commercial Integration products including Informatica PowerCenter 10.x, Data Integration Hub, Power Exchange, Informatica Cloud, Data Quality, Master Data Management, Address Doctor
Must have experience in Windows PowerShell / UNIX Shell Scripting, Control-M to automate the job runs.
Must have basic hands on MSSQL Server Database development experiences including:
Stored Procedures
Explain Plans
Constraints
Views
Materialized Views
Export/Import Utilities
Must have strong knowledge of Software Development Life Cycle including requirement analysis, design, development, testing, and implementation. Hands on experience in performance tuning of sources, targets, mappings and sessions.
Support:
Ability to identify critical system health issue and flag them for discussion and resolution.
Constantly questioning due to fluid processes and complexity of environment.
Proven experience in common support activities including
User Management
Access management
Object... For full info follow application link.
JLL Is an Equal Opportunity Employer JLL is committed to developing and maintaining a diverse workforce. JLL strongly believes in equal opportunity extended to all individuals in all aspects of the employment relationship, including recruitment, hiring, training, promotion, transfer, discipline, layoff, recall and termination without regard to race, color, religion, belief, creed, age, sex, pregnancy or maternity (including childbirth and related conditions), family responsibility (e.g. child care, elder care), nationality, ethnic or national origin or ancestry, citizenship, marital status, civil partner status, sexual orientation, gender identity or expression, transgender status, veteran’s status, genetic information, trade union membership, social position, political view or status as a qualified individual with a disability, protected leave status or any other protected characteristic in accordance with applicable law. The company also endeavors to make reasonable accommodations for known physical or mental limitations of otherwise qualified employees and applicants with disabilities unless the accommodations would impose an undue hardship on the operation of our business and ensures that employment decisions are based only on valid job requirements.
