Position

Application Developer,
Chennai

Location


Chennai

Office Address


Project Description


As part of analytics projects team is going to use Informatica Cloud Data Integration to organization with global, distributed data warehouse details. Team will use cloud-based Power Center, which delivers accessible, trusted, and secure data to facilitate more valuable business decisions. Team will load the data from a source to a target with the help of data synchronization and provide some transformation during transfer.

Responsibilities


    Primary Skills Set - ETL-SSIS

    Job Description
    • Support 24x7
    • Worked Extensively on ETL process using SSIS package.
    • Experience in enhancing and deploying the SSIS Packages from development server to production server.
    • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
    • Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Sub reports, and formatting them.
    • Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.
    • Experience in using variables, expressions and functions and also defining Query for generating drill down reports in SSRS.
    • Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
    • Used MDX to interact with the back end OLAP Services.
    • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
    • Experience in Creation and deployment of cubes on SSAS.
    • Experience in creating indexed views, complex stored procedures, effective triggers and useful functions to facilitate efficient data manipulation and consistent data storage.
    • Supported team in resolving SQL Reporting services, SQL Integration services and T-SQL related issues.
    • Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
    • Experience in writing complex SQL queries involving multiple tables inner and outer joins, stored procedures.
    • Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
    • Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
    • Involved in DBA activities such as backups and restores.

Skills


Must have

    Working in Production Support projects

    ETL SSIS

    Experience in enhancing and deploying the SSIS Packages from development server to production server

    • Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).

    • Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Sub reports, and formatting them.

    • Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports.

Nice to have

    Working in Production support projects

Languages


English: B2 Upper Intermediate

Relocation package


If needed, we can help you with relocation process. Click here for more details: see more details

Work Type


ETL (Informatica, Ab Initio etc.)

Ref Number


VR-57554

Explore More

LoGeek Magazine
icon Logeek Luxoft
Learn more
Events
icon Events Luxoft
Learn more
Relocation Program
icon Relocation Luxoft
Learn more
Referral
Platform
icon Referral Luxoft
Learn more
Students
and Grads
icon Students Luxoft
Learn more

More job opportunities in
ETL (Informatica, Ab Initio etc.)

Specialization Position / Title Location Send to a friend
ETL (Informatica, Ab Initio etc.) Application Developer Chennai, IN
ETL (Informatica, Ab Initio etc.) Senior PL/SQL Developer Chennai, IN
ETL (Informatica, Ab Initio etc.) Datastage Senior Developer Chennai, IN