ETL Developer

JLL

Gurugram, HR

5d ago

ETL Developer page is loaded

ETL Developer

locationsGurugram, HRtime typeposted onPosted 18 Days Agojob requisition idREQ223739

ETL Developer

What this job involves :

High level of independence

Do you work independently without close supervision? We can offer you an exciting role where you can use this passion to enhance your skills and play an important role in delivering consistent and qualitative administrative and support tasks for the EPBCS team.

Highest qualitative delivery

ETL Developer / SSIS (SQL Server Integration Services Administrator / developer) will support the EPM Landscape system at JLL.

The developer should lead the design of the logical data model, implement the physical database structure and constructs and implement operational data stores and data marts.

The developer will provide support in functional tasks of medium-to-high technological complexity. The SSIS administrator will provide support in building SSIS packages, transformations, SQL procedures & maximizing the value of SSIS by identifying and recommending functional and technological solutions to improve business processes, provide outbounds in acceptable format & meet internal and external transformation requirements on processes while providing production and end-user support.

Responsibilities

You will be engaged in the below tasks :

Design, develop, and test ETL processes to migrate large data sets from source systems into the Data Warehouse and Data Marts.

Create SSIS packages to clean and load data to the data warehouse and package to transfer data with EPBCS

Filter and cleanse source data with complex store procedures and SSIS packages in the staging area.

Create routines for importing data utilizing comma delimited files.

Map disparate data sources - relational DBs and text files, excel files onto target schema.

Schedule the packages to keep extracting the data at specific time intervals.

Gather requirements and business process knowledge in order to transform the data in a way thats geared towards the needs of end-users.

Plan, coordinate, and support ETL processes including architecting table structure, building ETL process, documentation, and long-term preparedness.

Extract complex data from multiple data sources into usable and meaningful reports and analyses by implementing PL / SQL queries.

Ensure that the data architecture is scalable and maintainable

Work with the business in designing and delivering correct, high-quality data.

Troubleshoot data integration and data quality issues and bugs, analyze reasons for failure, implement optimal solutions, and revise procedures and documentation as needed.

Designs develop, automate, and support complex applications to extract, transform, and load data.

Hands-on SQL features Stored Procedures, Indexes, Partitioning, Bulk loads, DB configuration, Security / Roles, Maintenance

Develop queries and procedures, create custom reports / views, and assist in debugging. You will also be responsible for designing SSIS packages and ensuring their stability, reliability, and performance.

Sounds like you? To apply, you need to have :

Impeccable expertise

Were looking for at least a bachelors degree (or equivalent) or relevant experience

Strong team player - proven success in contributing to a team-oriented environment

Excellent communication (written and oral) and interpersonal skills

Excellent troubleshooting and problem resolution skills

Detail-oriented, self-starter

Immaculate knowledge

You should possess sound computer skills in Microsoft Office (MS Excel, Outlook), Strong Project Management Skills, Excellent Verbal and Written Communication Skills, Strong organizational and interpersonal skills.

5+ yrs. Microsoft SQL Server Management Studio : administration and development experience

Competency in Microsoft Office and Smart View

Experience with Microsoft SQL databases and SSIS / SSAS development.

Demonstrated experience working with Microsoft SSIS to create and deploy packages and deploy for ETL processes.

Demonstrated experience in writing and troubleshooting SQL statements, creating stored procedures, views, and SQL functions

Experience with data analytics and development.

Strong SQL coding experience with performance optimization experience for data queries.

Need to understand and be able to interpret data.

Strong critical and analytical thinking and problem-solving skills

Ability to multi-task and thrive in fast-paced, rapidly changing, and complex environment

Good written and verbal communication skills

Ability to learn new skills quickly to make a measurable difference

Experience creating and supporting SSAS Cubes.

What we can do for you :

At JLL, we make sure that you become the best version of yourself by helping you realize your full potential in an entrepreneurial and inclusive work environment.

We will empower your ambitions through our dedicated Total Rewards Program, competitive pay and benefits package.

Required Skills :

ETL Design, Microsoft SQL Server Analysis Services (SSAS)

Job Tags : JLL Privacy Notice

JLL Privacy Notice

Jones Lang LaSalle (JLL), together with its subsidiaries and affiliates, is a leading global provider of real estate and investment management services.

We take our responsibility to protect the personal information provided to us seriously. Generally the personal information we collect from you are for the purposes of processing in connection with JLLs recruitment process.

We endeavour to keep your personal information secure with appropriate level of security and keep for as long as we need it for legitimate business or legal reasons.

We will then delete it safely and securely.

For more information about how JLL processes your personal data, please view our .

For additional details please see our career site pages for each country.

For employees in the United States, please see a fully copy of our Equal Employment Opportunity and Affirmative Action policy .

Jones Lang LaSalle (JLL) is an Equal Opportunity Employer and is committed to working with and providing reasonable accommodations to individuals with disabilities.

If you need a reasonable accommodation because of a disability for any part of the employment process including the online application and / or overall selection process you may email us at .

Report this job

Thank you for reporting this job!

Your feedback will help us improve the quality of our services.