Senior ETL Developer
Senior ETL Developer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
JLL empowers you to shape a brighter way.
Our people at JLL and JLL Technologies are shaping the future of real estate for a better world by combining world class services advisory and technology for our clients. We are committed to hiring the best most talented people and empowering them to thrive grow meaningful careers and to find a place where they belong. Whether youve got deep experience in commercial real estate skilled trades or technology or youre looking to apply your relevant experience to a new industry join our team as we help shape a brighter way forward.
Senior ETL Developer
What this job involves:
Are you comfortable working independently without close supervision We offer an exciting role where you can enhance your skills and play a crucial part in delivering consistent high-quality administrative and support tasks for the EPM team
The Senior ETL Developer/SSIS Administrator will lead the design of logical data models for JLLs EPM Landscape system. This role is responsible for implementing physical database structures and constructs as well as developing operational data stores and data marts. The role entails developing and fine-tuning SQL procedures to enhance system performance. The individual will support functional tasks of medium-to-high technological complexity and build SSIS packages and transformations to meet business needs. This position contributes to maximizing the value of SSIS within the organization and collaborates with cross-functional teams to align data integration solutions with business objectives.
Responsibilities
The Senior ETL Developer will be responsible for:
- Gathering requirements and processing information to design data transformations that will effectively meet end-user needs.
- Designing developing and testing ETL processes for large-scale data extraction transformation and loading from source systems to the Data Warehouse and Data Marts.
- Creating SSIS packages to clean prepare and load data into the data warehouse and transfer data to EPM ensuring data integrity and consistency throughout the ETL process.
- Monitoring and optimizing ETL performance and data quality.
- Creating routines for importing data using CSV files.
- Mapping disparate data sources - relational DBs text files Excel files - onto the target schema.
- Scheduling the packages to extract data at specific time intervals.
- Planning coordinating and supporting ETL processes including architecting table structure building ETL processes documentation and long-term preparedness.
- Extracting complex data from multiple data sources into usable and meaningful reports and analyses by implementing PL/SQL queries.
- Ensuring that the data architecture is scalable and maintainable.
- Troubleshooting data integration and data quality issues and bugs analyzing reasons for failure implementing optimal solutions and revising procedures and documentation as needed.
- Utilizing hands-on SQL features Stored Procedures Indexes Partitioning Bulk loads DB configuration Security/Roles Maintenance.
- Developing queries and procedures creating custom reports/views and assisting in debugging. The developer will also be responsible for designing SSIS packages and ensuring their stability reliability and performance.
Sounds like you To apply you need to have:
- 8 years of experience in Microsoft SQL Server Management Studio: administration and development
- Bachelors degree or equivalent
- Competency in Microsoft Office and Smart View
- Experience with Microsoft SQL databases and SSIS / SSAS development.
- Experience working with Microsoft SSIS to create and deploy packages and deploy for ETL processes.
- 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.
- Experience creating and supporting SSAS Cubes.
- Knowledge of Microsoft PowerShell and Batch scripting
- Good to have Power BI development experience
- 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
- 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
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.
Apply today!
Location:
On-site Gurugram HRScheduled Weekly Hours:
40Job Tags:
If this job description resonates with you we encourage you to apply even if you dont meet all the requirements. Were interested in getting to know you and what you bring to the table!
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 Candidate Privacy Statement.
For additional details please see our career site pages for each country.
For candidates in the United States please see a full copy of our Equal Employment Opportunity and Affirmative Action policy here.
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 contact us at Accommodation Requests. This email is only to request an accommodation. Please direct any other general recruiting inquiries to our Contact Us page > I want to work for JLL.
Required Experience:
Senior IC
Employment Type
Full-Time
